Whats the difference in 'open cursors current' in v$sesstat and v$open_cursors?
We have a problem where our application is hitting 'maximum open cursors exceeded'. I run the following sql on the database:
select distinct(sid),count(*) from v$open_cursor
group by sid
order by count(*)
/
and
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 an SID in the V$SESSTAT that had a max(value) of 18446744073709551612 (yes excessive I know!).
This SID didn't come up in the V$OPEN_CURSORS. Why not? What is the difference between these two views? Thanks. Rgds. Sheryl
group by sid
order by count(*)
/
and
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 an SID in the V$SESSTAT that had a max(value) of 18446744073709551612 (yes excessive I know!).
This SID didn't come up in the V$OPEN_CURSORS. Why not? What is the difference between these two views? Thanks. Rgds. Sheryl
0