http://www.itpub.net/forum.php?mod=viewthread&tid=476549
好像不起作用了。
SQL> col name for a12
SQL> select s.usn,n.name,s.extents,s.optsize,s.hwmsize,s.status from v$rollstat s, v$rollname n where s.usn=n.usn;
USN NAME EXTENTS OPTSIZE HWMSIZE STATUS
---------- ------------ ---------- ---------- ---------- ---------------
0 SYSTEM 6 385024 ONLINE
1 _SYSSMU1$ 4 2220032 ONLINE
2 _SYSSMU2$ 3 1171456 ONLINE
3 _SYSSMU3$ 3 1171456 ONLINE
4 _SYSSMU4$ 4 2220032 ONLINE
5 _SYSSMU5$ 3 1171456 ONLINE
6 _SYSSMU6$ 4 2220032 ONLINE
7 _SYSSMU7$ 4 2220032 ONLINE
8 _SYSSMU8$ 4 2220032 ONLINE
9 _SYSSMU9$ 4 2220032 ONLINE
10 _SYSSMU10$ 4 2220032 ONLINE
11 rows selected.
SQL> alter rollback segment system storage(next 2m optimal 4481024);
Rollback segment altered.
SQL> select s.usn,n.name,s.extents,s.optsize,s.hwmsize,s.status from v$rollstat s, v$rollname n where s.usn=n.usn;
USN NAME EXTENTS OPTSIZE HWMSIZE STATUS
---------- ------------ ---------- ---------- ---------- ---------------
0 SYSTEM 6 385024 ONLINE
1 _SYSSMU1$ 4 2220032 ONLINE
2 _SYSSMU2$ 3 1171456 ONLINE
3 _SYSSMU3$ 3 1171456 ONLINE
4 _SYSSMU4$ 4 2220032 ONLINE
5 _SYSSMU5$ 3 1171456 ONLINE
6 _SYSSMU6$ 4 2220032 ONLINE
7 _SYSSMU7$ 4 2220032 ONLINE
8 _SYSSMU8$ 4 2220032 ONLINE
9 _SYSSMU9$ 4 2220032 ONLINE
10 _SYSSMU10$ 4 2220032 ONLINE
11 rows selected.