Remote DBA Plans
Remote DBA Service

Oracle Tips by Burleson

Oracle Rollback Segments

Most systems are not using the parallel instance option of Oracle (called real application clusters, or RAC, in Oracle9i.) Because of this, private, rather than public, rollback segments should be used. This will allow a single rollback segment to be taken offline for consolidation. If you will have large transactions, such as batch updates with numerous updates and adds between commits, a second INIT.ORA file should be created, which brings online a single large rollback segment to be used during batch operations. These limitations may be reduced or mitigated by using the new undo tablespaces in Oracle9i.

This is an excerpt by Mike Ault’s book “Oracle9i Administration & Management”. If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.