1、获取sql_hash_value
select sql_hash_value from v$session where sid in(select session_id from v$locked_object)
2、获取锁表语句
select sql_text from v$sql where hash_value=’sql_hash_value’;
">
select sql_hash_value from v$session where sid in(select session_id from v$locked_object)
select sql_text from v$sql where hash_value=’sql_hash_value’;