TIMING

The TIMING command lets you start, stop, or display the value of a timer. Timers let you measure elapsed time, and are described in Chapter 8 .

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

where:

TIMI[NG]

Is the command, and may be abbreviated to TIMI.

START [timer_name]

Starts a new timer, and optionally gives it the name you provide.

SHOW

Shows the current value of the most recently started timer.

STOP

Stops the most recently started timer, shows its current value, then deletes it.

Get Oracle SQL*Plus: The Definitive Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.