v$rollstat 동적뷰를 사용하여 롤백세그먼트의 현재상태도 확인할 수 있음
사용중인 UNDO SEGMENTS의 상태를 알 수 있음 【예제】 SQL> desc dba_rollback_segs; Name Null? Type ----------------------------------------- -------- ---------------------------- SEGMENT_NAME NOT NULL VARCHAR2(30) OWNER VARCHAR2(6) TABLESPACE_NAME NOT NULL VARCHAR2(30) SEGMENT_ID NOT NULL NUMBER FILE_ID NOT NULL NUMBER BLOCK_ID NOT NULL NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NOT NULL NUMBER MAX_EXTENTS NOT NULL NUMBER PCT_INCREASE NUMBER STATUS VARCHAR2(16) INSTANCE_NUM VARCHAR2(40) RELATIVE_FNO NOT NULL NUMBER SQL> select segment_name,tablespace_name,status from dba_rollback_segs; SEGMENT_NAME TABLESPACE STATUS ------------------------------ ---------- ---------------- SYSTEM SYSTEM ONLINE _SYSSMU1$ UNDOTBS1 ONLINE _SYSSMU2$ UNDOTBS1 ONLINE _SYSSMU3$ UNDOTBS1 ONLINE _SYSSMU4$ UNDOTBS1 ONLINE _SYSSMU5$ UNDOTBS1 ONLINE _SYSSMU6$ UNDOTBS1 ONLINE _SYSSMU7$ UNDOTBS1 ONLINE _SYSSMU8$ UNDOTBS1 ONLINE _SYSSMU9$ UNDOTBS1 ONLINE _SYSSMU10$ UNDOTBS1 ONLINE 11 rows selected. SQL>여기서 SYSTEM UNDO SEGMENT는 SYSTEM TABLESPACE에 존재하며, 나머지 UNDO SEGMENTS들은 UNDOTBS1이라는 TABLESPACE에 존재함을 가리킨다.