Wednesday, November 9

deleting / closing trace files

Sometimes the trace files in oracle does not close so using oradebug you can close a trace file identifying the process id having a lock on the trace file, use the following commands below.

SQL> oradebug setospid 88874
Statement processed.
SQL> oradebug close_trace
Statement processed.



0 comments:

Post a Comment