Explore >> Select a destination
|
You are here 
|
tonyhasler.wordpress.com | ||
| | | | |
orastory.wordpress.com
|
|
| | | | | 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).... | |
| | | | |
hourim.wordpress.com
|
|
| | | | | 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... | |
| | | | |
alexzeng.wordpress.com
|
|
| | | | | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use... | |
| | | | |
dioncho.wordpress.com
|
|
| | | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the... | ||
