/explore
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
savvinov.com
An example of tuning - nothing special, but it does illustrate several aspects of tuning work, so I thought I'd make a blog post out of it. Yesterday I as contacted by a development team working with a 10.2.0.4 database. Their complaint was the traditional "the system is slow". Despite very unspecific symptoms, they were... |
|
| | | | | ||
| | | | |
blog.yannickjaquier.com
SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile |
|
| | | | | ||
| | | | |
jhdba.wordpress.com
STOP PRESS - 17 Nov 2009 - updated with latest code which works against both 10g and 11g databases I am attaching scripts which I wrote a while ago to automatically pick any sql_ids reported in the latest ADDMand then run sql_advisor toreport on any tuning advice. I am not suggesting that the information they... |
|
| | | | | ||
| | | | |
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).... |
|
| | | |||
