OraFAQ Forum: Server Administration » Shared pool Free percentage greater than 100

Home » RDBMS Server » Server Administration » Shared pool Free percentage greater than 100 (Oracle 11.1.0.7 on Linux x86-64)

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

Shared pool Free percentage greater than 100 [message #464020]

Mon, 05 July 2010 22:25

suntrupth
Messages: 13
Registered: July 2010

Junior Member

Hi ,

value of "Shared Pool Free %" in v$sysmetric is larger than 100%
SQL> select value, group_id from v$sysmetric where metric_name = 'Shared Pool Free %';
VALUE GROUP_ID
186.45107 2
186.4685382 3

SQL> show parameter shared_pool

NAME TYPE VALUE
-------------- ------------ --
shared_pool_reserved_size big integer 832149913
shared_pool_size big integer 0

SQL> show sga

Total System Global Area 1.0155E+11 bytes
Fixed Size 2163880 bytes
Variable Size 8.1068E+10 bytes
Database Buffers 2.0401E+10 bytes
Redo Buffers 79310848 bytes

Any clue?

Regards,
Suntrupth

[Updated on: Mon, 05 July 2010 22:27]

Report message to a moderator

Re: Shared pool Free percentage greater than 100 [message #464021 is a reply to message #464020]

Mon, 05 July 2010 22:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Any clue?
report a bug to Oracle

mine look more reasonabl

  1* select value, group_id from v$sysmetric where metric_name = 'Shared Pool Free %'
SQL> /

     VALUE   GROUP_ID
---------- ----------
98.7311263	    2
98.7296837	    3

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

[Updated on: Mon, 05 July 2010 22:43]

Report message to a moderator

Re: Shared pool Free percentage greater than 100 [message #464883 is a reply to message #464021]

Sat, 10 July 2010 04:26

suntrupth
Messages: 13
Registered: July 2010

Junior Member

Thanks Blackswan,

I did some research.

The values as derived from "select from v$sysmetric" are directly retrieved from X$KEWMDRMV table.

SQL> select * from X$KEWMDRMV where metricid=2114;

Seems to me that there could have been some spike in the database ( not exactly sure what) could have caused the
values to be high in the X$KEWMDRMV table.

Thanks,
Suntrupth

Report message to a moderator

Previous Topic:	Oracle Processes crashing on VMS -- Critical
Next Topic:	how to check ASM is used

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 12:23:21 CDT 2024