Re: Digging in to trace files

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 15 Aug 2005 10:02:55 +0000 (UTC)
Message-ID: <ddpp8e$pn3$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"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

Received on Mon Aug 15 2005 - 05:02:55 CDT