Can you send the output after running this SQL on your server
col name form a35
col value form a20
set head off
set feedback off
select ' '||upper(name)name,value
from v$parameter
where name = 'timed_statistics'
/
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 Wed Aug 07 2002 - 23:29:16 CDT
