Schema Growth Rate on a daily basis

Posted on 2004-08-27
Last Modified: 2013-12-11

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 ...


Question by:vrrajeeb

Expert Comment

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.


Author Comment

ID: 11918186

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 ...



Accepted Solution

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

Community Support Moderator

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
compre toata in where clue oracle 4 55
System.InvalidCastException: Specified cast is not valid 10 67
Oracle SQL 6 47
Oracle Public Synonyms and Privileges 2 51
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now