| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Wait events
This is a Parallel Query slave waiting to be told what to do.
>From: "Raghunath, Shivaswamy" <Shivaswamy.Raghunath_at_qwest.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Wait events
>Date: Thu, 16 Nov 2000 06:10:43 -0800
>
>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
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>++++++++++++++++++
>Shivaswamy
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Raghunath, Shivaswamy
> INET: Shivaswamy.Raghunath_at_qwest.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).
Share information about yourself, create your own public profile at Received on Thu Nov 16 2000 - 09:12:24 CST
 |
 |