Jun 072013
 
begin
  select if_this_slow_query_takes,
         eighty_percent_of_the_runtime
  from   your_cripplingly_slow_process;
  
  select there_is_no_point_spending,
         eighty_percent_of_tuning_time
         trying_to_make_gains
  from   this_relatively_quick_query;
end;
/
Of course, the first step is to figure out which query is consuming the most time in your process - 
a point well made by Cary Millsap in his "Optimizing Oracle Performance" book.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)