ORA_PROF.Stop_Timer
Description
Stops 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.Stop_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;