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

Thanks for your reply..

I was looking for something sort of a sql query which can be executed every day or month for Tablespaces through a Batch File Schedule in the Windows Scheduler..

Most of the scripts I run are thru the windows scheduler , so just wanted to keep a count on how big are the tablespaces getting during a month or so...

Thanks..

2011/1/18 Alexey B. Danchenkov <dabron_at_hotmail.com>

> Hi,
>
> You can use DBA_HIST_TBSPC_SPACE_USAGE AWR view to monitor the growth
> trends of the tablespaces and databases. Then you can build visual charts to
> visualize growth trends based on this data using for example dbTrends tool.
> see it here www.spviewer.com
>
> With kind regards,
> Alexey B. Danchenkov
>
>
>
> ------------------------------
> Date: Tue, 18 Jan 2011 15:08:07 +0300
> Subject: Looking for Scripts for Database Month Growth / Tablespace Growth.
> From: sheldonquinny_at_gmail.com
> To: oracle-l_at_freelists.org
>
>
> 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..
>
>
>

--
http://www.freelists.org/webpage/oracle-l