Re: Tracing Question:

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?

alter session set trace_file_identifier='<anything you choose>' and that string will be included in the filename. It won't however override standard conventions.

-- 
Sybrand Bakker
Senior Oracle DBA