GV$CELL_THREAD_HISTORY definition in Oracle Database 11.2
GV$CELL_THREAD_HISTORY

SELECT
  INST_ID,                                 -- INST_ID NUMBER
  CELLNAME,                                -- CELL_NAME VARCHAR2(1024)
  SNAPSHOT_ID,                             -- SNAPSHOT_ID NUMBER
  SNAPSHOT_TIME,                           -- SNAPSHOT_TIME DATE
  THREAD_ID,                               -- THREAD_ID NUMBER
  JOBTYPE,                                 -- JOB_TYPE VARCHAR2(32)
  WAITSTATE,                               -- WAIT_STATE VARCHAR2(32)
  WAITOBJ,                                 -- WAIT_OBJECT_NAME VARCHAR2(32)
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  DATABASE_ID,                             -- DATABASE_ID NUMBER
  INSTANCE_ID,                             -- INSTANCE_ID NUMBER
  SESSION_ID,                              -- SESSION_ID NUMBER
  SESSION_SERIAL_NUM                       -- SESSION_SERIAL_NUM NUMBER
FROM
  X$KCFISOSSN

home |  up