Re: Does rollback segment matter in the following case?

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. there are indexes undergoing splits and reshaping -- we store their undo to fix them in the event of a rollback)

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 - 07:50:45 CST