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

))

oracle10g之AUM

相關文章