SQL> select tablespace_name,status,count(*)
2 from dba_rollback_segs
3 group by tablespace_name ,status
4 order by tablespace_name ,status
5 ;
TABLESPACE_NAME STATUS COUNT(*)
------------------------------ ---------------- ----------
SYSTEM ONLINE 1
UNDOTBS1 OFFLINE 66
UNDOTBS1 ONLINE 10
UNDOTBS2 OFFLINE 85
UNDOTBS2 ONLINE 10
SQL>
SQL> select tablespace_name,count(*)
2 from dba_rollback_segs
3 group by tablespace_name
4 order by tablespace_name
5 ;
TABLESPACE_NAME COUNT(*)
------------------------------ ----------
SYSTEM 1
UNDOTBS1 76
UNDOTBS2 95
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1060435/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1060435/