无意中发现了这一现象,记录一下...没看到到doc里是否有说明...观查了一下发现,oracle默认只会online10个undo segment
[@more@]SQL> select segment_name,owner,tablespace_name,status,block_id,relative_fno status from dba_rollback_segs;
SEGMENT_NA OWNER TABLESPACE STATUS BLOCK_ID STATUS
---------- ------ ---------- ---------------- ---------- ----------
SYSTEM SYS SYSTEM ONLINE 9 1
_SYSSMU1$ PUBLIC UNDOTBS1 ONLINE 9 2
_SYSSMU2$ PUBLIC UNDOTBS1 ONLINE 25 2
_SYSSMU3$ PUBLIC UNDOTBS1 ONLINE 41 2
_SYSSMU4$ PUBLIC UNDOTBS1 ONLINE 57 2
_SYSSMU5$ PUBLIC UNDOTBS1 ONLINE 73 2
_SYSSMU6$ PUBLIC UNDOTBS1 ONLINE 89 2
_SYSSMU7$ PUBLIC UNDOTBS1 ONLINE 105 2
_SYSSMU8$ PUBLIC UNDOTBS1 ONLINE 121 2
_SYSSMU9$ PUBLIC UNDOTBS1 ONLINE 137 2
_SYSSMU10$ PUBLIC UNDOTBS1 ONLINE 153 2
SEGMENT_NA OWNER TABLESPACE STATUS BLOCK_ID STATUS
---------- ------ ---------- ---------------- ---------- ----------
_SYSSMU11$ PUBLIC UNDOTBS1 OFFLINE 15625 2
_SYSSMU12$ PUBLIC UNDOTBS1 OFFLINE 15641 2
_SYSSMU13$ PUBLIC UNDOTBS1 OFFLINE 15657 2
_SYSSMU14$ PUBLIC UNDOTBS1 OFFLINE 15673 2
_SYSSMU15$ PUBLIC UNDOTBS1 OFFLINE 15689 2
_SYSSMU16$ PUBLIC UNDOTBS1 OFFLINE 15705 2
_SYSSMU17$ PUBLIC UNDOTBS1 OFFLINE 15721 2
_SYSSMU18$ PUBLIC UNDOTBS2 OFFLINE 9 7
_SYSSMU19$ PUBLIC UNDOTBS2 OFFLINE 25 7
_SYSSMU20$ PUBLIC UNDOTBS2 OFFLINE 41 7
_SYSSMU21$ PUBLIC UNDOTBS2 OFFLINE 57 7
SEGMENT_NA OWNER TABLESPACE STATUS BLOCK_ID STATUS
---------- ------ ---------- ---------------- ---------- ----------
_SYSSMU22$ PUBLIC UNDOTBS2 OFFLINE 73 7
_SYSSMU23$ PUBLIC UNDOTBS2 OFFLINE 89 7
_SYSSMU24$ PUBLIC UNDOTBS2 OFFLINE 105 7
_SYSSMU25$ PUBLIC UNDOTBS2 OFFLINE 121 7
_SYSSMU26$ PUBLIC UNDOTBS2 OFFLINE 137 7
_SYSSMU27$ PUBLIC UNDOTBS2 OFFLINE 153 7
28 rows selected.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1047476/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1047476/