Home » RDBMS Server » Performance Tuning » SGA sizing (9.2.0.5)
SGA sizing [message #289279] Thu, 20 December 2007 09:06 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hi,

On what basis should I size my buffer cache and shared pool? Is there a thumb rule or a sort of a matrix to size these parameters for optimal performance for OLTP databases? Any suggestions / documentation will be very helpful

Thank you
K V
Re: SGA sizing [message #289294 is a reply to message #289279] Thu, 20 December 2007 10:23 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.fr/search?hl=fr&q=oracle+sga+sizing&meta=

Using Google with your title give me 16000 answers.
Did you read them all?

Regards
Michel
Previous Topic: shared pool size tunning
Next Topic: Changing Query Approach
Goto Forum:
  


Current Time: Mon Dec 05 13:17:41 CST 2016

Total time taken to generate the page: 0.19269 seconds