high sql version count in 11g
In my 11.1.0.6 database, I always see some very high sql version count for some sql.
SQL> select a.sql_id, a.version_count SQLAREA_CNT, count(*) SHARED_CNT,
sql_text
from v$sqlarea a, v$sql_shared_cursor c
where a.sql_id=c.sql_id
and a.version_count > 100
group by a.sql_id, a.version_count, sql_text having count(*) > 10 ;
SQL_ID SQLAREA_CNT SHARED_CNT
------------- ----------- ----------
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------
8uy4tryp7dams 1009 12
select distinct hostname,agg_interface_snmp, total_modem_count from ws_nodecount where agg_interface_snmp =:"SYS_B_0" an
d hostname=:"SYS_B_1" and R =:"SYS_B_2"