Re: truncate has execessive row cache wait

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!

2008/9/22 <zhuchao_at_gmail.com>

> 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
>
> -Jeff
>
>
>

--
http://www.freelists.org/webpage/oracle-l