Gist

Oracle view locked tables
Revisions 1
Likes 0
Forks 0

Give feedback on the new UI Powered by Opengist ⋅ 10ms

user:thomas gists created by user

title:mygist gists with given title

description:sync gists with given description

filename:myfile.txt gists having files with given name

extension:yml gists having files with given extension

language:go gists having files with given language

topic:homelab gists with given topic

all:systemctl search all fields

Login Register

stuzer05 / Oracle view locked tables

Last active 3 months ago

Like 0

Embed

Clone via HTTPS

Clone via SSH

stuzer05 revised this gist 2 years ago · 0d42040

1 file changed, 3 insertions

script.sql (file created)

			@@ -0,0 +1,3 @@
	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;