Re: Slow Truncate Table times.
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: EricHutchinson@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 1 Dec 2009 15:47:10 -0800 (PST)
Did you look for any locking that might have been going on at the time? The
oddest things can cause locking on tables.
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows
using VMWare!
________________________________
From: Eric Hutchinson <EricHutchinson@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tue, December 1, 2009 4:38:25 PM
Subject: Slow Truncate Table times.
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:
