| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Preparing for Performance test
after you are done wint 10046^8, you may want to try with event 10053^1 ... and if you are looking for information to interpret the output look no further than http://www.centrexcc.com/papers.html
Raj
-----Original Message-----
From: Hand, Michael T [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 11, 2003 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject: Preparing for Performance test
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 e-mailmessage is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank
you.*********************************************************************2Received on Wed Jun 11 2003 - 14:01:31 CDT
 |
 |