Oracle Table space is growing full and noted that both the tables TBS_PSL_INDEX_TAB_02 and TBS_PSL_DATA_TAB_02 are closing on the table space.
There seems to be performance deterioration that might be caused due to a big or nearly full table space.
Release : 8.3.5.4
Component : CA Business Service Insight
To check the table spaces on Oracle DB run below commands and consult DB administrator to review further if there are any tables running full.
<<<<TablespacesUsage.sql<<<<
SELECT d.status "Status",d.tablespace_name "Name",d.contents "Type",d.extent_management "Extent Management",
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99,999,990.900') "Size (M)",
TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0) / 1024 / 1024,'99999999.999') || '/' ||
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99999999.999') "Used (M)",
TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0),'990.00') "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes FROM dba_data_files group by tablespace_name) a,
(select tablespace_name, sum(bytes) bytes FROM dba_free_space group by tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND
NOT (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY')
UNION ALL
SELECT d.status "Status",d.tablespace_name "Name",d.contents "Type",d.extent_management "Extent Management",
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99,999,990.900') "Size (M)",
TO_CHAR(NVL(t.bytes, 0) / 1024 / 1024, '99999999.999') || '/' ||
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99999999.999') "Used (M)",
TO_CHAR(NVL(t.bytes / a.bytes * 100, 0), '990.00') "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes FROM dba_temp_files group by tablespace_name) a,
(select tablespace_name, sum(bytes_cached) bytes FROM v$temp_extent_pool group by tablespace_name) t
WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND
d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY'
>>>>TablespacesUsage.sql>>>>