Re: Looking for Scripts for Database Month Growth / Tablespace Growth.
- From: Sheldon Quinny <sheldonquinny@xxxxxxxxx>
- To: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- Date: Wed, 19 Jan 2011 09:32:35 +0300
My Applications online 24x7 with an OLTP Database ....where we having DML
activity by the second....
So , the things is , I know the tables are growing and the tablespaces I
just want scripts which would Monitor the Tablespace Growth...
Basically for now I am just concern with Monitoring the Tablesapce Growth
Since I have to forecast the Space Consumption and Submit my recommendation
for more resources..
Thanks.
On Wed, Jan 19, 2011 at 9:02 AM, Subodh Deshpande <
deshpande.subodh@xxxxxxxxx> wrote:
> what is your application basically...
>
> what stephen is saying that is really interesting idea and what Nail is
> saying that is equally true.
> cause rows will be populated only if there are inserts..whether there are
> bulk inserts or updates depends upon the architecture of the application..eg
> in mfg industry or scm I think updates will be more cause you have LRPs
> (long range planning divided into ARP annual opearting plan for that your
> have montly schedules, which all departments monitors) where as if its CRM
> or service support kind/ticketing based application then inserts may be
> more casue your customers are using your products and are giving you
> feedback
>
> for presenetion and supporting your needs/arguments what stephen is saying
> that will be defiantely help you..
> and as dba you should monitor actual data_file size I think the views
> dba_data_files, dba_free_space can be of help
>
>
> On 18 January 2011 17:38, Sheldon Quinny <sheldonquinny@xxxxxxxxx> wrote:
>
>> 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..
>>
>>
>>
>
>
> --
> ==============================
> DO NOT FORGET TO SMILE TODAY
> ==============================
>
Other related posts:
