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

ORA_PROF.STOP_TIMER built-in procedure

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

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