oracle回滚段利用率,回滚段空间使用率一直在增加！-CSDN博客

prompt

prompt =============================

prompt 9i UNDOTBS diagnose:

SELECT * FROM (

SELECT TO_CHAR(BEGIN_TIME,'DD-MON-YY HH24:MI') BEGIN,TO_CHAR(END_TIME,'DD-MON-YY HH24:MI') END,NOSPACEERRCNT,EXPSTEALCNT,EXPBLKRELCNT,EXPBLKREUCNT,UNXPSTEALCNT,UNXPBLKREUCNT,UNXPBLKRELCNT

FROM V$UNDOSTAT

ORDER BY BEGIN_TIME DESC)

WHERE ROWNUM < 12;

SELECT * FROM (

SELECT TO_CHAR(BEGIN_TIME,'DD-MON-YY HH24:MI') BEGIN,TO_CHAR(END_TIME,'DD-MON-YY HH24:MI') END,NOSPACEERRCNT,EXPSTEALCNT,EXPBLKRELCNT,EXPBLKREUCNT,UNXPSTEALCNT,UNXPBLKREUCNT,UNXPBLKRELCNT

FROM V\$UNDOSTAT

ORDER BY BEGIN_TIME DESC)

WHERE ROWNUM < 12;

prompt

prompt =============================

prompt 10g,11g UNDOTBS diagnose:

SELECT * FROM (

SELECT TO_CHAR(BEGIN_TIME,'DD-MON-YY HH24:MI') BEGIN,TO_CHAR(END_TIME,'DD-MON-YY HH24:MI') END,ACTIVEBLKS,UNEXPIREDBLKS,EXPIREDBLKS,NOSPACEERRCNT,EXPSTEALCNT,EXPBLKRELCNT,EXPBLKREUCNT,UNXPSTEALCNT,UNXPBLKREUCNT,UNXPBLKRELCNT,TUNED_UNDORETENTION

FROM V$UNDOSTAT

ORDER BY BEGIN_TIME DESC)

WHERE ROWNUM < 12;

SELECT * FROM (

FROM V\$UNDOSTAT

ORDER BY BEGIN_TIME DESC)

WHERE ROWNUM < 12;