OraFAQ Forum: RAC & Failsafe » corect shared pool size

Home » Server Options » RAC & Failsafe » corect shared pool size

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

corect shared pool size [message #249071]

Tue, 03 July 2007 05:08

asangapradeep
Messages: 128
Registered: October 2005
Location: UK

Senior Member

hi,

i want some clarification as to which of the following values is the correct shared pool size.

Quote:

select sum(bytes/1024/1024) from v$sgastat where pool='shared pool';

SUM(BYTES/1024/1024)
--------------------
348.01165008545

this is same as the value i get from v$sgainfo

Quote:

SQL> select name,bytes/1024/1024 from v$sgainfo;

NAME BYTES/1024/1024
-------------------------------- ---------------
Fixed SGA Size 1.9819869995117
Redo Buffers 6.015625
Buffer Cache Size 612
Shared Pool Size 348
Large Pool Size 4
Java Pool Size 4
Streams Pool Size 48
Granule Size 4
Maximum SGA Size 1024
Startup overhead in Shared Pool 100
Free SGA Memory Available 0

but i've seen where shared pool size is calculated using v$parameter view. when use that i get the following value

Quote:

SQL> select sum(value/1024/1024) from v$parameter where name='shared_pool_size';

SUM(VALUE/1024/1024)
--------------------
244

this is in a RAC environment and i heard that in RAC shared pool also has some additional RAC related things in it. (Global Resource Directory to be precise) and maybe in the v$parameter shows that amount subtracted and v$sgastat doesnt.
So it would help if you could clarify this.

Thank you.

Report message to a moderator