Poor Performance On Certain Dictionary Queries After Upgrade To 10g
以前解决过的一个问题，今天有人再次碰到，记录下解决过程：
For issues with the ALL_SYNONYMS view see:
Note 377037.1 Selects Against ALL_SYNONYMS Perform. Badly on 10g Release 10.2
The definition of ALL_OBJECTS and ALL_ARGUMENTS have changed in version 10.2 as a result of a fix to an outstanding defect. A side affect of this new, more complex, definition is that queries that select against the new view definitions have much more complicated execution plans and maybe more expensive when compared to execution plans in earlier versions (such as 9.2).
http://www.itpub.net/viewthread.php?tid=1005534&highlight=%2Bzhouwf0726
http://www.itpub.net/viewthread.php?tid=1008563&pid=11607504&page=1&extra=
Note:364822.1
Note:377037.1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-450282/ ，如需转载，请注明出处，否则将追究法律责任。
