NULL';
HTH
Àngel
At 03.15 24/7/01 -0800, you wrote:
>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
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, y
cursors current';
Jon Walthour
>--- Original Message ---
>From: Szecsy Tamas <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/23/01 9:55:24 AM
>
>Hi,
>
>I would like to know the the number of used cursors at any given
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
Szecsy Tamas <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: The number of used cursors?
>Date: Mon, 23 Jul 2001 05:55:24 -0800
>
>Hi,
>
>I would like to know the the number of used cur
cipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/23/01 9:55:24 AM
>
>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 f
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
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 database has reached the
point where the maximum open cursor init ora parameter got to be