종이컵통신

col sid for 999
col sql_text for a20
col event for a10
col sid new_value sid
 select
        to_char(h.sample_time,'mi:ss') as sample_time,
        h.session_id as sid,
        h.session_state as st,
        h.sql_id,
        (select sql_text from v$sqlarea a where a.sql_id = h.sql_id) as sql_text, event,
        blocking_session as blocker
 from
        v$active_session_history h
 where
        sample_id = (select max(sample_id) from v$active_session_history)
        and session_id <> userenv('sid')
;