查询视图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 <
to_timestamp('20230308 11:30:00', 'YYYYMMDD hh24:mi:ss') and event='enq: TX - row lock contention' and sql_id='gub4hudtz8gsd' order by sample_time asc