?
Solved

Schema Growth Rate on a daily basis

Posted on 2004-08-27
4
Medium Priority
?
1,092 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: 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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

650 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