Working wit ORADEBUG utility for uploading SR to check on slowness:-
************************************************************************
connect / as sysdba
Find OSPID using the below query:-
select p.PID,p.SPID,s.SID, s.SQL_EXEC_START, s.SQL_EXEC_ID, a.sql_text
from v$process p,v$session s, v$sql a
where s.paddr = p.addr
and s.username = ‘&username’ and
a.sql_id=s.sql_id
/
Enabling the trace using ORADEBUG:-
Remember to replace the example ‘9834’ value with the actual os pid.
oradebug setospid (9834)— mention ospid
oradebug unlimit;
oradebug event 10046 trace name context forever,level 12;
oradebug dump errorstack 3;
–wait 30 seconds
oradebug dump errorstack 3;
–wait 30 seconds
oradebug dump errorstack 3;
– wait 20 to 30 minutes just to make sure this isn’t running extremely slow, we will let the 10046 run for a few minutes
oradebug tracefile_name
To disable oradebug tracing once tracing is finished:-
oradebug event 10046 trace name context off;
