STRANGE ENTRIES IN V$OPEN_CURSOR
Why is V$OPEN_CURSOR.SQL_TEXT showing things like "table_4_xxxx_x_x_x_ x"? Most of the entries in V$OPEN_CURSOR look like this. My database clients are JDBC thin drivers against Oracle8i Release 8.1.7 on Sun Solaris 8. For example:
select user_name, count(1) as count, sql_text
from sys.v_$open_cursor
group by user_name, sql_text
order by count;
USER_NAME COUNT SQL_TEXT
--------- ----- ---------------------
ORACLE 1 select user_name, ...
SGMASTER 1 SELECT PROPERTY_N...
SGMASTER 5 INSERT INTO ...
SGMASTER 7 table_4_200_5ee2_0_0_0
SGMASTER 12 table_4_2000_5ed8_0...
SGMASTER 12 table_4_200_5ed8_0_0_0
SGMASTER 12 table_e_400_5ed8_2_0_0
These entries are connected to implicit cursors surrounding LOBs. When you have a LOB open for reading/writing, you will see one of these mysterious entries in V$OPEN_ CURSOR. You can see them with nested tables as well (when you create or access them).