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
WHERE object_id = to_number('9999','XXXX');
That, of course, assumes the object_id you saw was '9999'