RE: local write wait event
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <john.kanagaraj@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Oct 2004 15:54:18 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of John Kanagaraj
Sent: Monday, October 18, 2004 3:42 PM
To: oracle-l@xxxxxxxxxxxxx
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
** The opinions and facts contained in this message are entirely mine =
and do
not reflect those of my employer or customers **
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
