GV$ACTIVE_SESSION_HISTORY

SELECT
/*+ no_merge ordered use_nl (s, a) */ 
a.inst_id,               -- INST_ID NUMBER
s.sample_id,             -- SAMPLE_ID NUMBER
s.sample_time,           -- SAMPLE_TIME TIMESTAMP(3)
a.session_id,            -- SESSION_ID NUMBER
a.session_serial#,       -- SESSION_SERIAL# NUMBER
a.user_id,               -- USER_ID NUMBER
a.sql_id,                -- SQL_ID VARCHAR2(13)
a.sql_child_number,      -- SQL_CHILD_NUMBER NUMBER
a.sql_plan_hash_value,   -- SQL_PLAN_HASH_VALUE NUMBER
a.sql_opcode,            -- SQL_OPCODE NUMBER
a.service_hash,          -- SERVICE_HASH NUMBER
decode                   -- SESSION_TYPE VARCHAR2(10)
  (a.session_type, 1, 'FOREGROUND', 2, 'BACKGROUND', 'UNKNOWN'),
decode                   -- SESSION_STATE VARCHAR2(7)
  (a.wait_time, 0, 'WAITING', 'ON CPU'),
a.qc_session_id,         -- QC_SESSION_ID NUMBER
a.qc_instance_id,        -- QC_INSTANCE_ID NUMBER
a.event,                 -- EVENT VARCHAR2(64)
a.event_id,              -- EVENT_ID NUMBER
a.event#,                -- EVENT# NUMBER
a.seq#,                  -- SEQ# NUMBER
a.p1,                    -- P1 NUMBER
a.p2,                    -- P2 NUMBER
a.p3,                    -- P3 NUMBER
a.wait_time,             -- WAIT_TIME NUMBER
a.time_waited,           -- TIME_WAITED NUMBER
a.current_obj#,          -- CURRENT_OBJ# NUMBER
a.current_file#,         -- CURRENT_FILE# NUMBER
a.current_block#,        -- CURRENT_BLOCK# NUMBER
a.program,               -- PROGRAM VARCHAR2(48)
a.module,                -- MODULE VARCHAR2(48)
a.action,                -- ACTION VARCHAR2(32)
a.client_id              -- CLIENT_ID VARCHAR2(64)
FROM
x$kewash s,
x$ash a 
WHERE
s.sample_addr = a.sample_addr and s.sample_id = a.sample_id and s.sample_time = a.sample_time
home |  up  |  mailbox