|SQL*Plus User's Guide and Reference
Part Number A88827-02
Command Reference, 47 of 52
TIMI[NG] [START text|SHOW|STOP]
Records timing data for an elapsed period of time, lists the current timer's name and timing data, or lists the number of active timers.
Refer to the following list for a description of each term or clause:
Enter TIMING with no clauses to list the number of active timers. For other information about TIMING, see SET AUTOTRACE
You can use this data to do a performance analysis on any commands or blocks run during the period.
For information about the data TIMING displays, see the Oracle installation and user's manual(s) provided for your operating system. Refer to the SET TIMING command for information on automatically displaying timing data after each SQL command or PL/SQL block you run.
To delete all timers, use the CLEAR TIMING command.
To create a timer named SQL_TIMER, enter
To list the current timer's title and accumulated time, enter
To list the current timer's title and accumulated time and to remove the timer, enter