Oracle-L: Followup: Leccotech DB*Expert Users - Response Time versus Elapsed Time

From: <Cherie_Machler_at_gelco.com>
Date: Thu, 20 Feb 2003 10:39:11 -0800
Message-ID: <F001.00553320.20030220103911@fatcity.com>

I found a tech support person's direct phone number in an old email and called her. She told me that Response Time is the time that it takes to bring back the first record and Elapsed Time is the time it takes to bring back all of the records. So, if you're writing to a form or to a web screen, best Response Time would probably be what you'd want. If you need to get all of the records back before you can go on (as we did in this case) you want the best Elapsed Time that the Batch Run tool shows.

Cherie Machler

                                                                                                                   
                    Cherie_Machler                                                                                 
                    @gelco.com           To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    Sent by:             cc:                                                                       
                    root_at_fatcity.c       Subject:     Leccotech DB*Expert Users - Response Time versus Elapsed     
                    om                    Time                                                                     
                                                                                                                   
                                                                                                                   
                    02/20/03 11:04                                                                                 
                    AM                                                                                             
                    Please respond                                                                                 
                    to ORACLE-L

I know that a few list users are using DB*Expert SQL tuning tool by Leccotech.

We are using the latest version on a 9.2.0.1 database. On occassion, I have seen that when we do a batch run of optimized SQL to find the fastest SQL we see a fairly wide disparity between elapsed time and response time. I'm trying to find out why this occurrs and what it means. I've contacted Leccotech support but it's a fairly urgent issue and I wonder if anyone on the list might answer faster.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Feb 20 2003 - 12:39:11 CST