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
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