/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

 blog.yannickjaquier.com
Automatic SQL Tuning Sets (ASTS) hidden feature hands-on
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
1.6 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.
| | blog.toadworld.com
Why my execution plan has not been shared - Part I
1.8 parsecs away

Travel
| | Why my execution plan has not been shared - Part I
| | sqlmaria.com
How to use a SQL Plan Baseline or a SQL Patch to add Optimizer hints
1.8 parsecs away

Travel
| | In a recent chat with Connor McDonald, we discussed if it is realistic to have applications that don't contain Optimizer hints. Ideally, the answer to this question is "yes", you don't need hints i...
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
8.7 parsecs away

Travel
| The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....