Hi, Yea thanks, send me the schema growth too..that would help also. Thanks. On Wed, Jan 19, 2011 at 11:28 AM, Vladimir Barac <vbarac@xxxxxxxxxxxx>wrote: > Hi > > > > This is what I am using to monitor database growth. > > > > Create this table as user SYSTEM, for example. > > > > *create table DATABASE_SIZE_HIST(tstamp date, gigabytes number(10));* > > > > Then, this procedure as well (under SYSTEM) - you will need direct grant > from sys to system for v$datafile and v$tempfile: > > > > *create or replace procedure database_size_hist_proc as* > > *a number;* > > *b number;* > > *s number;* > > *begin* > > *-- * > > *--* > > * select sum(bytes) into a from v$datafile;* > > *--* > > *--* > > * select sum(bytes) into b from v$tempfile;* > > *--* > > *--* > > * s := round((a+b)/(1024*1024*1024));* > > * insert into database_size_hist values(sysdate, s);* > > *--* > > *--* > > * commit;* > > *end;* > > */* > > > > Schedule this procedure as a daily job. This will provide you information > you need. > > > > You may create similar procedure to monitor schema growth (based on > DBA_SEGMENTS). I may send it as well, if you are interested. > > > > Let me know if I can help you further. > > > > Regards, > > Vladimir Barac > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sheldon Quinny > *Sent:* Tuesday, January 18, 2011 3:08 PM > *To:* Oracle-L Freelists > > *Subject:* Looking for Scripts for Database Month Growth / Tablespace > Growth. > > > > Hi Everyone... > > > I take care of 4 - Oracle 10GR2 Database on Windows Platform. > > I am looking for scripts or ways which can be implemented to monitor the > growth of the tablespaces and database..[Monthly,Yearly so on..] > > Please can someone share with me the Growth Rate Monitoring Methods so I > can get it working out here. > > > Thank you, > Sheldon.. > > > ______________________________________________________________________ > This email has been scanned by the External Email Security System. > ______________________________________________________________________ > > ______________________________________________________________________ > This e-mail message and any attachments to it are for the sole use of the > intended recipients and may contain confidential and privileged information. > This e-mail message and any attachments are the property of Yusuf A. > Alghanim & Sons w.l.l. or any of its subsidiaries or affiliates (“Alghanim > Industries”). Any unauthorized review, use, disclosure, or distribution of > this e-mail message or its attachments is prohibited. Any opinions expressed > in this message are those of the author and do not necessarily reflect the > opinion of Alghanim Industries. If you are not an intended recipient, please > notify the sender by reply e-mail and destroy all copies of the original > message and any attachments. > ______________________________________________________________________ >