Solved

Schema Growth Rate on a daily basis

Posted on 2004-08-27
4
1,079 Views
Last Modified: 2013-12-11
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
0
Comment
Question by:vrrajeeb
4 Comments
 
LVL 4

Expert Comment

by:andertst
ID: 11917152
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
0
 

Author Comment

by:vrrajeeb
ID: 11918186
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
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 12142990
Submitted to PAQ with points refunded (50)

DarthMod
Community Support Moderator
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question