Apr 052013
 
declare
  process_response_time number := 10;
  response_time_sla     number;
begin
  <<tuning>>
  loop
    process_response_time := 
      improved_execution_time ();
    exit when 
      process_response_time < 
        response_time_sla;
  end loop;
end;
/

It's far too easy to get stuck in a loop incrementally improving SQL runtimes when there's no defined SLA to hit.
In my experience these aren't normally set, leading to many a happy hour reading SQL traces!

 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)