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

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

 

Question: 

 

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

 

Environment:  

 

CCC 2.x  with Datamanager using Oracle

 

Answer: 

 

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.