Below are useful articles worth seeing about the cursor sharing and bind peeking features:
- Why are there more cursors in 11g for my query containing bind variables?
- How do I force a query to use bind-aware cursor sharing?
- Adaptive Cursors and SQL Plan Management
- Predicate Selectivity (Doc ID 68992.1
- Use of Bind Variables in Queries (Pre-9i) (Doc ID 70075.1)
- Histograms: An Overview (9i and Below) (Doc ID 1031826.6)
- Histograms: An Overview (10g and Above) (Doc ID 1445372.1)
- Query Optimizer: What is Density? (Doc ID 43041.1)
- Limitations of the Oracle Cost Based Optimizer (Doc ID 212809.1)
- Interpreting Histogram Information (Doc ID 72539.1)
- Adaptive Cursor Sharing: Worked Example (Doc ID 836256.1)
- ANNOUNCEMENT: Deprecating the cursor_sharing = 'SIMILAR' setting (Doc ID 1169017.1)
- Bug 13456573 - Many child cursors / ORA-4031 with large allocation in KGLH0 using extended cursor sharing (Doc ID 13456573.8)
- Bug 6644714 - High number of child cursors with adaptive cursor sharing (Doc ID 6644714.8)
- Gathering Initial Troubleshooting Information for Analysis of ORA-4031 Errors on the Shared Pool (Doc ID 1674929.1)
- FAQ: Adaptive Cursor Sharing (ACS) Frequently Asked Questions (Doc ID 1518681.1)
- Query Using Bind Variables Suddenly Starts to Perform Slowly (Doc ID 387394.1)
- Examples of Sharing Cursors with Peeked Bind Variables (Doc ID 430208.1)
- Unstable Plans (Oracle Plan Stability/Instability)
- Troubleshooting: High Version Count Issues (Doc ID 296377.1)
- My cursor wasn’t shared because of STB_OBJECT_MISMATCH. What does that mean?
No comments:
Post a Comment