Lister les locks sur Oracle
prompt liste des utilisateurs qui lockent des tables select distinct username,sql_text from v$sqlarea,v$session,v$lock where user#=parsing_user_id and v$lock.sid=v$session.sid and username is not null and users_executing > 0 ;
prompt liste des executions sql en cours select distinct username,disk_reads,rows_processed,sql_text from v$sqlarea,v$session where user#=parsing_user_id and username is not null and username not in ('SYS','SYSTEM') and users_executing > 0 ;
Plus un script sql pour lister les locks: lock.sql
{% include_relative .doc/lock.sql %}