关于查询oracle数据库的堵塞问题

select inst_id,event,count(*)
FROM gv$active_session_history
where sample_time >= TO_DATE('2024/07-18 18:50:00', 'yyyy/mm/dd hh24:mi:ss')
AND sample_time <= TO_DATE ('2024/07-18 19.30:00', 'yyyy/mm/dd hh24:mi:ss')
and event is not null
group by inst_id,event order by 3 desc;

查询阻塞
select inst_id,blocking_session,blocking_session_serial#,count(*)
FROM gv$active_session_history
where sample_time >= TO_DATE('2024/07-18 18:50:00', 'yyyy/mm/dd hh24:mi:ss')
AND sample_time <= TO_DATE ('2024/07-18 19.30:00', 'yyyy/mm/dd hh24:mi:ss')
and event='enq: TX - row lock contention'
group by inst_id,blocking_session,blocking_session_serial# order by 4 desc;

select inst_id sample_time,sql_id, session_id,session_serial#,sql_exec_id,sql_exec_start,blocking_session, blocking_session_serial#,blocking_inst_id,MACHINE,event
FROM gv$active_session_history
where sample_time >= TO_DATE('2024/08-05 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
AND sample_time <= TO_DATE ('2024/08-05 00.30:00', 'yyyy/mm/dd hh24:mi:ss')
and session_id=13314 and session_serial#=17831
order by 2 desc;

select SQL_TEXT,SQL_FULLTEXT,SQL_ID,LOADS,FIRST_LOAD_TIME,PLSQL_EXEC_TIME,JAVA_EXEC_TIME,ROWS_PROCESSED,COMMAND_TYPE,PARSING_USER_ID,PARSING_SCHEMA_ID,PARSING_SCHEMA_NAME,KEPT_VERSIONS,ADDRESS,SERVICE,MODULE,MODULE_HASH,ACTION,CPU_TIME,ELAPSED_TIME,OUTLINE_SID,CHILD_ADDRESS,SQLTYPE,REMOTE,OBJECT_STATUS,LITERAL_HASH_VALUE,LAST_LOAD_TIME,PROGRAM_ID,PROGRAM_LINE#,LAST_ACTIVE_TIME 
    from  v$sql where sql_id='2nh1cxjhw57g3'