SELECT
  sample_id,                               -- SAMPLE_ID NUMBER
  sample_time,                             -- SAMPLE_TIME TIMESTAMP(3)
  is_awr_sample,                           -- IS_AWR_SAMPLE VARCHAR2(1)
  session_id,                              -- SESSION_ID NUMBER
  session_serial#,                         -- SESSION_SERIAL# NUMBER
  session_type,                            -- SESSION_TYPE VARCHAR2(10)
  flags,                                   -- FLAGS NUMBER
  user_id,                                 -- USER_ID NUMBER
  sql_id,                                  -- SQL_ID VARCHAR2(13)
  is_sqlid_current,                        -- IS_SQLID_CURRENT VARCHAR2(1)
  sql_child_number,                        -- SQL_CHILD_NUMBER NUMBER
  sql_opcode,                              -- SQL_OPCODE NUMBER
  sql_opname,                              -- SQL_OPNAME VARCHAR2(64)
  force_matching_signature,                -- FORCE_MATCHING_SIGNATURE NUMBER
  top_level_sql_id,                        -- TOP_LEVEL_SQL_ID VARCHAR2(13)
  top_level_sql_opcode,                    -- TOP_LEVEL_SQL_OPCODE NUMBER
  sql_plan_hash_value,                     -- SQL_PLAN_HASH_VALUE NUMBER
  sql_plan_line_id,                        -- SQL_PLAN_LINE_ID NUMBER
  sql_plan_operation,                      -- SQL_PLAN_OPERATION VARCHAR2(30)
  sql_plan_options,                        -- SQL_PLAN_OPTIONS VARCHAR2(30)
  sql_exec_id,                             -- SQL_EXEC_ID NUMBER
  sql_exec_start,                          -- SQL_EXEC_START DATE
  plsql_entry_object_id,                   -- PLSQL_ENTRY_OBJECT_ID NUMBER
  plsql_entry_subprogram_id,               -- PLSQL_ENTRY_SUBPROGRAM_ID NUMBER
  plsql_object_id,                         -- PLSQL_OBJECT_ID NUMBER
  plsql_subprogram_id,                     -- PLSQL_SUBPROGRAM_ID NUMBER
  qc_instance_id,                          -- QC_INSTANCE_ID NUMBER
  qc_session_id,                           -- QC_SESSION_ID NUMBER
  qc_session_serial#,                      -- QC_SESSION_SERIAL# NUMBER
  event,                                   -- EVENT VARCHAR2(64)
  event_id,                                -- EVENT_ID NUMBER
  event#,                                  -- EVENT# NUMBER
  seq#,                                    -- SEQ# NUMBER
  p1text,                                  -- P1TEXT VARCHAR2(64)
  p1,                                      -- P1 NUMBER
  p2text,                                  -- P2TEXT VARCHAR2(64)
  p2,                                      -- P2 NUMBER
  p3text,                                  -- P3TEXT VARCHAR2(64)
  p3,                                      -- P3 NUMBER
  wait_class,                              -- WAIT_CLASS VARCHAR2(64)
  wait_class_id,                           -- WAIT_CLASS_ID NUMBER
  wait_time,                               -- WAIT_TIME NUMBER
  session_state,                           -- SESSION_STATE VARCHAR2(7)
  time_waited,                             -- TIME_WAITED NUMBER
  blocking_session_status,                 -- BLOCKING_SESSION_STATUS VARCHAR2(11)
  blocking_session,                        -- BLOCKING_SESSION NUMBER
  blocking_session_serial#,                -- BLOCKING_SESSION_SERIAL# NUMBER
  blocking_inst_id,                        -- BLOCKING_INST_ID NUMBER
  blocking_hangchain_info,                 -- BLOCKING_HANGCHAIN_INFO VARCHAR2(1)
  current_obj#,                            -- CURRENT_OBJ# NUMBER
  current_file#,                           -- CURRENT_FILE# NUMBER
  current_block#,                          -- CURRENT_BLOCK# NUMBER
  current_row#,                            -- CURRENT_ROW# NUMBER
  top_level_call#,                         -- TOP_LEVEL_CALL# NUMBER
  top_level_call_name,                     -- TOP_LEVEL_CALL_NAME VARCHAR2(64)
  consumer_group_id,                       -- CONSUMER_GROUP_ID NUMBER
  xid,                                     -- XID RAW(8)
  remote_instance#,                        -- REMOTE_INSTANCE# NUMBER
  time_model,                              -- TIME_MODEL NUMBER
  in_connection_mgmt,                      -- IN_CONNECTION_MGMT VARCHAR2(1)
  in_parse,                                -- IN_PARSE VARCHAR2(1)
  in_hard_parse,                           -- IN_HARD_PARSE VARCHAR2(1)
  in_sql_execution,                        -- IN_SQL_EXECUTION VARCHAR2(1)
  in_plsql_execution,                      -- IN_PLSQL_EXECUTION VARCHAR2(1)
  in_plsql_rpc,                            -- IN_PLSQL_RPC VARCHAR2(1)
  in_plsql_compilation,                    -- IN_PLSQL_COMPILATION VARCHAR2(1)
  in_java_execution,                       -- IN_JAVA_EXECUTION VARCHAR2(1)
  in_bind,                                 -- IN_BIND VARCHAR2(1)
  in_cursor_close,                         -- IN_CURSOR_CLOSE VARCHAR2(1)
  in_sequence_load,                        -- IN_SEQUENCE_LOAD VARCHAR2(1)
  capture_overhead,                        -- CAPTURE_OVERHEAD VARCHAR2(1)
  replay_overhead,                         -- REPLAY_OVERHEAD VARCHAR2(1)
  is_captured,                             -- IS_CAPTURED VARCHAR2(1)
  is_replayed,                             -- IS_REPLAYED VARCHAR2(1)
  service_hash,                            -- SERVICE_HASH NUMBER
  program,                                 -- PROGRAM VARCHAR2(64)
  module,                                  -- MODULE VARCHAR2(48)
  action,                                  -- ACTION VARCHAR2(32)
  client_id,                               -- CLIENT_ID VARCHAR2(64)
  machine,                                 -- MACHINE VARCHAR2(64)
  port,                                    -- PORT NUMBER
  ecid,                                    -- ECID VARCHAR2(64)
  tm_delta_time,                           -- TM_DELTA_TIME NUMBER
  tm_delta_cpu_time,                       -- TM_DELTA_CPU_TIME NUMBER
  tm_delta_db_time,                        -- TM_DELTA_DB_TIME NUMBER
  delta_time,                              -- DELTA_TIME NUMBER
  delta_read_io_requests,                  -- DELTA_READ_IO_REQUESTS NUMBER
  delta_write_io_requests,                 -- DELTA_WRITE_IO_REQUESTS NUMBER
  delta_read_io_bytes,                     -- DELTA_READ_IO_BYTES NUMBER
  delta_write_io_bytes,                    -- DELTA_WRITE_IO_BYTES NUMBER
  delta_interconnect_io_bytes,             -- DELTA_INTERCONNECT_IO_BYTES NUMBER
  pga_allocated,                           -- PGA_ALLOCATED NUMBER
  temp_space_allocated                     -- TEMP_SPACE_ALLOCATED NUMBER
FROM
  GV$ACTIVE_SESSION_HISTORY
WHERE
  inst_id = USERENV('INSTANCE')