SELECT
  inst_id,                                 -- INST_ID NUMBER
  clock,                                   -- CLOCK NUMBER
  next_ticker,                             -- NEXT_TICKER NUMBER
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  spid,                                    -- SPID VARCHAR2(24)
  logon_user,                              -- LOGON_USER VARCHAR2(30)
  logon_time,                              -- LOGON_TIME DATE
  event,                                   -- EVENT VARCHAR2(64)
  event_id,                                -- EVENT_ID NUMBER
  event#,                                  -- EVENT# NUMBER
  p1text,                                  -- P1TEXT VARCHAR2(64)
  p1,                                      -- P1 NUMBER
  p2text,                                  -- P2TEXT VARCHAR2(64)
  p2,                                      -- P2 NUMBER
  p3text,                                  -- P3TEXT VARCHAR2(64)
  p3,                                      -- P3 NUMBER
  wait_for_scn,                            -- WAIT_FOR_SCN NUMBER
  file_id,                                 -- FILE_ID NUMBER
  call_counter,                            -- CALL_COUNTER NUMBER
  dependent_scn,                           -- DEPENDENT_SCN NUMBER
  statement_scn,                           -- STATEMENT_SCN NUMBER
  commit_wait_scn,                         -- COMMIT_WAIT_SCN NUMBER
  post_commit_scn,                         -- POST_COMMIT_SCN NUMBER
  action_type,                             -- ACTION_TYPE NUMBER
  session_type,                            -- SESSION_TYPE VARCHAR2(13)
  wrc_id,                                  -- WRC_ID NUMBER
  file_name,                               -- FILE_NAME VARCHAR2(31)
  skip_it,                                 -- SKIP_IT VARCHAR2(1)
  dirty_buffers,                           -- DIRTY_BUFFERS VARCHAR2(1)
  dbtime,                                  -- DBTIME NUMBER
  network_time,                            -- NETWORK_TIME NUMBER
  think_time,                              -- THINK_TIME NUMBER
  time_gain,                               -- TIME_GAIN NUMBER
  time_loss,                               -- TIME_LOSS NUMBER
  user_calls,                              -- USER_CALLS NUMBER
  client_os_user,                          -- CLIENT_OS_USER VARCHAR2(15)
  client_host,                             -- CLIENT_HOST VARCHAR2(64)
  client_pid,                              -- CLIENT_PID VARCHAR2(24)
  program                                  -- PROGRAM VARCHAR2(64)
FROM
  X$KECPRT