How to count CURRENTLY OPENED CURSORS?

From: <dominica_at_secondhat.com>
Date: 09 Nov 2000 02:45:33 GMT
Message-ID: <8ud33v$bfl$1@secondhat.secondhat.com>

Hi All,

What is the BEST way to count opened cursors currently? (this is talking about Oracle Server 8.1.5 on solaris platform) Please email me directly to:

dominica_at_secondhat.com

Thank a lot in advance,

Dominica Leung

I saw there is a V$open_cursor table in the "dict" table.

But it look like it is accumulative.

Since
I do :

when I do a count(*) from V$open_cursor.

It has 16797.

I know my setting in init_INSTANCENAME.ora

open_cursors = 600

2) Then I saw another table V$SYSSTAT;

I could do this from V$sysstat:

STATISTIC# SUBSTR(NAME,1,30)                   CLASS      VALUE
---------- ------------------------------ ---------- ----------
         0 logons cumulative                       1       1321
         1 logons current                          1        181
         2 opened cursors cumulative               1    4860899
         3 opened cursors current                  1      16709

3)
Or I could run utlbstat.sql and utlestat.sql and get the report:

Statistic
Total

Per Transaction Per Logon Per Second --------------- ------------ ------------ no work - consistent read gets
1468

91.75 1468 146.8

opened cursors

cumulative                                                  93
           5.81           93          9.3

Received on Wed Nov 08 2000 - 20:45:33 CST