Undo表空间有剩余，却报错无法扩展？
aix+9208警告日记：
Failure to extend rollback segment 57 because of 3113 conditionFULL status of rollback segment 57 set.
Tue Jun 3 09:06:50 2014
FULL status of rollback segment 57 cleared.
Tue Jun 3 09:08:50 2014
Failure to extend rollback segment 57 because of 3113 conditionFULL status of rollback segment 57 set.
Tue Jun 3 09:09:27 2014
Failure to extend rollback segment 180 because of 3113 conditionFULL status of rollback segment 180 set.
Tue Jun 3 09:09:29 2014
FULL status of rollback segment 180 cleared.
Tue Jun 3 09:14:59 2014
TABLESPACE_NAME TOTAL FREE MAX Real Free USED PERCENT
-------------------- ---------- ---------- ---------- ---------- ---------- ----------
UNDOTBS1_A 6100 5891.3125 12000 11791.3125 208.6875 3.42
undo_retention =900
请问
1.为什么还有空余空间，还会无法扩展？
2.rollback segment status=full 是怎么得到的？可以通过什么视图查询？
3.sql如何统计某个rollback segment 的使用率？
页:
[1]