Explore >> Select a destination
|
You are here 
|
carlos-sierra.net | ||
| | | | |
mauro-pagano.com
|
|
| | | | | When upgrading a database sometime you find that one or more SQLs run slower because ofa new and suboptimal execution plan. Usually the number of those SQLs is pretty small compared to the overall workload but it's not straightforward to understand what caused the plan change so even a small number can become tricky to... | |
| | | | |
mikedietrichde.com
|
|
| | | | | HOL 19c SQL Plan Management - Instructions for the Oracle Database Upgrade 19c Hands-On Lab about how to leverage SQL Plan Management efficiently and easy | |
| | | | |
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... | |
| | | | |
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).... | ||
