How to Keep All UNDO Segments from Being Offlined in Oracle 10g - Fast Ramp-Up [ID 396863.1]

[@more@]

先简单记录下，稍后更新

How to Keep All UNDO Segments from Being Offlined in Oracle 10g - Fast Ramp-Up [ID 396863.1]

Per the Oracle Database 10g New Features for Administrators Course, the concept of Fast Ramp-Up indicates the following:

"In previous versions, when the instance was restarted or when you switched undo tablespaces, the ramp-up time for the system to grow the number of online undo segments could be several minutes. Generally, this time delay was unacceptable.

After an instance startup or a switch of undo tablespaces in Oracle Database 10g, the database decides how many segments to place online, based on existing data stored in the the AWR."

参考文章

http://warehouse.itpub.net/post/777/481760

http://www.dbafan.com/blog/?p=170

420525.1： Automatic Tuning of Undo_retention Causes Space Problems

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(from=BOOKMARK&bmDocID=396863.1&viewingMode=1143&bmDocType=HOWTO&bmDocDsrc=DOCUMENT&bmDocTitle=How%20to%20Keep%20All%20UNDO%20Segments%20from%20Being%20Offlined%20in%20Oracle%2010g%20-%20Fast%20Ramp-Up))

ITPub博客

oracle10g之AUM

最新文章