Re: truncate has execessive row cache wait
Date: Mon, 22 Sep 2008 15:49:31 +1200
if this is DMT, there can be performance issues with large numbers of extents. Very slow recursive lookups hitting sys.uet$ and fet$.
I once had to truncate a table gradually over 24 hrs (..reuse storage..) because it had >30,000 extents, ugh :P
http://www.freelists.org/webpage/oracle-l Received on Sun Sep 21 2008 - 22:49:31 CDT