ORA_PROF.START_TIMER
built-in procedureThis procedure 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.
PROCEDURE ORA_PROF.START_TIMER
(timer VARCHAR2);
Parameter |
Description |
|
The name of the timer. |
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;
About the ORA_PROF
built-in package
Copyright © 1984, 2005, Oracle. All rights reserved.