Re: Looking for Scripts for Database Month Growth / Tablespace Growth.
- From: Sheldon Quinny <sheldonquinny@xxxxxxxxx>
- To: "Alexey B. Danchenkov" <dabron@xxxxxxxxxxx>
- Date: Wed, 19 Jan 2011 08:14:09 +0300
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:
