Calculating DB size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Calculating DB size

  1. #1
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32
    Hi,

    Can anyone help me in calculating the exact size of the Db. What are the files and Memory area has to considered in this calculation

    Thanks in advance
    Felix
    DBA

  2. #2
    Join Date
    Feb 2001
    Posts
    49

    Smile database sizing

    Hi Felix,

    We can't go for an exact calculation of an database. Eventhough if we do so , the size of the database is not static.

    Calculating the Size of the database mainly depends on the transaction rate and volume. Make a chart of transaction rate and volume against number of users. And determine the avergage size of a transaction.

    Initialize the storage settings for tablespace and table so that a single row can be accomodated in a block and a transaction can be accomodated in a rollback segment.

    Take care in sizing redo log file. After setting the parameters check for the performance of the database and tune accordingly. Size SGA so that number of hits increases.

    HTH
    I love dba job

  3. #3
    Join Date
    Sep 2000
    Posts
    47
    If you're referring to allocated size, you can sum the sizes of all the datafiles at the OS level ("du -sk" in Unix). If you're referring to utilized size, that is indeed dynamic. A snapshot valid for a particular time could be taken by "select sum(bytes)/(1024*1024) MB from dba_segments".

    Tim

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