Re: truncate has execessive row cache wait
Date: Mon, 22 Sep 2008 21:46:47 +1200
I stand corrected - it was actually an "alter table xxx deallocate storage keep xxx" run dozens of times with smaller and smaller keep clauses, following on from a "truncate ... reuse storage"
Sorry, it was quite a few years ago!
> Truncate reuse storage does not touch fet/uet.
> You must be using drop storage that time?
> Sent via BlackBerry by AT&T
> *From*: ~Jeff~ <jifjif_at_gmail.com>
> *Date*: Mon, 22 Sep 2008 15:49:31 +1200
> *To*: <oracledbaquestions_at_gmail.com>; <oracle-l_at_freelists.org>
> *Subject*: Re: truncate has execessive row cache wait
> 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