Monitoring/Managing table space growth in Capacity Command Center and Datamanager .

Document ID : KB000022315
Last Modified Date : 14/02/2018
Show Technical Document Details




How can I check in Capacity Command Center or Datamanager how much tablespace is available and is used by datamanager database.




CCC 2.x  with Datamanager using Oracle




These Sql queries apply to any Oracle 10g/11g DB to monitor/manage table space growth.

In this query we use DBA_DATA_FILES to extract each tablespace name.

Each data file is listed with the table space and the size of the data file.

We joined in DBA_FREE_SPACE to determine how much free space we have left in our tablespace.

This gives us some idea about future growth.


SELECT a.tablespace_name, a.file_name, a.bytes allocated_bytes, b.free_bytes
FROM dba_data_files a, (SELECT file_id, SUM(bytes) free_bytes FROM dba_free_space b GROUP BY file_id) b
WHERE a.file_id=b.file_id ORDER BY a.tablespace_name;

When you have also installed Capacity Reporter CCR 1.5 you can also use the "Tablespace Reports" from the Diagnostics menu to collect detailed

information about tablespace usage's.