/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 rwijk.blogspot.com
About Oracle: Performance aspects of APEX reports
| | savvinov.com
SQL tuning: real-life example - Oracle Diagnostician
2.8 parsecs away

Travel
| | 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...
| | hourim.wordpress.com
How to attach a hinted SPM baseline to a non hinted sql query? | Mohamed Houri's Oracle Notes
2.1 parsecs away

Travel
| | 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...
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
2.3 parsecs away

Travel
| | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...
| | dioncho.wordpress.com
Interesting case of the restriction of global hints | Dion Cho - Oracle Performance Storyteller
16.7 parsecs away

Travel
| One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the...