Results 1 to 3 of 3

Thread: growth rate

  1. #1
    Join Date
    Jun 2003

    Unanswered: growth rate

    Hi all,

    How do i know the growth rate of my database.Which script or query is do
    i need to run?


  2. #2
    Join Date
    Sep 2003
    Virginia, USA

    Re: growth rate

    "The script" is one you write.

    Free space can be monitored using the view DBA_FREE_SPACE, which comes with all Oracle databases. At some time (today) select tablespace_name, sum(bytes)/1048576 "MB" from dba_free_space group by tablespace_name. Write down the results, or put the query into a stored procedure that writes to a table. After some unit of time that you choose, run the query again. How much space was used between times 1 and 2? You can setup a dbms_job to run your query every day.

    The above will not always work because files maybe set to autoexpand. If so, then monitoring free space is difficult if not impossible. You can query view DBA_DATA_FILES periodically to see how much the files have extended themselves. For example, compare the total size of all datafiles (excluding system, temp, undo) this Friday against their size next Friday. This is not accurate at all, since a new extend maybe 99% empy and the operating system does not know this, but this type of query still gives you an idea about how fast your growing.

    Data modeling tools like Oracle Designer and Sybase PowerDesigner ask you to input the expected number of rows for each table, and it will predict your growth rates and max sizes. Similar utilities maybe available outside of data modeling software. Check Oracle and Embarcadero, for two examples, to see what they sell. You might find you already have the software and didn't know it had this capability.
    Author, Oracle Database 10g: From Nuts to Soup

  3. #3
    Join Date
    Jan 2004
    Scottsdale, AZ
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts