script.sql
· 136 B · MySQL
Raw
SELECT o.object_name, o.object_type, l.session_id, l.locked_mode
FROM v$locked_object l
JOIN dba_objects o ON l.object_id = o.object_id;
| 1 | SELECT o.object_name, o.object_type, l.session_id, l.locked_mode |
| 2 | FROM v$locked_object l |
| 3 | JOIN dba_objects o ON l.object_id = o.object_id; |