v$rollstat ÂüÁ¶
¡¼¿¹Á¦¡½
SQL> desc v$rollname;
Name Null? Type
----------------------------------------- -------- ----------------------------
USN NUMBER
NAME NOT NULL VARCHAR2(30)
SQL> select * from v$rollname;
USN NAME
---------- ------------------------------
0 SYSTEM
1 _SYSSMU1$
2 _SYSSMU2$
3 _SYSSMU3$
4 _SYSSMU4$
5 _SYSSMU5$
6 _SYSSMU6$
7 _SYSSMU7$
8 _SYSSMU8$
9 _SYSSMU9$
10 _SYSSMU10$
11 rows selected.
SQL>
¿©±â¼
USN : Undo Segment Number·Î ROLLBACK SEGMENTÀÇ ¹øÈ£ÀÓ
NAME : ROLLBACK SEGMENTÀÇ À̸§