OraFAQ Forum: Server Administration » SGA SIZE (Increase shared pool)

Home » RDBMS Server » Server Administration » SGA SIZE (Increase shared pool) (ORACLE 11gR2) (

) 1 Vote

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

SGA SIZE (Increase shared pool) [message #586179]

Tue, 04 June 2013 05:35

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

Report message to a moderator

Re: SGA SIZE (Increase shared pool) [message #586180 is a reply to message #586179]

Tue, 04 June 2013 05:39

Michel Cadot
Messages: 67745
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

Report message to a moderator