ITPub博客

首页 > 数据库 > Oracle > 10.2.0.4 11.1.0.7UNDO可能异常增大的BUG

10.2.0.4 11.1.0.7UNDO可能异常增大的BUG

原创 Oracle 作者:gaopengtttt 时间:2016-01-19 10:57:57 0 删除 编辑
表现为
 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博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-1978858/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
wxh gp_22389860

注册时间:2008-10-13

  • 博文量
    640
  • 访问量
    2817964