I am trying to retrieve the statement text for the cursors open on my 10.2
Oracle db.

I run this statement with session_cached_cursors set to 0 in my
initialization file:

SQL> select sid,sql_text from v$open_cursor where sid in (select sid from
v$session where machine ='gemisys-dell');

I recieve returns like this:
SID SQL_TEXT
---------- ------------------------------------------------------------
167 table_4_9_1db63_0_0_0
167 table_4_9_1dba9_0_0_0
167 table_4_9_1dba9_0_0_0


what are these cursors?




Eve Elkins
Software Applications Team Lead
Byers Engineering
(404) 497-1525


Oracle LazyDBA home page