RE: WAIT info in event10046 raw traces

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 03 Apr 2001 06:47:32 -0700
Message-ID: <F001.002DF72E.20010403054545@fatcity.com>

Hi Danisment,

It is after each wait. Whether each wait corresponds to a single system call depends on whether the file is multiplexed, and whether Oracle passes large multiblock reads to the operating system in a single call on that platform.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
Sent: Tuesday, 3 April 2001 21:10
To: Multiple recipients of list ORACLE-L

Hello,

When is WAIT information written to event10046 raw trace file, after each WAIT or another mechanism such as cummulative writes after a specified count ?

If it's after each WAIT,for example, we will be able to say, each IO related wait event in trace file is counterpart of one IO system call. and some P3 values will always be 1.

thanks in advance...

Danisment Gazi Unal
Web: http://www.geocities.com/danisment

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal
  INET: danisment_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Apr 03 2001 - 08:47:32 CDT