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

Home -> Community -> Usenet -> c.d.o.server -> Re: Digging in to trace files

Re: Digging in to trace files

From: EdStevens <quetico_man_at_yahoo.com>
Date: 15 Aug 2005 06:56:57 -0700
Message-ID: <1124114217.035053.204380@g43g2000cwa.googlegroups.com>

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

Original text of this message

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