select a.name, b.extents, b.rssize, b.xacts, b.waits, b.gets,
optsize, status
from v$rollname a, v$rollstat b
where a.usn = b.usn;
NAME EXTENTS RSSIZE XACTS WAITS GETS OPTSIZE STATUS
SYSTEM 4 540672 1 0 51 ONLINE
RB1 2 10240000 0 0 427 10240000 ONLINE
RB2 2 10240000 1 0 425 10240000 ONLINE
RB3 2 10240000 1 0 422 10240000 ONLINE
RB4 2 10240000 0 0 421 10240000 ONLINE
XACTS 表示一个回退段有多少用户在使用. monitoring the number of users per rollback如果不足需要增加rollback segments
Large Transaction时单独给一个大的回退段
commit;
set transaction use rollback segment rb_big;
delete from big_table;
commit;
如果没有指定undo tablespace会使用system tablespace.当心
show parameter undo_tablespace
当需要更多的undo空间时可以简单的增加space给tablespace.
undo_retention可能会使undo表空间扩大很多.使用automatic Undo managemtn cann't use a particular rollback segment.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7301064/viewspace-419061/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7301064/viewspace-419061/