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.