|
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|