Explore >> Select a destination
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
tonyhasler.wordpress.com
|
|
| | | | | Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility... | |
| | | | |
savvinov.com
|
|
| | | | | In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it's probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I will discuss frequently used options and some common problems. Preparation... | |
| | | | |
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... | |
| | | | |
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... | ||
