<div>
The Oracle 9i DBA Handbook has a project called CC (Comand Center) which enables tracking of things like this. &nbsp;I would look at it and implement the pieces you are interested it. <br />
<br />
You could also select from dba_extents sum(bytes) and group by owner. &nbsp;If you save that to a table you can gather the kind of information you want.<br />
<br />
Stephen 
</div>


The Oracle 9i DBA Handbook has a project called CC (Comand Center) which enables tracking of things like this.  I would look at it and implement the pieces you are interested it.

You could also select from dba_extents sum(bytes) and group by owner.  If you save that to a table you can gather the kind of information you want.

Stephen

<div>
Stephen,<br />
<br />
Thanx for the post ... I haven't used the CC yet ... we are doing the sum(bytes) on a daily basis and saving the results to an excel spredsheet right now ... besides, sum(bytes) will show the total usage from which the previous day's result needs to be subtracted to get the incremental growth ...<br />
<br />
I am more interested in a script that when run will show the data growth based on (grouped by) date for a particular schema ...<br />
<br />
Thanx<br />
<br />
-RJ
</div>


Stephen,

Thanx for the post ... I haven't used the CC yet ... we are doing the sum(bytes) on a daily basis and saving the results to an excel spredsheet right now ... besides, sum(bytes) will show the total usage from which the previous day's result needs to be subtracted to get the incremental growth ...

I am more interested in a script that when run will show the data growth based on (grouped by) date for a particular schema ...

Thanx

-RJ

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is there a way to find the schema growth rate on a daily basis ? The schema has partitioned tables &amp;&nbsp;indexes and I was interested in finding out how much of data has been added (new partitions, tables, indexes etc...) created on a daily basis ...<br />
<br />
Thanx<br />
<br />
-RJ
</div>
</div>


Hi,

Is there a way to find the schema growth rate on a daily basis ? The schema has partitioned tables & indexes and I was interested in finding out how much of data has been added (new partitions, tables, indexes etc...) created on a daily basis ...

Thanx

-RJ

Schema Growth Rate on a daily basis

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.