Explore >> Select a destination


You are here

hourim.wordpress.com
| | jonathanlewis.wordpress.com
1.5 parsecs away

Travel
| | 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...
| | tonyhasler.wordpress.com
1.3 parsecs away

Travel
| | As has happened a couple of times recently, comments on a blog of mine have helped me understand the subject matter on which I am commenting far better. In this case a dialogue with Dom Brooks on my previous blog on how to simulate a stored outline/SQL baseline with FORCE_MATCH using SQL profiles has provided...
| | iggyfernandez.wordpress.com
1.6 parsecs away

Travel
| | Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:...
| | oracle-randolf.blogspot.com
17.4 parsecs away

Travel
| Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT A...