解釋Undo Size = Undo_retention * UPS
最近oracle
oracle
SQL> show parameters undo
NAME TYPE VALUE
undo_management string AUTO
undo_retention integer
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS
通過在undo segment header中引入extent commit time
Extent Map
Retention Table
Extent Number:
Extent Number:
Extent Number:
Extent Number:
如何設置undo表空間的大小才能保證undo_retention ?使用公式
Undo Size = Undo_retention * UPS
UPS是undo block per second
SQL> select avg(undoblks)/(
UPS
則undo_retention=
From:http://tw.wingwit.com/Article/program/Oracle/201311/16774.html