Home » RDBMS Server » Performance Tuning » SGA_TARGET and shared pool
SGA_TARGET and shared pool [message #521009] Thu, 25 August 2011 15:05 Go to next message
matthew00
Messages: 7
Registered: October 2005
Junior Member
If I have specify the SGA_TARGET, do I still need to specify the amount of memory for SHARED_POOL_SIZE? I thought once the SGA_TARGET, auto memory management is in place and SHARED_POOL is not neccessary.
Thanks

Report message to a moderator

Re: SGA_TARGET and shared pool [message #521010 is a reply to message #521009] Thu, 25 August 2011 15:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

answer is Oracle version dependent & you decided we did not need to know yours.

Report message to a moderator

Re: SGA_TARGET and shared pool [message #521014 is a reply to message #521009] Thu, 25 August 2011 15:24 Go to previous message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
Probably not. If you do specify it, it sets a minumum size for the shared pool.

Report message to a moderator

Previous Topic: performance doubt
Next Topic: Managing Large Table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:37:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.