Slow Truncate Table times.
- From: "Eric Hutchinson" <EricHutchinson@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Dec 2009 15:38:25 -0800
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
Other related posts:
