what does status = Full in v$rollstat mean?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: what does status = Full in v$rollstat mean?

  1. #1
    Join Date
    Oct 2000
    Posts
    76
    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.
    J.T.

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    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