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 ??


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: 4580
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.
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...
Previous Topic: V_$view VS v$views
Next Topic: tunning wizard oracle 9i can not collect schema oracle 7.3.4
Goto Forum:
  


Current Time: Sun May 26 22:23:56 CDT 2024