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.