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

ORA_PROF.RESET_TIMER built-in procedure

This procedure resets the elapsed time of a timer to zero.

Syntax


PROCEDURE ORA_PROF.RESET_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