Re: Does rollback segment matter in the following case?

hi

another issue is the transaction isolation level. if other client should not see
your uncommited inserts, than there must be a kind of redirection to the before state
of the table. and i think the rollback segments are the right place to hold this before information

                                                                 regards

thomas

shimeng_at_my-deja.com schrieb:

> 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.
>
> Thanks,
>
> Shimeng
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Feb 23 2000 - 04:12:31 CST