SQL Plus - Timing
> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)
Table of Contents
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.
2 - Articles Related
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