Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Wait events

Wait events

From: Raghunath, Shivaswamy <Shivaswamy.Raghunath_at_qwest.com>
Date: Thu, 16 Nov 2000 07:05:57 -0700
Message-Id: <10682.122241@fatcity.com>


Hi All,

Anybody could throw some light on the KXF? wait events in the following instance, which is contributing to nearly 16% of the total time wait? It is a warehouse on HpUx 11.0 running on 8.1.5
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

++++++++++++++++++
                                                   Top ORACLE Wait
events:INFO                                     16/11/00:08:54
                                                   Sampled since database
startup
                                            	                     Time
Avg
                                             	  No of    Pct of   Waited
Pct of    Wait
Event name                                	  waits    Waits    (secs)
Time     s*100
-----------------------------------		  --------------  -----
----------  ------  --------- -
Parallel Query Idle Wait - Slaves       	 	32,914,912    .40
65,872,165  35.62    200.13 *
slave wait                             	 	98,784,463   1.20
64,932,494  35.11     65.73 *
KXFQ: kxfqdeq - normal deqeue                  157,082,657   1.91
11,177,362   6.04      7.12 *
KXFX: Execution Message Dequeue - Slave     	 6,408,672    .08
10,403,217   5.62     162.33 *
SQL*Net message from dblink                   ,457,249,039  17.68
8,667,458   4.69       .59 *
KXFX: Reply Message Dequeue - Query              4,580,394    .06
7,560,464   4.09     165.06 *

 Coord

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Thu Nov 16 2000 - 08:05:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US