Database Tuning (MOSC)

MOSC Banner

high sql version count in 11g

edited Sep 21, 2009 11:07PM in Database Tuning (MOSC) 1 commentAnswered
 Hi,

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center