OraFAQ Forum: Performance Tuning » regarding Large Pool usage ??

Home » RDBMS Server » Performance Tuning » regarding Large Pool usage ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

regarding Large Pool usage ?? [message #171321]

Tue, 09 May 2006 07:08

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

Frank Naude
Messages: 4581
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 15:40:14 CST 2024