正德厚生,臻于至善

Consolidation of Issues and Questions on Auto DOP (Degree of Parallelism)

Consolidation of Issues and Questions on Auto DOP (Degree of Parallelism) (Doc ID 1969284.1)

How to

Automatic Degree of Parallelism in 11.2.0.2 (Doc ID 1269321.1)
Setup, Monitor, And Tune Parallelism In The Database (Doc ID 1549214.1)
Do You Need IO Calibrate Statistics for AUTO DOP in 12C ? (Doc ID 1963310.1)
How to Analyze Why PX Queries Are Slow with AutoDOP Feature (Doc ID 1380736.1)

Problems / Issues

AutoDOP Seems to Ignore Object-level Parallel Hints (Doc ID 1502256.1)
Queries Do not Implement Assigned DOP and Take Much Longer After Upgrade from 11.2.0.1 to 11.2.0.2 (Doc ID 1365186.1)
Some Statements Unexpectedly Run in Parallel With Auto DOP (Parallel_Degree_Policy = Auto or Limited) (Doc ID 1643540.1)
Database Hangs with parallel_degree_policy = AUTO; Serial statement holding JX Enqueue (Doc ID 1333867.1)
Why Is My Query Using a High Value for Degree of Parallelism (DOP)? (Doc ID 1684931.1)
Query Executes With Automatic DOP While Degree Of Parallelism Is 1 As Value (Doc ID 1341407.1)

Bugs

Bug 12690348 – QUERY RUNS SERIALLY WITH PARALLEL_DEGREE_POLICY AUTO
Unpublished Bug 8671349 – Automatic degree of parallelism may be too high (Doc ID 8671349.8)
Bug 13499154 – auto dop disabled on standby db (Doc ID 13499154.8)
Unpublished Bug 9221118 – Auto dop ignores object level parallel hints (Doc ID 9221118.8)
Unpublished Bug 9460699 – Alter session force parallel query does not override AutoDOP (Doc ID 9460699.8)
Unpublished Bug 9728438 – With auto DOP set some serial queries may execute in parallel – superceded (Doc ID 9728438.8)
Unpublished Bug 10628995 – Parallel (x, …) hints causes serial runs from queries when PX Auto DOP feature is used (Doc ID 10628995.8)
Bug 9671271 – All active instances used in calculation of dop when parallel_force_local=true / High version count on PX_MISMATCH (Doc ID 9671271.8)

赞(0) 打赏
未经允许不得转载:徐万新之路 » Consolidation of Issues and Questions on Auto DOP (Degree of Parallelism)
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏