DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2000
    My rollback segment r03 has status = full if I query from v$rollstat, but at the same time the status is online from dba_rollback_segs. What does status = full mean? I have total of 4 rollback segments and the other three all have status = online from both v$rollstat and dba_rollback_segs.

  2. #2
    Join Date
    Aug 2000
    status=full means that a transaction attempted to extend that RBS, but the extent allocation failed: ORA-01562. Until ALL transactions using that RBS are completed (commit or rollback), the status=full will persist. This is a "flag" for other transactions to use some other RBS.

    Possible solutions:

    1. Kill all processes using that RBS
    2. Take that RBS offline, then back online
    3. Add a datafile to the RBS - then even the transaction with the error can continue
    4. Bounce the database
    5. start a new transaction, and use that RBS explicitly:
    Set transaction use rollback segment seg_name;
    Oracle DBA and Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.