Explore >> Select a destination
|
You are here 
|
blog.tanelpoder.com | ||
| | | | |
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... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you... | |
| | | | |
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... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned... | ||
