/explore
|
You are here 
|
oracleprof.blogspot.com | ||
| | | | |
hourim.wordpress.com
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... |
|
| | | | | ||
| | | | |
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).... |
|
| | | | | ||
| | | | |
blog.yannickjaquier.com
SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile |
|
| | | | | ||
| | | | |
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... |
|
| | | |||
