Session browser sessions lock with: "Field 'INST_ID' not found" error for SQL query on Oracle 11.2.0.3 RAC
Just paste the following SQL into the Editor:
SELECT SID,
DECODE (lk.TYPE,
'MR', 'Media Recovery',
'RT', 'Redo Thread',
'UN', 'User Name',
'DX', 'Distributed Xaction',
'CF', 'Control File',
'IS', 'Instance State',
'FS', 'File Set',
'IR', 'Instance Recovery',
'ST', 'Disk Space Transaction',
'TS', 'Temp Segment',
'IV', 'Library Cache
Invalidation',
'LS', 'Log Start or Switch',
'RW', 'Row Wait',
'SQ', 'Sequence Number',
'TE', 'Extend Table',
'TT', 'Temp Table',
'BL', 'Buffer
hash table instance',
'CI', 'Cross-instance function invocation instance',
'CU', 'Cursor bind',
'DF', 'Data file instance',
'DL', 'Direct loader
parallel index create',
'DM', 'Mount/startup db primary/secondary
instance',
'DR', 'Distributed recovery process',
'HW', 'Space management
operations on a specific segment',
'IN', 'Instance number',
'JQ', 'Job
queue',
'KK', 'Thread kick',
'LA', 'Library cache lock instance lock
namespace A',
'LB', 'Library cache lock instance lock namespace B',
'LC', 'Library cache lock instance lock namespace C',
'LD', 'Library cache
lock ins
WORKAROUND:
Please uncheck "use RAC views" at the top of the session browser.
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
