How to view the Oracle database lock and unlock

How to view the Oracle database lock and unlock

1. -- View database lock details
2. SelectA. sid, B. serial #, B. username, B. oSUSEr, B. machine, B. program, c. object_name, d. spid,
3. Decode (a. type,
4. 'Mr','Media recovery',
5. 'Rt','Redo thread',
6. 'Non','User name',
7. 'Tx','Transaction',
8. 'TT','Dml',
9. 'Ul','Pl/SQL user lock',
10. 'Dx','Stributed xaction',
11. 'Cf','Control file',
12. 'Is','Instance status',
13. 'Fs','File set',
14. 'Ir','Instance recovery',
15. 'St','Disk space transaction',
16. 'Ts','Temp segment',
17. 'Iv','Library cache invalida-tion',
18. 'LS','Log start or switch',
19. 'Rw','Row wait',
20. 'Sq','Sequence number',
21. 'Te','Extend table',
22. 'TT','Temp table',
23. 'Unknown') Locktype,
24. Decode (a. lmode,
25. 0,'None',
26. 1,'Null',
27. 2,'Row-S',
28. 3,'Row-x',
29. 4,'Share',
30. 5,'S/row-x',
31. 6,'Exclusion','Unknown') Lockmode
32. FromV $ lock a, v $ session B, all_objects c, v $ process d
33.  WhereA. sid = B. sid
34. AndA. typeIn('TT','Tx')
35. AndC. object_id = a. id1
36. AndB. paddr = d. addr;
38. -- Kill the process
39. -- Alter system kill session 'sid, serial #';