Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: open cursors???
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.OSUSERFROM 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,
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
![]() |
![]() |