/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 oracle-base.com
ORACLE-BASE - Oracle SQL Articles
| | www.scattered-thoughts.net
Unexplanations: sql is syntactic sugar for relational algebra
3.2 parsecs away

Travel
| |
| | jonathanlewis.wordpress.com
Plans in Memory | Oracle Scratchpad
2.6 parsecs away

Travel
| | 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
Kerry Osborne's Oracle Blog » Blog Archive » GATHER_PLAN_STATISTICS
2.8 parsecs away

Travel
| |
| | hourim.wordpress.com
SQLTXPLAIN under Oracle 12c | Mohamed Houri's Oracle Notes
14.1 parsecs away

Travel
| I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without...