Ads

How to calculate overall time of a SQL statement.

How to calculate overall time of a SQL statement.

SQL> set timing on
SQL> set time on
08:48:52 SQL> select count(*) from pk;

  COUNT(*)
----------
  25165824

Elapsed: 00:00:03.62
08:49:09 SQL>