Home » RDBMS Server » Server Administration » SGA SIZE (Increase shared pool) (ORACLE 11gR2)  () 1 Vote
SGA SIZE (Increase shared pool) [message #586179] Tue, 04 June 2013 05:35 Go to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
I want to increase my shared pool. my SGA values are as under below.
please advice me the steps.

SELECT NAME,SUM(VALUE)/1024/1024/1024 gb FROM V$SGA
GROUP BY NAME;

Database Buffer 4.8125
Redo Buffers 0.0782623291015625
Variable Size 19.0000001564622
Fixed Size 0.00208648294210434
Re: SGA SIZE (Increase shared pool) [message #586180 is a reply to message #586179] Tue, 04 June 2013 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 57596
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove all SGA parameters (shared_pool_size, sga_max_size, sga_target and other %size ones) and PGA one (pga_aggregate_target) and use memory_max_target and memory_target ones.

Regards
Michel

Re: SGA SIZE (Increase shared pool) [message #586182 is a reply to message #586180] Tue, 04 June 2013 05:53 Go to previous messageGo to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
THANK U SO MUCH..
please tell me .. how i can find memory_max_target and memory_target values & status(enable or disable)?
Re: SGA SIZE (Increase shared pool) [message #586183 is a reply to message #586182] Tue, 04 June 2013 05:58 Go to previous messageGo to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
I can find Memory_max_target=25769803776
Memory_target=0
so please tell me the steps how Memory_target is set?
Re: SGA SIZE (Increase shared pool) [message #586191 is a reply to message #586183] Tue, 04 June 2013 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 57596
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set it to the max you gave.

Regards
Michel
Re: SGA SIZE (Increase shared pool) [message #586248 is a reply to message #586191] Tue, 04 June 2013 15:35 Go to previous message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
thanx
Previous Topic: Upgrade of DB
Next Topic: INVALID satus in dba_registry
Goto Forum:
  


Current Time: Wed Apr 16 01:19:46 CDT 2014

Total time taken to generate the page: 0.15246 seconds