RE: Slow Truncate Table times.
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <EricHutchinson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Dec 2009 09:12:51 -0500
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.
Other related posts:
