Setting SGA size [message #230172] |
Wed, 11 April 2007 02:33 |
gajini
Messages: 262 Registered: January 2006
|
Senior Member |
|
|
Hi,
Please clear the following doubt,while setting SGA size for a database creation,which one of the these two,DB_CACHE_SIZE & SHARED_POOL_SIZE should be sized more than other one?
I think always DB_CACHE_SIZE should be sized more when compared to SHARED_POOL_SIZE because database buffer is going to hold the actual data and if it's sized more,i/o will be reduced.
Am i right?If anybody is having other suggesstion or views please let me know.
For creating database of size 20GB,how should i size the db_cache_size & shared_pool_size.
Is there any document,which clearly describes how to set SGA parameters according to database size?
Thanks...
|
|
|
|