Display Database/Tablespace Size Growth in Graph
 Concept

AWR data automatically keep track of the size growth for database and tablespaces. We can graph size growth for capacity planning purpose.

 Case Study Summary

The following example describes how to retrieve size growth data for both database and tablespace, and then display data in graph using MS Excel.

The list of cases include:

 Case 1: Display database size growth over 6 months

First, we retrieve AWR data about database size. We need to see 6-month data and therefore we choose "By Day" option.

Secondly, we copy/paste these columns to MS Excel spreedsheet, and create line graph there.

 Case 2: Compare tablespace size growth over 6 months

First, we retrieve tablespace size by tablespace name. We need to see 6-month data so we choose "By Day" option.

Secondly, we copy/paste these columns to MS Excel spreedsheet, and create line graph there. We can see compare their growth rate.

Copyright 2011 Actrace. All Rights Reserved.
Home | Product | Case Study | Support | Download | Contact Us