RE: Slow Truncate Table times.
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 2 Dec 2009 09:12:51 -0500
Message-ID: <SNT130-ds5016D0C0CB22A727164C9A6950_at_phx.gbl>
I’ve always found that i/o on the box kills truncate performance. Truncate causes the dirty buffers to be flushed to disk. Metalink note 334822.1 explains the process. I had one process that would truncate all of its tables every five minutes to reload the data. During busy times it would take forever to truncate, changing the process to global temporary tables or even deletes, stopped the problem.
Date: Wed, 2 Dec 2009 09:12:51 -0500
Message-ID: <SNT130-ds5016D0C0CB22A727164C9A6950_at_phx.gbl>
I’ve always found that i/o on the box kills truncate performance. Truncate causes the dirty buffers to be flushed to disk. Metalink note 334822.1 explains the process. I had one process that would truncate all of its tables every five minutes to reload the data. During busy times it would take forever to truncate, changing the process to global temporary tables or even deletes, stopped the problem.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 02 2009 - 08:12:51 CST