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;

 

 

Recommended Posts

Start typing and press Enter to search