Invalid Hint in 10g Can Cause Other Hints To Be Ignored, Including Parallel Hints
(Doc ID 826893.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 184.108.40.206 [Release 10.1 to 11.2]
Information in this document applies to any platform.
After upgrading a database from 9i to 10g, an insert statement was taking many more hours to complete under 10g than it had in 9i.
After obtaining explain plans from both 9i and 10g, it was found that without modification, the same insert statement ran in with parallel DML in 9i, but serially in 10g:
Upgrade from 9i to 10g (patchset level is insignificant to this issue).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document