Re: Trace file name camouflages!

I'm in the same situation, not urgent, but anyway. Apparently the format is O/S dependent, as the spid is converted to octal or hex on NT and not converted on AIX.
To my amazement it doesn't seem to be possible to get the O/S from any (published) v$ view.

Best regards,

--
Sybrand Bakker, Oracle DBA
Robert Chung <robertch_at_mindspring.com> wrote in message news:384d40dd.62057546_at_news.mindspring.com...
>
>
> I need to programmatically find Oracle database trace file. I can
> find user_dump_dest and server process id (=SPID) by querying Oracle,
> but I am having problem because trace file name can be
> "ora_{SPID}.trc" in one database, "ora_{ORACLE_SID}_{SPID}.trc" in
> other database, while yet another database can have trace file with
> "{ORACLE_SID}_ora_{SPID}.trc" name format. How in the world can I
> find which trace file format a particular database has? I tried
> looking up parameter file with no success. Thank you in advance.
>
>
Received on Tue Dec 07 1999 - 12:46:06 CST