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;