GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQ10g CBO : RULE mode and CHOOSE hint
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...
Sponsored Links
Read Next: concurrency
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
