Home » RDBMS Server » Server Administration » Setting SGA size
Setting SGA size [message #230172] Wed, 11 April 2007 02:33 Go to next message
Messages: 259
Registered: January 2006
Senior Member

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?

Re: Setting SGA size [message #230180 is a reply to message #230172] Wed, 11 April 2007 02:47 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Go through below link

hope this helps
Previous Topic: How to know redo log member file has already damage in oracle 10g?
Next Topic: Install rdbms 9i in a 10g previous installation
Goto Forum:

Current Time: Mon Oct 24 20:28:59 CDT 2016

Total time taken to generate the page: 0.21391 seconds