Operating System - HP-UX
1748165 Members
3740 Online
108758 Solutions
New Discussion

SQL statement execution time

 
SOLVED
Go to solution
Vincenzo Restuccia
Honored Contributor

SQL statement execution time

Is it possible to measure the execution time of a SQL statement from a client to a server, from inside an open SQL session? If yes, HOW?
Thanks in advance
1 REPLY 1
Volker Borowski
Honored Contributor
Solution

Re: SQL statement execution time

Hi,
if database ist Oracle you have options in sqlplus:

SQL> set timing on;
SQL> select count(*) from table;

COUNT(*)
----------
157

Elapsed: 00:00:00.01
SQL>

And svrmgrl:
SVRMGR> set timing on;
Timing ON
SVRMGR> select count(*) from dba_segments;
COUNT(*)
----------
1090
1 row selected.
Parse 0,06 (Elapsed) 0,00 (CPU)
Execute/Fetch 0,31 (Elapsed) 0,00 (CPU)
Total 0,37 0,00
SVRMGR>

Which is a little bit more detailed.

Hope this helps.
Volker