查看导致某个等待事件的sql

���询视图DBA_HIST_ACTIVE_SESS_HISTORY（这个视图保留的时间久）

v$active_session_history（这个视图保留的时间不长）

详细的sql语句可以参考如下

select SAMPLE_TIME             , SESSION_ID              , SESSION_SERIAL#         , SQL_ID                  , SQL_EXEC_START          , EVENT                   ,  BLOCKING_SESSION        , BLOCKING_SESSION_SERIAL#, P1TEXT                  , P1                      , P2TEXT                  , P2                      , P3TEXT                  , P3                      , WAIT_CLASS              , WAIT_TIME               , SESSION_STATE           , TIME_WAITED             , BLOCKING_SESSION_STATUS , BLOCKING_INST_ID        , CURRENT_OBJ#            , CURRENT_FILE#           , CURRENT_BLOCK#          , CURRENT_ROW#            , MACHINE  from  DBA_HIST_ACTIVE_SESS_HISTORY t where  t.SAMPLE_TIME >         to_timestamp('20230308 9:52:00', 'YYYYMMDD hh24:mi:ss')         and          t.SAMPLE_TIME