Re: Trace file name ?
- From: "George" <george@xxxxxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- Date: Thu, 23 Nov 2006 12:55:03 +0200 (SAST)
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxx
>>
>> 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
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
------------------------------------------------
George
george@xxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
