Explore >> Select a destination
|
You are here 
|
chandlerdba.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).... | |
| | | | |
blog.yannickjaquier.com
|
|
| | | | | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Okay, so the title is pretentious; but I thought it was a snappy summary of this item [until someone pointed out that Heisenberg's Uncertainty Principle is not about measurement error]. I've blogged before about the improved features in 10g of the dbms_xplan package, in particular the display_cursor() procedure, with its option for displaying rowsource execution... | ||
