Capacity of rollback segments in Oracle Transaction Processing

Sometimes oracle reports the following error when executing a large transaction: Pl/SQL code ORA-01555: snapshot too old (rollback segment too small) this indicates that the random rollback segment allocated by oracle to this transaction is too small. In this case, you can specify a large rollback segment to ensure the successful execution of this transaction. for example, Pl/SQL code set transaction use rollback segment roll_abc; delete from table_name where... commit; the rollback segment roll_abc is specified to this delete transaction. The commit command cancels the rollback segment after the transaction ends. author hwhuang