Re: Name of trace file currently being written.
From: Kathy Jou <kjou_at_oracle.com>
Date: Fri, 4 Sep 1992 00:42:03 GMT
Message-ID: <1992Sep4.004203.2399_at_oracle.us.oracle.com>
Date: Fri, 4 Sep 1992 00:42:03 GMT
Message-ID: <1992Sep4.004203.2399_at_oracle.us.oracle.com>
In article <BtwpHz.59J_at_nntp-sc.Intel.COM> kortikar_at_mipos2.intel.com () writes:
>Hi
>
>I would like to find out name of trace file currently being written.
>
>set sql_trace true;
>explain plan .......
>set sql_trace false;
>
>I currenlty use "ls -lt /oracle/rdbms/log/*trc | head -1" to find this out.
>I need it for automating tkprof.
>
>Thanks a lot in advance.
>
>Aniruddha Kortikar (kortikar_at_mipos2.intel.com)
The UNIX pid of the process running the explain plan will be a part of the trace file name. The naming convention is <ORACLE pid>_<UNIX pid>.trc dumped in the USER_DUMP_DEST directory.
- Kathy Jou
- Oracle Corp
- Disclaimer: only my opinion.