Re: How to measure the query response time ??

Holger Mertens wrote:
>
> I was wondering if there is an easy way to measure the query response
> time in an Oracle DMBS. Or is there any LOG-file that gives information
> on that ??
>
> Thanks...
>
> Holger Mertens
> --
> bwl1002_at_wifak.uni-wuerzburg.de

Since you didn't say in what tool you were using I'll include a few different ways:

In SQL*Plus issue a "set timing on" and/or "set time on". In almost all tools you can issue a "alter session set sql_trace = true" and then run tkprof on the resulting trace file. In PRO*C you could always do a before and after time() call around each DML statment. In UNIX, if you can encapsulate the command(s) in a filename.sql file then issue a "time sqlplus / _at_filename.sql".

For single statment testing I like doing a SQL*Plus with the "set timing on" option. For program profiling I use the "alter session set sql_trace = true" and then tkprof on the resultion trace file.

--
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo