Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tracing Question:

Re: Tracing Question:

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Dec 2006 12:12:01 -0800
Message-ID: <1167423121.199824.56440@48g2000cwx.googlegroups.com>

probashi wrote:
> If I enable tracing using the following
> alter session set sql_trace = true
> the trace file in being generated in user_dump_dest (Oracle Parameter)
> folder and the file names are of the following format
>
> {instance_name}_ora_{process id}.trc
>
> Is there any way I can take the process id off or use a fixed file name?

Oracel does not provide a means to override the generated trace file name. You can however tag the trace files with a label to help make finding the trace files via search easier. You can also figure out the trace file name from within Oracle.

If you use oradebug to generate the trace there is a command to have Oracle display the trace file name.

You can use the above abilities along with a host command in SQLPLus to issue an OS command to rename a datafile.

HTH -- Mark D Powell -- Received on Fri Dec 29 2006 - 14:12:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US