Re: Looking for Scripts for Database Month Growth / Tablespace Growth.

From: Sheldon Quinny <sheldonquinny_at_gmail.com>
Date: Wed, 19 Jan 2011 11:30:36 +0300
Message-ID: <AANLkTinswbpPqatyqqy6r0vh6w=++EZ=r-4P127L3kvp_at_mail.gmail.com>



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_at_alghanim.com>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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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.
> ______________________________________________________________________
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 19 2011 - 02:30:36 CST

Original text of this message