DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: calculating daily/week growth

  1. #1
    Join Date
    Sep 2001
    Location
    London
    Posts
    26

    Smile

    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



  2. #2
    Join Date
    Oct 2000
    Posts
    467
    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
  •  


Click Here to Expand Forum to Full Width