Explore >> Select a destination
|
You are here 
|
dioncho.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).... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | I've lost count of the number of times I've reminded people that hinting (correctly) is hard. Even the humble /*+ index() */ hint and its close relatives are open to misunderstanding and accidental misuse, leading to complaints that "Oracle is ignoring my hint". Strange though it may seem, I'm still not 100% certain of what... | |
| | | | |
leonotes.wordpress.com
|
|
| | | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | | |
sqlmaria.com
|
|
| | | Database views are a handy tool to help obfuscate complex joins from developers and analysts. However, knowing which view to use can be tricky, especially when faced with multiple views with simila... | ||
