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
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
