What is the diff in 'opened cursors current' and V$OPEN_CURSOR?
We have a problem where our application is hitting 'maximum open cursors exceeded'. I ran the following queries on the database to check what session has the most open cursors:
select distinct(sid),count(*) from v$open_cursor
group by sid
order by count(*)
select s.sid, max(a.value)
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic#
and s.sid (+)= a.sid
and b.name = 'opened cursors current'
group by s.sid
order by max(a.value)
and I found a session in the V$SESSTAT that had a max(value) of 18446744073709551612 (yes, excessive I know!).
This session/SID didn't appear in the V$OPEN_CURSOR view. Why not? What is the difference between 'opened cursors current' in v$sesstat and V$open_cursor? Thanks. Rgds. Sheryl
The Oracle version is 10.2.0.4 patch 18. Rgds. Sheryl
This was a bug fixed in 10.2.0.1 then 'duplicated' in 10.2.0.4.
Bug 10132807: WRONG NUMBER OF 'OPENED CURSORS CURRENT' IN V$SESSTAT DESPITE USING RDBMS 10.2.0. This is still in development.
Click Here to Expand Forum to Full Width