SQL Plus - Timing

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

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.

Advertising

3 - Syntax

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

4 - Example

>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

5 - Configuration

5.1 - Timing system variable

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