Home » Server Options » RAC & Failsafe » corect shared pool size
corect shared pool size [message #249071] Tue, 03 July 2007 05:08 Go to next message
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.
Re: corect shared pool size [message #249088 is a reply to message #249071] Tue, 03 July 2007 06:04 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
answer can be found here

http://sysdba.wordpress.com/2006/03/30/how-to-calculate-the-minimum-size-of-the-shared-pool-in-oracle-10g/
Re: corect shared pool size [message #249203 is a reply to message #249088] Tue, 03 July 2007 11:11 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
sounds good.
Previous Topic: Solaris Compatability Matrix for 10.2.0.2 -> 10.2.0.3 Oracle RAC
Next Topic: Rolling upgrade ASM
Goto Forum:
  


Current Time: Thu Dec 08 02:11:33 CST 2016

Total time taken to generate the page: 0.12788 seconds