|SQL*Plus User's Guide and Reference
Command Reference, 47 of 52
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.
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 SET TIMING ON 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