Home / server / Questions / 27807
Accepted
M.N
Asked: 2009-06-18 21:21:32 +0800 CST

Find Current open Cursors in Oracle

  • 772

What is the query to find the no. of current open cursors in an Oracle Instance?

Also, what is the accuracy/update frequency of this data?

I am using Oracle 10gR2

oracle oracle10g

2 Answers

  1. Best Answer

    Try this:

    --total cursors open, by session
select a.value, s.username, s.sid, s.serial#
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';

    I'm not sure but it should be live data.

    From: http://www.orafaq.com/node/758

    • 2

  2. select name, value from v$parameter where upper(name) in ('OPEN_CURSORS') order by name;

    • 1