Re: Rollback extents

From: Paul Dixon <paul.gp.dixon_at_tinnedham.bt.com>
Date: Fri, 28 Jun 2002 12:08:14 +0100
Message-ID: <afhgct$8d3$1@pheidippides.axion.bt.co.uk>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d1c17a8$0$227$ed9e5944_at_reading.news.pipex.net...
> So my normal insert into uses 105 blocks of undo space. The direct load
> insert uses 1.
>
> As for exactly what is recorded in undo/rollback in the case of direct
load
> then I think you are into Jonathan territory.

ISTR from my very first DBA training course that direct loads and insert /*+ APPEND */ insert data above the current high water mark for the table. If that's true then the rollback only needs to to know where the new data starts at in order to undo it. This may also explain why after an insert /*+ APPEND */ Oracle won't let you make any more changes until you have commited or rolledback first.

--
Paul Dixon
paul.gp.dixon_at_tinnedham.bt.com
(Remove canned meat to reply)

Received on Fri Jun 28 2002 - 06:08:14 CDT