| 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; |
stuzer05 / Oracle view locked tables
Last active 3 months ago
Last active 3 months ago
| 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; |