Re: Slow Truncate Table times.
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: EricHutchinson@xxxxxxxxxxx
- Date: Tue, 1 Dec 2009 18:44:55 -0500
Not enough info in your message.
Locally or dictionary managed tablespace?
How many extents in the table you truncate?
What else is running on the system, when you truncate?
Did you try to trace your truncate (with waits)?
Igor N.
On Tue, Dec 1, 2009 at 6:38 PM, Eric Hutchinson
<EricHutchinson@xxxxxxxxxxx>wrote:
> 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:
