Re: Trace file size...

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Mon, 13 Jan 2003 03:18:59 -0800
Message-ID: <F001.0052D7DB.20030113031859@fatcity.com>

On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote:

> My SQL_TRACE is on for instance.

For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you trying to find out?

> What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE.
> wether it is truncated? or it will start writing into another file?

It will end the tracing to the file, and no new file will be started. There will be a message at the end of the file indicating it has reached the max file size.

> Is there a way to recognize, which trace file belongs to which session?

Unless you are running MTS/Shared Server, the trace output begins with something like:

• SESSION ID:(134.58553) 2003-01-13 09:11:02.501

That's SID.SERIAL# inside the parentheses.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jan 13 2003 - 05:18:59 CST