Explore >> Select a destination

You are here

 kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Flush A Single SQL Statement
| | dioncho.wordpress.com
v$sql_shared_cursor | Dion Cho - Oracle Performance Storyteller
13.1 parsecs away

Travel
| | I hit following OTN forum article which was a discussion on typical SQL sharing problem. There are so many reasons why Oracle does not share the same statement. Oracle records the reason in v$sql_shared_cursor view. In my local 10.2.0.1 database, v$sql_shared_cursor has 53 reasons of unshareability. But I have a big complaint on v$sql_shared_cursor view....
| | mwidlake.wordpress.com
03 | July | 2009 | Martin Widlake's Yet Another Oracle Blog
8.9 parsecs away

Travel
| | 1 post published by mwidlake on July 3, 2009
| | blog.yannickjaquier.com
SQL Plan Management
13.2 parsecs away

Travel
| | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile
| | nenadnoveljic.com
Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics
49.3 parsecs away

Travel
| Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD.