home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!elroy.jpl.nasa.gov!ames!pacbell.com!pacbell!oracle!unrepliable!bounce
- Newsgroups: comp.databases.oracle
- From: kjou@oracle.com (Kathy Jou)
- Subject: Re: Name of trace file currently being written.
- Message-ID: <1992Sep4.004203.2399@oracle.us.oracle.com>
- Sender: Kathy Jou
- Nntp-Posting-Host: dvlpyr
- Organization: Oracle Corporation
- References: <BtwpHz.59J@nntp-sc.Intel.COM>
- Date: Fri, 4 Sep 1992 00:42:03 GMT
- X-Disclaimer: This message was written by an unauthenticated user
- at Oracle Corporation. The opinions expressed are those
- of the user and not necessarily those of Oracle.
- Lines: 25
-
- In article <BtwpHz.59J@nntp-sc.Intel.COM> kortikar@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@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.
-
-