|
-
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
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
|