SQL Plus - Timing

Timing is a command that records timing data for an elapsed time period, lists the current timer's name and timing data, or lists the number of active timers.

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

>timi start 'myTiming'
>timi show
timing for: myTiming
Elapsed: 00:00:04.16
>timi show
timing for: myTiming
Elapsed: 00:00:07.64
>timi stop
timing for: myTiming
Elapsed: 00:00:12.94

You can also let show the timing of each execution.

This behaviour is controlled by the timing system variable.

SET timing ON

Asking an SQL as the last one will gives timing information.

Elapsed: 00:00:00.00