上次查询seg$表,发现了有一种段类型为save undo,顺便上网查了下,记录分享一下
看tom 的回答
save undo is undo saved for offlined tablespaces. It is also known as deferred rollback
A "Deferred Rollback" segment is created for a tablespace
when a tablespace is taken offline. Undo records are written
to the deferred rollback segment of a tablespace when undo is being applied to a
tablespace which is offline, hence, the undo
cannot be applied.
The undo stored in the deferred rollback segment is applied when
the tablespace comes back online. The deferred rollback segment
is automatically removed after the undo has been applied.
Deferred rollback segments always reside in the system tablespace.
试验一下
看tom 的回答
save undo is undo saved for offlined tablespaces. It is also known as deferred rollback
A "Deferred Rollback" segment is created for a tablespace
when a tablespace is taken offline. Undo records are written
to the deferred rollback segment of a tablespace when undo is being applied to a
tablespace which is offline, hence, the undo
cannot be applied.
The undo stored in the deferred rollback segment is applied when
the tablespace comes back online. The deferred rollback segment
is automatically removed after the undo has been applied.
Deferred rollback segments always reside in the system tablespace.
试验一下
sys@ORCL> select * from seg$ where type#=2;
no rows selected
sys@ORCL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
7 TEST YES NO YES
2 SYSAUX YES NO YES
4 USERS YES NO YES
6 EXAMPLE YES NO YES
9 TT YES NO YES
19 TBSLOGMNR YES NO YES
5 UNDOTBS2 YES NO YES
3 TEMP NO NO YES
20 SMAILTBS YES NO YES
24 INDEXTBS YES NO YES
11 rows selected.
sys@ORCL> alter tablespace tt offline;
Tablespace altered.
sys@ORCL> select * from seg$ where type#=2;
FILE# BLOCK# TYPE# TS# BLOCKS EXTENTS INIEXTS MINEXTS MAXEXTS EXTSIZE EXTPCT USER# LISTS
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
GROUPS BITMAPRANGES CACHEHINT SCANHINT HWMINCR SPARE1 SPARE2
---------- ------------ ---------- ---------- ---------- ---------- ----------
1 68209 2 0 8 1 5 1 2147483645 128 0 0 0
0 0 0 0 0 5
sys@ORCL> alter tablespace tt online;
Tablespace altered.
sys@ORCL> select * from seg$ where type#=2;
no rows selected
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




