Re: How to measure the query response time ??
Date: 1996/09/26
Message-ID: <3249edf0.3127036_at_dcsun4>#1/1
On 25 Sep 1996 10:24:52 GMT, Holger Mertens <bwl1002_at_wifak.uni-wuerzburg.de> 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
>
I'd use sqltrace to do this. for example:
SQL> alter session set sql_trace=true;
SQL> .....
or in pro*c
EXEC SQL ALTER SESSION SET SQL_TRACE=TRUE; or in forms
forms_ddl( 'alter session set sql_trace=true' );
or in pl/sql
dbms_session.set_sql_trace( true )
Make sure timed_statistics is on in the database and use tkprof to analyze the results. see the tuning guide or appl developers guide for more info on sql_trace, timed_statistics, and tkprof...
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
- Check out Oracle Governments web site! -----
Follow the link to "Tech Center"
and then downloadable Utilities for some free software...
statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Thu Sep 26 1996 - 00:00:00 CEST