Give this query in an other session and see what your session is waiting for.
set feedback on
set head on
col event form a13 trunc head "Event| Waiting For"
col p2 form 99999 trunc
col wait_time form 999 trunc head "Last|Wait|Time"
col program form a13 trunc
col command form a7 trunc head "Command"
col username form a8 trunc
col state form a10
col sid form 999 trunc
col last_call_et form 9999999 trunc head "Last Call|In Secs"
select a.sid,username,b.program program,
decode(command,0,'None',2,'Insert',3,'Select',
6,'Update',7,'Delete',10,'Drop Index',12,'Drop Table',
45,'Rollback',47,'PL/SQL',command) command,
last_call_et,
event,p1,p2,state,wait_time
from v$session_wait a,V$session b
where b.sid=a.sid
order by 1
/
Received on Mon Aug 12 2002 - 23:17:11 CDT
