Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How many cursors can
I want to determine how many cursors each user session has open. I entered
select s.sid, value "# open cursors" from v$sesstat s, v$statname n
where s.statistic#=n.statistic# and n.name='opened cursors current';
One sid had a value of well over 2000! Max_cursors is set well below that. Is
this the right statistic to determine how many cursors a user has open?
TIA
Cory Brooks
Received on Mon Dec 07 1998 - 17:12:43 CST