SELECT
  CELL_NAME,                               -- CELL_NAME VARCHAR2(1024)
  SNAPSHOT_ID,                             -- SNAPSHOT_ID NUMBER
  SNAPSHOT_TIME,                           -- SNAPSHOT_TIME DATE
  THREAD_ID,                               -- THREAD_ID NUMBER
  JOB_TYPE,                                -- JOB_TYPE VARCHAR2(32)
  WAIT_STATE,                              -- WAIT_STATE VARCHAR2(32)
  WAIT_OBJECT_NAME,                        -- 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
  GV$CELL_THREAD_HISTORY
WHERE
  INST_ID = USERENV('INSTANCE')