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

Thread: Calculating DB size

Hybrid View

  1. #1
    Join Date
    Sep 2000

    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

  2. #2
    Join Date
    Feb 2001

    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.

    I love dba job

  3. #3
    Join Date
    Sep 2000
    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".


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