




Remote DBA services Remote DBA Support Remote DBA RAC Remote DBA Reasons Remote Oracle Tuning Remote DBA Links Oracle DBA Support Oracle DBA Forum Oracle Disaster Oracle Training Oracle Tuning Oracle Training Remote DBA SQL Server Remote MSSQL Consulting Oracle DBA Hosting Oracle License Negotiation

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.

Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider. Get real Remote DBA experts, call
BC Remote DBA today.

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Oracle® is the registered trademark of Oracle Corporation.