Obtain or record the execution time of the "Oracle" Statement

Welcome to the Oracle community forum and interact with 2 million technical staff. In many cases, we need to obtain or record the Oracle statement execution time. In fact, this can be implemented simply by using the following code: SETTIMINGON is required for the execution time of the OracleE statement. For example: [oracle @ jw ~] $ SqlplusassysdbaSQL * Plus:

Welcome to the Oracle community forum and interact with 2 million technical staff> in many cases, we need to obtain or record the execution time of Oracle statements. In fact, the Code is as follows: set timing on is required for execution of the OracleE statement, for example, [oracle @ jw ~]. $ Sqlplus "/as sysdba" SQL * Plus:

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

In many cases, we need to obtain or record the execution time of Oracle statements. In fact, this can be implemented simply by using the following code:

Set timing on is required for the execution time of the OracleE statement. For example:

[Oracle @ jw ~] $ Sqlplus "/as sysdba" SQL * Plus: Release 9.2.0.4.0-Production on Tuesday August 28 16:59:43 2007 Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Connect:

Oracle9i Enterprise Edition Release 9.2.0.4.0-ProductionWith the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0-ProductionSQL> set timing on; SQL> select count (*) from tab; COUNT (*) ---------- 2447 used time: 00: 00: 00.12SQL>