Home » RDBMS Server » Server Administration » Setting SGA size
Setting SGA size [message #230172] Wed, 11 April 2007 02:33 Go to next message
gajini
Messages: 259
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...
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

Hi,
Go through below link
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:30011178429375



hope this helps
Taj
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: Sat Dec 10 12:34:24 CST 2016

Total time taken to generate the page: 0.04072 seconds