SELECT owner,
object_name,
oracle_username || ' (' || vs.status || ')' ora_user,
os_user_name os_user,
machine SYSTEM,
vlo.process unix,
'''' || vs.SID || ',' || vs.serial# || '''' sid_serial,
vr.NAME roll_name,
TO_CHAR (vs.logon_time, 'YYYY/MM/DD HH24:MI:SS') TIME
FROM v$locked_object vlo,
dba_objects doj,
v$session vs,
v$transaction vt,
v$rollname vr
WHERE vlo.object_id = doj.object_id
AND vs.SID = vlo.session_id
AND vs.taddr = vt.addr
AND vt.xidusn = vr.usn
ORDER BY os_user,
sid_serial,
object_name
Query to find the locked tables in Oracle
Posted by
Hareesh Pothuguntla
| Published on 23 April, 2015
| Categories:
SQL Quries for Apps
| Follow us on Facebook | Twitter | Youtube

56953939
ReplyDeleteKonyaaltı
Tavşanlı
Yıldırım
Aktepe
Dikmen
Fındıklı
Datça
Akdeniz
Hendek
4E074180
ReplyDeleteKepez
Kilyos
Altınova
Nazilli
Torbalı
Kınık
Tepebaşı
Akşehir
Dörtyol
A5652EE0
ReplyDeleteBayındır
Ürgüp
Kozan
Hopa
Nazilli
Şirinyer
Karamürsel
Darıca
Turgutlu
B8CE8B74
ReplyDeleteEreğli
Siverek
Akyaka
Yakuplu
Tepebaşı
İzmit
Kahramankazan
Didim
Dikili