10.2.0.4 11.1.0.7UNDO可能异常增大的BUG
表现为
select tuned_undoretention from v$undostat;
的值异常大，UNDO_DATAFILE 不断的自动扩张。
mos有相关的BUG说明
Bug 7291739 Contention with auto-tuned undo retention or high TUNED_UNDORETENTION
Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions BELOW 11.2Versions confirmed as being affected Platforms affectedGeneric (all / most platforms affected)
select tuned_undoretention from v$undostat;
的值异常大，UNDO_DATAFILE 不断的自动扩张。
mos有相关的BUG说明
Bug 7291739 Contention with auto-tuned undo retention or high TUNED_UNDORETENTION
Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions BELOW 11.2Versions confirmed as being affected Platforms affectedGeneric (all / most platforms affected)
Description
High 'latch: row cache objects' contention may be seen on dc_rollback_segments together with high 'enq: US - contention' waits when using system managed undo with an auto tuned undo retention period. As another aspect, long running query can raise tuned_undoretention to very high value and exhaust undo tablespace resulting in ORA-1628.Workaround Disable auto tuning by setting "_undo_autotune" = false记录于此备查
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7728585/viewspace-1978858/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
