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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: local write wait event

RE: local write wait event

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 18 Oct 2004 15:54:18 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9B25@AABO-EXCHANGE02.bos.il.pqe>


John,

You don't mention a version, but it sounds to me like you'd want to use global temporary tables and avoid the TRUNCATE all together.

-Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John Kanagaraj Sent: Monday, October 18, 2004 3:42 PM
To: oracle-l_at_freelists.org
Subject: RE: local write wait event

KG/All,

>see this during (rarely) Truncating a large table while most of the
>buffers of that table in cache. During TRUNCATEs the session has to a
>local checkpoint and during this process, the session may wait for
>'local write' wait.

We are seeing a number of these waits on a largish Oracle Applications database that has frequent TRUNCATEs some 'temporary' tables that are = used
for Inventory's ATP (Available-To-Promise) processes. Makes sense!

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

Received on Mon Oct 18 2004 - 14:49:47 CDT

Original text of this message

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