/explore
|
You are here 
|
oracle-base.com | ||
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
oracle-randolf.blogspot.com
On the OTN forum very often tuning requests about single SQL statements are posted, but the information provided is rather limited, and ther... |
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you... |
|
| | | | | ||
| | | | |
kerryosborne.oracle-guy.com
[AI summary] A technical investigation into whether Oracle SQL Plan Baselines store actual execution plans or rely on hidden hints, analyzing database trace files and data dictionary views. |
|
| | | |||
