Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Preparing for Performance test

Preparing for Performance test

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 11 Jun 2003 11:44:46 -0700
Message-ID: <F001.005AF69F.20030611112545@fatcity.com>


Tru64 5.1A
8.1.7.3

I have a very short window of time tomorrow to try and determine why the runtime of one 2-table join takes ~4 time as long on a (SAN/Snapshot) database copy as the same statement on the source database. All other test selects have similar runtimes on each database. Both database are using copies of the same init.ora file with only directory specific parameters changed, CBO statistics are, of course, the same and one of these 2 database are the only thing running on the box during test time.

I plan to run the SQL test scripts with event 10046 lvl 8 set. Should I have a look at anything else during the test to try and shed more light on this discrepency.

Thanks,
Mike Hand
Polaroid Corp.

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hand, Michael T
  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). Received on Wed Jun 11 2003 - 13:44:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US