Can anyone tell me how to find the No. of Cursors which are Open and their details. The no. of rows in view V$OPEN_CURSOR are more than my limit set in init.ora file so I guess its incorrect. Can Anyone tell me how to find correct no. of actuall OPEN Cursors.
I think the open_cursors init.ora parameter is a value set for a particular session and not a total for all sessions. The value in v$open_cursors is based on a particular session (sid, username) and it should not exceed the value set in init.ora. Can anyone pls correct me if I'm wrong ?
no, the one in sysstat is correct, v$open_cursor shows more than open cursors, in plsql v2 the cursors are not closed once they are used, they are kind of cached. Also v$sysstat shows cursors that are opened but not parsed whereas v$open_cursor shows cursors that are opend and parsed