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

ORA_PROF.START_TIMER built-in procedure

This 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.

Syntax


PROCEDURE ORA_PROF.START_TIMER
(timer VARCHAR2);

Parameters

Parameter

Description

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;

See also

About the ORA_PROF built-in package

ORA_PROF built-in package