Solved

Schema Growth Rate on a daily basis

Posted on 2004-08-27
4
1,078 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

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

773 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