本文详细介绍了 Oracle 数据库中 UNDO_RETENTION 参数的作用及其设置方法。UNDO_RETENTION 参数用于控制已提交事务的 UNDO 数据保留时间，其默认值为 900 秒。文章还提供了如何计算最优 UNDO 保留时间的公式，并给出了查询 UNDO 块每秒使用情况的 SQL 示例。
UNDO_RETENTION
The undo_retention is a initialization parameter of the undo tablespace. The initialization parameter of undo_retention used to control the maximum data retention time, the undo_retention default value is 900 seconds. The undo_retention is a parameter in the spfile.ora initialization parameters file that specifies the time period in seconds for which a system retains undo data for committed transactions.
UNDO_RETENTION = 900
How to calculate the undo_retention time?
The undo_retention is a initialization parameter of the undo tablespace. The initialization parameter of undo_retention used to control the maximum data retention time, the undo_retention default value is 900 seconds. The undo_retention is a parameter in the spfile.ora initialization parameters file that specifies the time period in seconds for which a system retains undo data for committed transactions.
UNDO_RETENTION = 900
How to calculate the undo_retention time?
As the following formula.
Formula:
Optimal Undo Retention =Actual Undo Size / (DB_BLOCK_SIZE — UNDO_BLOCK_REP_ESC)
Formula:
Optimal Undo Retention =Actual Undo Size / (DB_BLOCK_SIZE — UNDO_BLOCK_REP_ESC)
How to determine the undo_block_rep_sec?
SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
"UNDO_BLOCK_PER_SEC"
FROM v$undostat; 
扫一扫
9241
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
