Search This Blog

Total Pageviews

Monday, 5 July 2010

How to stop oracle Trace ?

Stop trace dump


1. Get the process number from trace file.

Example :
-rw-rw—- 1 dba 184034 Jan 29 17:02 test_diag_17701.trc

2. 18701 is the process number from trace file.

SQL> oradebug setospid 17701
Oracle pid: 3, Unix process pid: 17701,

SQL> oradebug close_trace;
Statement processed.

No comments:

Oracle DBA

anuj blog Archive