Re: Need help locating correct trace file.

Try getting your oracle<SID> process pid from v$process based on your current session. The PID you get here is the pid that the trace file name is generated with.

-Kevin

<afairch_at_phaedo.com> wrote in message news:949ut9$pkq$1_at_nnrp1.deja.com...
> I need help with a script that I am writing to move and rename a
> database. The script currently uses sqlplus to do a "backup control
> file to trace" and then uses the trace file that was created.
>
> The trace file that is created is named something lide ora_PID.trc,
> where PID is the process id of the process that created the file. I
> originally thought that would be the sqlplus pid, but it appears that a
> new process is spawned to write the trace file. Does anyone know a
> simple and more importantly reliable way to determine what process that
> is. My fallback plan is to make some educated guesses based on the date
> and time stamp on the file, but that does leave more room for error
> than I would like.
>
> some (hopefully) helpful information:
> Oracle version: 8.1.6
> OS: Solaris 2.6 (SunOS 5.6)
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Anthony
> afairch_at_phaedo.com
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 19 2001 - 15:12:16 CST