Check Response Time & Runtime of Oracle SQL Statement



Share this article :

Symptom

You can measure the time taken when you are executing an SQL statement in Oracle database environment.

Solution

1. In SQL session of your Oracle database, execute the command to activate the timing.

SQL> set timing on;

2. This will compute the time taken everytime you executing any SQL statements. As below example, time taken to execute below command is 1.32 seconds.

SQL> select count(*) from sapsr3.vbrk where mandt='900';

  COUNT(*)
----------
   4903425

Elapsed: 00:00:01.32

3. To turn this timing off, execute below command.

SQL> set timing off;

Related posts

V$ARCHIVE_DEST: Archived Redo Log Instance Destinations State
V$BACKUP_DEVICE: Display Supported Backup Devices
ORA-01012: not logged on
ORA-16038: log xx sequence# xxxxx cannot be archived
© 2017 ITsiti. All Rights Reserved
Powered by KEEM