Login or sign up Lost password?
Login or sign up
select sid,event,seconds_in_wait from v$session where username='DONGHUA' and status='ACTIVE'; SID EVENT SECONDS_IN_WAIT---------- ---------------------------------------- --------------- 44 enq: TS - contention 21 SELECT se.username username, 2 se.