it is per session, also v$open_cursor dooes not show all open cursors. it shows more than that, the best option to find the number of open cursors is from v$sysstat
select * from v$sysstat where statistic#=3
|
Results 1 to 7 of 7
Thread: how to find open cursorsThreaded View
|
Click Here to Expand Forum to Full Width |