Re: Digging in to trace files

Jonathan Lewis wrote:
> "EdStevens" <quetico_man_at_yahoo.com> wrote in message
> news:1123180332.294038.150170_at_g14g2000cwa.googlegroups.com...
> > Platform: Ora 9.2.0 on Solaris 8
> >
> > Digging into the guts of extended trace, working with Tom Kyte's and
> > Cary Millsap's books. Using MTS, so I know session traces will be
> > potentially scattered across multiple trace files in the bdump
> > directory. This is purely a learning exercise at this point. I've
> > noticed something curious in the trace files. Every so often there
> > will be these entries:
> >
> >
> >
> > *** TRACE DUMP CONTINUES IN FILE
> > /u01/app/oracle/admin/VITXD01/bdump/vitxd01_s000_29793.trc ***
> > /u01/app/oracle/admin/VITXD01/bdump/vitxd01_s000_29793.trc
> >
> > *** TRACE DUMP CONTINUED FROM FILE
> > /u01/app/oracle/admin/VITXD01/bdump/vitxd01_s000_29793.trc ***
> >
> > (You'll probably see some line wrap ... the entries beginning and
> > ending with '***' are a single line in the original)
> >
> > The file referenced in the above messages is the file in which the
> > messages are found. What is this telling me? Is this documented some
> > place that I've missed? Certainly an advanced search of MetaLink and
> > this ng's archives turned up nothing useful.
> >
> > Thanks.
> >
>
> The cues:
> > *** TRACE DUMP CONTINUES IN FILE
> >
> > *** TRACE DUMP CONTINUED FROM FILE
> usually appear when you do:
> alter session set tracefile_identifier = '{something}';
> then the file names reported include the next identifier
> and previous identifier used.
>
> Since setting a tracefile_identifier does not work under
> MTS (the identifier is not appended to the "Snnn" name),
> it is possible that the occasional appearance of these
> comments is due to someone attempting to set a tracefile
> identifier, and Oracle calling the continues/continued code
> without actually changing the file name.
>
> --
> Regards
>
> Jonathan Lewis
>
> Now waiting on the publishers: Cost Based Oracle - Volume 1
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/appearances.html
> Public Appearances - schedule updated 8th July 2005

Ah, and that "someone attempting to set a tracefile identifier" would have been me doing my testing! Thanks for the enlightenment. Received on Mon Aug 15 2005 - 08:56:57 CDT