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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7591490/viewspace-1032512/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7591490/viewspace-1032512/