You are here |
dioncho.wordpress.com | ||
| | | |
mwidlake.wordpress.com
|
|
| | | | 1 post published by mwidlake on July 3, 2009 | |
| | | |
oracle-randolf.blogspot.com
|
|
| | | | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these... | |
| | | |
kerryosborne.oracle-guy.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).... |