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
|
|
|