/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

 oracletoday.blogspot.com
Oracle Today: Performance of Autotrace
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
1.0 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...
| | afatkulin.blogspot.com
Alex Fatkulin's Blog: Searching over structured and unstructured data in 10G
1.0 parsecs away

Travel
| | In my previous blog post I've explained a nice little feature introduced to Oracle Text Context indexes in 11G which allows you to do effic...
| | afatkulin.blogspot.com
Alex Fatkulin's Blog: v$result_cache_memory or what is the newest method to hang stuff up?
1.2 parsecs away

Travel
| | Sometimes I get quite amused by the "side effects" you can discover while playing with features. Prerequisites First, we need to place somet...
| | tanelpoder.com
How to resolve SQL object and column names all the way to base tables and columns in Oracle? | Tanel Poder Consulting
11.4 parsecs away

Travel
| Update: As this original article is from 2007, there are better options available in the modern times for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgans blog entry here. If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of views, which reference views, which reference more views etc. So there may ...