Select L.Session_Id||','||V.Serial# Sid_Serial,
L.Oracle_Username Ora_User,
O.Object_Name,
O.Object_Type,
Decode(L.Locked_Mode,
0, 'None',
1, 'Null',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share',
5, 'S/Row-X (SSX)',
6, 'Exclusive',
To_Char(L.Locked_Mode)
) Lock_Mode,
O.Status,
To_Char(O.Last_Ddl_Time,'dd.mm.yy') Last_DDL
From Dba_Objects O, Gv$Locked_Object L, V$Session V
Where O.Object_Id = L.Object_Id
And L.Session_Id=V.Sid
Order By 2,3;
------------------------
ALTER SYSTEM KILL SESSION 'SID,SERIAL'; ( '633,857' );
L.Oracle_Username Ora_User,
O.Object_Name,
O.Object_Type,
Decode(L.Locked_Mode,
0, 'None',
1, 'Null',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share',
5, 'S/Row-X (SSX)',
6, 'Exclusive',
To_Char(L.Locked_Mode)
) Lock_Mode,
O.Status,
To_Char(O.Last_Ddl_Time,'dd.mm.yy') Last_DDL
From Dba_Objects O, Gv$Locked_Object L, V$Session V
Where O.Object_Id = L.Object_Id
And L.Session_Id=V.Sid
Order By 2,3;
------------------------
ALTER SYSTEM KILL SESSION 'SID,SERIAL'; ( '633,857' );
No comments:
Post a Comment