Name
TIMING
Synopsis
TIMI[NG] [START [timer_name] | SHOW | STOP]
The TIMING command lets you start, stop, or display the value of a timer in order to measure elapsed time. For example:
TIMING START emp_query_timer TIMING SHOW TIMING STOP
Parameters
- START [ timer_name ]
Starts a new timer and optionally gives it the name you provide.
- SHOW
Shows the current value of the most recently started timer.
- STOP
Stops the most recently started timer, shows its current value, and then deletes it.
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.