/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

 optimizermagic.blogspot.com
Inside the Oracle Optimizer - Removing the black magic: Displaying and reading the execution plans for a SQL statement
| | oracleprof.blogspot.com
Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines
1.3 parsecs away

Travel
| | SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...
| | rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
1.5 parsecs away

Travel
| |
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
1.4 parsecs away

Travel
| | [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.
| | www.bobbydurrettdba.com
Cardinality errors across joins | Bobby Durrett's DBA Blog
15.9 parsecs away

Travel
| We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...