Explore >> Select a destination


You are here

www.dbaglobe.com
| | orastory.wordpress.com
2.7 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)....
| | blog.sqlora.com
2.9 parsecs away

Travel
| | Here is an overview of some improvements to Online Statistics Gathering in Oracle Releases 19c-23ai
| | oracle-randolf.blogspot.com
3.0 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...
| | hourim.wordpress.com
21.6 parsecs away

Travel
| 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...