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

ORA_PROF.Reset_Timer

Description

Resets the elapsed time of a timer to zero.

Syntax


PROCEDURE Ora_Prof.Reset_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;