ITPub博客

首页 > 应用开发 > IT综合 > Automatic Undo Retention (32)

Automatic Undo Retention (32)

原创 IT综合 作者:tsinglee 时间:2007-09-20 16:50:20 0 删除 编辑

Oracle Database 10g automatically tunes a parameter called the undo retention
period.The undo retention period indicates the amount of time that must pass before old
undo information—that is, undo information for committed transactions—can be
overwritten. The database collects usage statistics and tunes the undo retention
period based on these statistics and on undo tablespace size. Provided that automatic
undo management is enabled, the database automatically tunes the undo retention
period as follows:
■ For an AUTOEXTEND undo tablespace, the database tunes the undo retention
period to be slightly longer than the longest-running query, if space allows. In
addition, when there is adequate free space, the tuned retention period does not
go below the value of the UNDO_RETENTION initialization parameter.
■ For a fixed size undo tablespace, the database tunes for the maximum possible
undo retention. This means always providing the longest possible retention
period
while avoiding out-of-space conditions and near out-of-space conditions in the
undo tablespace. The UNDO_RETENTION initialization parameter is ignored unless
retention guarantee is enabled.
■ Automatic tuning of undo retention is not supported for LOBs. The tuned
retention value for LOB columns is set to the value of the UNDO_RETENTION
parameter.
For fixed size and AUTOEXTEND undo tablespaces of equal size, depending on the
queries that you run, the tuning method used in fixed size tablespaces tends to
provide a longer retention period. This enables flashback operations to flash
back farther in time, and maximizes the amount of undo data available for
long-running queries.

1. 回滚信息保持时间 :在被覆盖之前保持的时间
2. The UNDO_RETENTION initialization parameter is ignored unless
retention guarantee is enabled. 回去看看书
3. 不支持LOB

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-970447/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Undo Quota (31)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892341