Oracle LOB locators
03 January 2003 02:00

When examining the sql_text field of the v$open_cursor data dictionary view in Oracle, you may occasionally find yourself seeing sql_text that looks like this: "table_e_400_XXXX_4_0_0". What is this? This OTN article explains what's up. You're seeing open LOB locators. If you see 'table_e' the LOB is open for writing, if it's 'table_4' the LOB is open for reading. What lob is being opened? The number indicated by XXXX above is the object_id. So something like this will shed light on the situation:

SELECT object_name, object_type
  FROM user_objects
 WHERE object_id = to_number('9999','XXXX');