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

Hi Alexey,

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@xxxxxxxxxxx>

>  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@xxxxxxxxx
> To: oracle-l@xxxxxxxxxxxxx
>
>
> 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..
>
>
>

Other related posts: