Hi Tamas,
V$SQL_CURSOR is providing the number of cursors for the querying session,
but Jon's query, give the current opened cursors for all session. If you
restrict v$sesstat to the sid of your session and v$sql_cursor to status
not 'CURNULL', you will get the same number. That's:
select v
Tamas:
I've done some looking into this issue and I think it depends on what you
want when you say want to know the number of "used" cursors. If you mean
those that have been opened AND parsed, then a count from v$open_cursor will
give you that (for the most part). If, however, you want to know t
Thank you for the anwers.
If I try Jon's version I get a big number that does not seem to be related
to the number of maximum open cursors ( it's much higher).
If I query the V$SQL_CURSOR view, then I get a number the could be the value
I look for.
Could some one shed some light on this?
Rega
V$SQL_CURSOR (Oracle8i). Got this off of my V$ view poster from TUSC. I
believe you just need to select count(*) for the number used.
Ken.
-Original Message-
Sent: Monday, July 23, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Hi,
I would like to know the the number of used
open_cursors is not a sum for the total number of users, but rather the
maximum number of cursors an individual user can have open at any one time
v$open_cursor
SQL> desc v$open_cursor
NameNull?Type
---
SADDR
Try this:
select sum(value) as open_cursors
from sys.v_$sesstat s
, sys.v_$statname n
where s.statistic# = n.statistic#
and n.name = 'opened cursors current';
Jon Walthour
>--- Original Message ---
>From: Szecsy Tamas <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[
Use the view v$open_cursor.
--- Szecsy Tamas <[EMAIL PROTECTED]> a écrit : >
Hi,
>
> I would like to know the the number of used cursors
> at any given time. Is
> there a select statement that does this for me? I
> would like to decide if
> the growing number of concurent users for a given
> d