Lock (lower)

(2) Unlock Method
Alter system kill session '2010 3';/* 878,177 is Sid, 878 is serial #*/

Select/* + rule */S. username,
Decode (L. type, 'Tm ', 'table lock', 'tx', 'row lock', null) lock_level,
O. Owner, O. object_name, O. object_type,
S. Sid, S. Serial #, S. Terminal, S. Machine, S. Program, S. osuser
From v $ session S, V $ lock l, dba_objects o
Where l. Sid = S. Sid
And l. id1 = O. object_id (+)
And S. osuser = 'okf55657 'and S. Username = 'lbimk _ babilon'
And S. username is not null

Select B. Owner, B. object_name, A. session_id, A. locked_mode from V $ locked_object A, dba_objects B where B. object_id = A. object_id;

Select B. username, B. Sid, B. Serial #, logon_time from V $ locked_object A, V $ session B where a. session_id = B. Sid
And a. session_id = 745;

Alter system kill session '2010 32 ';

Select a. Sid, A. Serial #, C. object_name, A. SQL _id
From v $ session A, V $ locked_object B, all_objects C
Where a. Sid = B. session_id
And B. object_id = C. object_id;

Select spid from V $ Process
Where ADDR = (
Select paddr from V $ session where Sid = 767
);

After finding the corresponding spid, run the kill-9 spid command in the background to kill the OS process.

Lock (lower)