Name
SET TIMING
Synopsis
The TIMING setting controls whether or not SQL*Plus displays the elapsed time for each SQL statement or PL/SQL block you execute.
Syntax
SET TIMI[NG] {OFF | ON}
Parameters
- SET TIMI[NG]
Is the command, which may be abbreviated SET TIMI.
- OFF
Turns off the timing feature. This is the default setting.
- ON
Enables the display of elapsed execution time for SQL statements and PL/SQL blocks.
See Chapter 12 for examples of this command.
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition 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.