/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

 kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » SQL Tuning Advisor
| | jhdba.wordpress.com
Automatically running sql_advisor tasks from ADDM reports « Oracle DBA - A lifelong learning experience
1.0 parsecs away

Travel
| | 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
SQL Profiles - 2 | Oracle Scratchpad
1.7 parsecs away

Travel
| | Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few...
| | savvinov.com
SQL tuning: real-life example - Oracle Diagnostician
2.0 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...
| | rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
22.3 parsecs away

Travel
|