Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to estimate a rollback segment size for a big transaction?

396510Jun 10 2003 — edited Jun 10 2003

Oracle 8.1.5. Suppose I have the following statement:
update table_a set col_a = rownum where col_b = 'codeA'
The statement affect 900,000 rows. Type of col_a - float(126).

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2003

Added on Jun 10 2003

#general-database-discussions

1 comment

128 views