Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: open cursors???

Re: open cursors???

From: Marc Billiet <Marc.Billiet_at_hae.hydro.com>
Date: Mon, 12 Oct 1998 07:36:14 +0100
Message-ID: <3621A35E.3060@hae.hydro.com>


I use this script (I copied the text from a Query Builder file I wrote):

SELECT ALL V$SESSION.SID, V$SESSION.SCHEMANAME,

V$SQLTEXT.HASH_VALUE, V$SQLTEXT.PIECE, V$SQLTEXT.SQL_TEXT,
V$SQLAREA.EXECUTIONS, 
V$SQLAREA.FIRST_LOAD_TIME, V$SESSION.PROGRAM, V$SESSION.OSUSER
FROM V$SESSION, V$OPEN_CURSOR, V$SQLTEXT, V$SQLAREA WHERE ((V$SESSION.SADDR=V$OPEN_CURSOR.SADDR)
 AND (V$SESSION.SID=V$OPEN_CURSOR.SID)
 AND (V$OPEN_CURSOR.ADDRESS=V$SQLTEXT.ADDRESS)
 AND (V$OPEN_CURSOR.HASH_VALUE=V$SQLTEXT.HASH_VALUE)
 AND (V$SQLTEXT.ADDRESS=V$SQLAREA.ADDRESS(+))
 AND (V$SQLTEXT.HASH_VALUE=V$SQLAREA.HASH_VALUE(+)))
ORDER BY V$SESSION.SID ASC, V$SESSION.SCHEMANAME ASC, V$SQLTEXT.HASH_VALUE ASC,
V$OPEN_CURSOR.HASH_VALUE ASC, V$SQLTEXT.PIECE ASC Marc

Ed Lufker wrote:
>
> Hi All:
>
> Can anyone provide info on how you monitor current open curors
> such as how many each user has open??? I found v$open_cursor, but it
> doesn't seem to show how many the session has open.
>
> thanks in advance for any help here
> eddie lufker
Received on Mon Oct 12 1998 - 01:36:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US