Oracle SQL: the Essential Reference

TIMING

TIMING

Lists the number of active timers.

TIMI[NG] [START text | SHOW | STOP]

Starts, stops, or lists elapsed timers.

Keywords

START

Sets up a timer and names it text.

SHOW

Lists the current timer's name and timing data.

STOP

Lists the current timer's name and timing data, then deletes the timer.

Don't confuse the TIMING command with the SET TIMING ON and SET TIMING OFF commands. The TIMING command controls active timers, while the SET TIMING command controls the automatic reporting of elapsed time for individual SQL statements.