Re: Does rollback segment matter in the following case?

On Sat, 19 Feb 2000 08:50:45 -0500, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>A copy of this was sent to shimeng_at_my-deja.com
>(if that email address didn't require changing)
>On Sat, 19 Feb 2000 02:38:25 GMT, you wrote:
>
>>If inside one transaction I insert a million records into some table,
>>will there be anything written to the rollback segment? Will the
>>rollback segment be impacted in this situation? From my understanding,
>>the rollback segment is used for storing the old values of records.
>>
>
>Inserts in general will create some undo in the rollback segment (there are rows
>to be removed for the rollback -- we store their rowids.

Don't follow... why are any rows removed?

>there are indexes
>undergoing splits and reshaping -- we store their undo to fix them in the event
>of a rollback)

If the table has no indexes of any kind, including any implicit ones built by constraints, then will there be no rollback activity?

>
>If you are looking for a way to avoid this -- read about direct path inserts in
>the Oracle8 server concepts manual.
>
>>Thanks,
>>
>>Shimeng
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Before you buy.
>
>
>--
>See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
>Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
>Thomas Kyte tkyte_at_us.oracle.com
>Oracle Service Industries Reston, VA USA
>
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Sat Feb 19 2000 - 19:04:38 CST