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

Document ID:  TEC541987
Last Modified Date:  01/26/2016
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Capacity Command Center (with Data Manager)
  • CA Capacity Management (CA Hyperformix)

Components

  • CA DATA MANAGER:HYDMSE
  • CA CAPACITY COMMAND CENTER:HYPCCC
  • CA CURRENT CAPACITY REPORTER:HYPCCR

 

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.

 

 

 

 

 

 

 

 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >