Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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