Tech Tutorials Database
GeekArticles FAQ Oracle FAQ
 

10g CBO : RULE mode and CHOOSE hint

 
Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

Hi, As a senior DBA, just joined a company which is using an ERP on 10gR2 which requires opimizer_mode=RULE (??) What kind of CBO behavior can be expected with such non-supported setup ? Moreover, developers are using a lot of hints...

Read More...




Sponsored Links




Read Next: concurrency



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe