Slow Truncate Table times.

From: Eric Hutchinson <EricHutchinson_at_comcast.net>
Date: Tue, 1 Dec 2009 15:38:25 -0800
Message-ID: <33DC8A1E39354066A3240462FB7B9573_at_Ericlaptop>

I have two tables that I periodically truncate and repopulate. I have both tables set to NOLOGGING, to speed up the refresh.  

The two truncate statements usually take about 10 seconds or less, but sometimes it takes 5 minutes or more. The repopulate takes a little over a minute.  

Has anyone seen this before, or know what might cause this behavior?  

• Eric Hutchinson

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 01 2009 - 17:38:25 CST