| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trace file name ?
Hi Niall
for now the alter session will do for me, i am appending a little pointer for myself and then also using the alert log write functionality to write a line in there when and for who tracing was enabled and the instance_ora_+spid.trc.
but def agree, would be a nice enhancement, a procedure you can call in dbms_monitor once you enabled tracing to return the trace file name.
George
> Good question and worth an enhancement request IMO.
>
> IF you are tracing a dedicated session AND have alter session privilege
> then
> you can issue ALTER SESSION SET TRACEFILE_IDENTIFIER=<some string> and the
> tracefile name will end with that string. Of course the point of
> DBMS_MONITOR is that a) you don't need to be tracing a dedicated session
> (and hence os pid) and b) you don't require ALTER SESSION so it would seem
> to me eminently sensible to request an enhancement of the DBMS_MONITOR
> package to allow the passing of a tracefile identifier (defaulting to the
> empty string).
>
> In the mean time take a look at the functionality of the trcsess command
> line utility which likely gives you another route to what you want if that
> is identifying the session(s) you just traced.
>
> cheers
>
>
> 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
>>
>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
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!
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 23 2006 - 04:55:03 CST
 |
 |