Re: truncate has execessive row cache wait

From: ~Jeff~ <>
Date: Mon, 22 Sep 2008 15:49:31 +1200
Message-ID: <>

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


-- Received on Sun Sep 21 2008 - 22:49:31 CDT

Original text of this message