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

Thread: growth of my database

  1. 03-15-2001, 12:55 PM #1
    randy
    randy is offline Junior Member
    Join Date
    Mar 2001
    Posts
    82
    Can any one paste a script that will tell me the growth of my database over the months?

    I'm running 8i on RedHat
    Reply With Quote Reply With Quote
  2. 03-15-2001, 01:15 PM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this out

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5616[/url]

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  3. 03-15-2001, 01:18 PM #3
    randy
    randy is offline Junior Member
    Join Date
    Mar 2001
    Posts
    82
    Thank but that only tells me only the size. That is not what I want. I want the growth based on months e.g.

    JAN 100m
    FEB 80m
    MAR 40m, etc

    Reply With Quote Reply With Quote
  4. 03-15-2001, 01:24 PM #4
    mbaliga
    mbaliga is offline Member
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    You can set up a cron job to run on 1st of every month which runs the query and spools the output to a file (append). You can compare with the previous month and see how much the DB has grown.

    There are also some scripts in $ORACLE_HOME/rdbms/admin which allow you to create a schema to keep track of the space.

    Baliga
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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