Home » RDBMS Server » Server Administration » Shared pool Free percentage greater than 100 (Oracle 11.1.0.7 on Linux x86-64)
Shared pool Free percentage greater than 100 [message #464020] Mon, 05 July 2010 22:25 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Oracle Processes crashing on VMS -- Critical
Next Topic: how to check ASM is used
Goto Forum:
  


Current Time: Fri Nov 29 08:33:47 CST 2024