/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

 dioncho.wordpress.com
v$sql_shared_cursor | Dion Cho - Oracle Performance Storyteller
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
2.0 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.
| | hourim.wordpress.com
How to attach a hinted SPM baseline to a non hinted sql query? | Mohamed Houri's Oracle Notes
4.0 parsecs away

Travel
| | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating...
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
2.8 parsecs away

Travel
| | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...
| | tonyhasler.wordpress.com
Parallel partition scans | Tony's Oracle Tips
16.0 parsecs away

Travel
| When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...