Re: sql trace - forward attribution

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Mon, 05 Jan 2004 13:24:32 -0800
Message-ID: <F001.005DBB9E.20040105132432@fatcity.com>

Tanel,

What I see in the trace file header is something like the following:

...
*** SESSION ID:(22.9304) 2003-12-29 15:04:45.743 ...

Which is sid.serial# isn't it?

If "session switching" occurs, handled by the same shadow process and the new session with a different sid.serial# continues to write to the **same** trace file... wouldn't you expect to see line similar to the above, but with a new sid.serial# in it?

• Tanel Poder <tanel.poder.003_at_mail.ee> wrote: > Trace file has server process number in it's name,
  > not session number, thus
  > as long as the sessions are served by the same
  > server process, the contents
  > will be written into one single file.
  >
  > Tanel.
  >
  > ----- Original Message -----
  > To: "Multiple recipients of list ORACLE-L"
  > <ORACLE-L_at_fatcity.com>
  > Sent: Monday, January 05, 2004 10:49 PM
  >
  >
  > > Right, but the new session (that inherits the sql
  > > trace attribute) - wouldn't it produce a
  > **separate**
  > > trace file? In my case there's only one trace file
  > > with sid.serial# clearly stated at the begining of
  > the
  > > trace file and WAIT #0 scattered all over the t
  > race....
  === message truncated ===

  ---

Post your free ad now! http://personals.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  INET: boris_dali_at_yahoo.ca

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 05 2004 - 15:24:32 CST