Calculating growth rate of ts 1

[gatetec]

I have a ts named I_OMF, and it is growing so fast. How do you figure out the daily growth rate in MB for past 30 days?
Is there a script to figure that out?

thx much

 

[SantaMufasa]

Gatec,

Earlier this year (on July 2), I responded to your question in thread759-1383901. That thread contains the code for a script that offers full disclosure of details relating to tablespace sizes via their underlying files.

If you want to track the growth of your tablespaces, you can run that script daily to monitor tablespace growth. You can store the results in either a spreadsheet or an Oracle table.

Also, you can automate such a task by modifying that script to update an Oracle table that tracks the growth and setting up the script to run as either an Oracle job to run via the Oracle Agent or you can use a cron job (Unix) or a Schedule Task (Windows) to run daily.

Let us know your thoughts,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[gatetec]

ok!!! It reminds me!!1