From oracle-l-bounce@freelists.org Wed May 5 08:39:11 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45Dck708078 for ; Wed, 5 May 2004 08:38:56 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i45Dca608035 for ; Wed, 5 May 2004 08:38:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5FD3472CE9E; Wed, 5 May 2004 08:28:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25385-98; Wed, 5 May 2004 08:28:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99E2272D0AC; Wed, 5 May 2004 08:28:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 08:27:21 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7431072CF27 for ; Wed, 5 May 2004 08:27:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25850-10 for ; Wed, 5 May 2004 08:27:17 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3CC3972CFF2 for ; Wed, 5 May 2004 08:27:16 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 5 May 2004 13:42:22 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00577@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: PX Deq Waits Date: Wed, 5 May 2004 08:39:38 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4427 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Deen Here is what Jonathan Lewis wrote about PX Deq Waits: http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0205/ora-020531/ora02051804 _06040.html Jared - Google strikes again! Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of deen dayal Sent: Tuesday, May 04, 2004 4:25 PM To: oracle-l@freelists.org Subject: PX Deq Waits Hi, I ran statspack report against one of my production databases(9.2.0.3) and following is part of it. Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- CPU time 1,596 55.05 PX Deq: Table Q qref 496 991 34.20 db file sequential read 25,700 143 4.95 db file scattered read 22,133 104 3.58 latch free 2,015 28 .96 ------------------------------------------------------------- 34.2% of time is spent on "PX Deq: Table Q qref", I do not know any thing about this event. I searched metalink, did not find much except that it is a parallel query related. The weird thing is we do not run much of parallel queries and yet this event appears on the report every time I run it. Does anybody know any thing about this wait event?? Here is my Instance Summary from statspack report Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 92.21 In-memory Sort %: 100.00 Library Hit %: 98.13 Soft Parse %: 93.91 Execute to Parse %: 1.41 Latch Hit %: 99.79 Parse CPU to Parse Elapsd %: 78.44 % Non-Parse CPU: 95.70 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 77.89 75.72 % SQL with executions>1: 66.56 72.19 % Memory for SQL w/exec>1: 99.59 99.59 Thanks Deen ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------