SQL Plus - Timing

Card Puncher Data Processing


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 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


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

Discover More
Card Puncher Data Processing
SQL Plus - Clear

CLEAR resets or erases the current value or setting for the specified option. where option represents one of the following clauses: BRE[AKS] BUFF[ER] COL[UMNS] COMP[UTES] SCR[EEN] SQL...
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...

Share this page:
Follow us:
Task Runner