A script-enabled browser is required for this page to function properly.

ORA_PROF.Start_Timer

Description

Starts a timer. Any time accumulated between calls to Ora_Prof.Timer_Start and Ora_Prof.Timer_Stop added to the timer's total elapsed time.

Syntax


PROCEDURE Ora_Prof.Start_Timer
   (timer VARCHAR2);

Parameters

timer The name of the timer.

Example


 PROCEDURE multi_time IS
  i PLS_INTEGER;
BEGIN
  Ora_Prof.Create_Timer('loop');
  --
  -- First loop...
  --
  Ora_Prof.Start_Timer('loop');
    FOR i IN 1..10 LOOP
      Text_IO.Put_Line('Hello');
    END LOOP;
  Ora_Prof.Stop_Timer('loop');
   --
   -- Second loop...
   --
  Ora_Prof.Start_Timer('loop');
  FOR i IN 1..10 LOOP
    Text_IO.Put_Line('Hello');
  END LOOP;
  Ora_Prof.Stop_Timer('loop');
  Ora_Prof.Destroy_Timer('loop');
END;