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: 65090
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: Thu Jul 27 12:27:07 CDT 2017

Total time taken to generate the page: 0.05785 seconds