Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trace file name ?

Re: Trace file name ?

From: goran bogdanovic <goran00_at_gmail.com>
Date: Thu, 23 Nov 2006 18:49:59 +0100
Message-ID: <6d0a3ba80611230949l618c5cf0jcb88afe3cafc329a@mail.gmail.com>


Hi,
With the dbms_monitor package, tracing can be enabled for: client identifier, service name/module/action name and session. In such case, the trace information can be written in more than one trace file and the best will be to use trcsess utility to collect trace information from different files in one output file. As the trace file input for trcsess utl. you can use wild card to specify all trace files in the working dir. (if not possible to find out trace files of interest). Check the Performance and Tuning Guide, this stuff is quite good explained.

HTH,
Goran

On 11/23/06, George <george_at_mighty.co.za> wrote:
>
> Hi all
>
> how do you get the file name of the trace file being produced when you
> enabled tracing via dbms_monitor.
>
> don't see a function in dbms_monitor.
>
>
> ------------------------------------------------
> George
>
> george_at_mighty.co.za
>
> You Have The Obligation to Inform One Honestly of the risk, And As a
> Person
> You Are Committed to Educate Yourself to the Total Risk In Any Activity!
> Once Informed & Totally Aware of the Risk,
> Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
>
>
>
> -------------------------------------------
> For super low premiums, click here http://www.webmail.co.za/dd.pwm
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 23 2006 - 11:49:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US