Lock (lower), lock (
(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.
What is a small hole under the lock?
The holes below the lock are the locks and the key is inserted.
Except for the lock hole, there is a small spring in the machine spring hole next to it,
Without these small holes with Small Springs, any key can be locked ~~
How can I set a password prompt in the locked status in Win7?
Open the control panel-User Account and home security-change the WINDOWS Password and use the prompt to change the password.