Home » RDBMS Server » Performance Tuning » regarding Large Pool usage ??
regarding Large Pool usage ?? [message #171321] Tue, 09 May 2006 07:08 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
i would like to know regarding the LARGE_POOL.

I dont have Shared Servers but yet there is a Large Pool configured of around 50MB
will this be a waste (ie. allocated but unused)
or
will Oracle adjust accordingly and give this 50MB to Shared Pool ??

Report message to a moderator

Re: regarding Large Pool usage ?? [message #171328 is a reply to message #171321] Tue, 09 May 2006 07:29 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
If you are running 10g, set LARGE_POOL=0 and enable SGA_TARGET. This will allow Oracle to automatically size those areas.

Report message to a moderator

Re: regarding Large Pool usage ?? [message #171449 is a reply to message #171328] Wed, 10 May 2006 01:41 Go to previous message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
looking from 9i perspective...

Report message to a moderator

Previous Topic: V_$view VS v$views
Next Topic: tunning wizard oracle 9i can not collect schema oracle 7.3.4
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 14:04:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.