From oracle-l-bounce@freelists.org Tue Jun 21 12:53:44 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LHrhOx019184 for ; Tue, 21 Jun 2005 12:53:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5LHrfNi019176 for ; Tue, 21 Jun 2005 12:53:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 97E751C2DCF; Tue, 21 Jun 2005 11:50:13 -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 06647-01; Tue, 21 Jun 2005 11:50:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C8701C2DE2; Tue, 21 Jun 2005 11:50:13 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: write complete waits Date: Tue, 21 Jun 2005 09:48:23 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: write complete waits Thread-Index: AcV2bNJpKKOUZs8+QhKCUpx2Qer5sgAE8f2A From: "Kevin Closson" To: Cc: X-archive-position: 21423 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kevinc@polyserve.com Precedence: normal Reply-To: kevinc@polyserve.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 > >How would the blocks of temporary tablespace get dirty when >they are only used for sort segments etc. that is by definition, dirty. Just be glad that this I/O burden is no longer backgrounded to DBWR...having the shadow processes do direct path writes is quite an improvement in Oracle. If you gave us some info about the platform, and particularly where the TEMP files are (fs type, etc), we could likely help out. A general idea of processor utilization would help as well. Kevin Closson Chief Architect, Database Solutions PolyServe www.polyserve.com > >Naveen > >--- David Sharples wrote: > >> http://www.ixora.com.au/tips/mystery.doc >> >> On 6/21/05, Naveen >> wrote: >> > Hi All, >> >> > >> > Please let me know what might be causing the high >> wait >> > times as well as high frequency of the wait. >> > >> > Naveen >> > > > > >__________________________________ >Yahoo! Mail >Stay connected, organized, and protected. Take the tour: >http://tour.mail.yahoo.com/mailtour.html > >-- >http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l