RE: I/O EVENTS

0.010340 second ~ 10/1,000 second = 10ms (= 1/100 second)

If the number had been on the order of 0.001 (1ms) or less, it would've looked more IPC-like.

 
Cary Millsap
Hotsos Enterprises, Ltd.
cary.millsap_at_hotsos.com
http://www.hotsos.com

-----Original Message-----
Sent: Wednesday, May 22, 2002 7:38 PM
To: Multiple recipients of list ORACLE-L

> the latency per call on the "SQL*Net message
> from client" event looked suspiciously LAN-like
> (order of 10ms), not IPC-like (order of 1ms or less)

> Oracle Kernel Event Duration Calls Avg
> ------------------------------ ------------------ -------- ----------
> SQL*Net message from client 984.01s 49.6% 95,161 0.010340s

Cary,

To me it looks like the average wait is about one hundredth of a second. I
must be missing something.

• Greg

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

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: Cary Millsap
  INET: cary.millsap_at_hotsos.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).