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