Release : 8.3.5.4
Component : CA Business Service Insight
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.
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>>>>