------------------- Check which users are currently using data
Select osuser, A. username, cpu_time/executions/1000000 |'s ', SQL _fulltext, Machine
From v $ session A, V $ sqlarea B
Where a. SQL _address = B. Address order by cpu_time/executions DESC;
-------------------- Why SQL statements cause table lock
Select L. session_id Sid,
S. Serial #,
L. locked_mode,
L. oracle_username,
S. User #,
L. OS _user_name,
S. machine,
S. Terminal,
A. SQL _text,
A. Action
From v $ sqlarea A, V $ session S, V $ locked_object L
Where l. session_id = S. Sid
And S. prev_ SQL _addr = A. Address
Order by SID, S. Serial #;
-------------------- View locked objects and Unlock methods
(1) locked object
Select a. Sid, A. Serial #, C. object_name, B. oracle_username, B. OS _user_name
From
V $ session,
V $ locked_object B,
V $ PROCESS p,
All_objects C
Where
A. Process = B. Process and
A. paddr = P. ADDR and
B. object_id = C. object_id;
Lock (up)