-
Hi everyone
I need to try and calculate the daily growth in my production database. Is there an easy way of doing this?? I keep an eye on the tablespace growth but need to know if there is a more simplified way of doing this.
Any suggestions and followups would be most appreciated
Thanks
Bruce
-
We're using Iwatch (Third party monitoring tool) for that. I don't find that as quite impressive but what i do is create a temp table and take the space occupied of the tablespaces (total size - free space) and store them. This way you can also get your HWM for the the tablespaces.
You can set up a cron for populating the temp table say once a week or once a month depending on yor requirements.
Hope that helps.
Regards,
a typical structure for the temp table would be
date
tablespace name
space occupied
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|