/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

 jonathanlewis.wordpress.com
Plans in Memory | Oracle Scratchpad
| | hourim.wordpress.com
How to attach a hinted SPM baseline to a non hinted sql query? | Mohamed Houri's Oracle Notes
1.5 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...
| | tonyhasler.wordpress.com
Parallel partition scans | Tony's Oracle Tips
1.7 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...
| | oracle-base.com
ORACLE-BASE - Oracle SQL Articles
2.6 parsecs away

Travel
| | ORACLE-BASE - Oracle SQL Articles
| | orastory.wordpress.com
SQL_IDs and baselines | OraStory
14.4 parsecs away

Travel
| There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....