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

Report message to a moderator

Re: SGA sizing [message #289294 is a reply to message #289279] Thu, 20 December 2007 10:23 Go to previous message
Michel Cadot
Messages: 68665
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 09:37:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.