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
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----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-mail message 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.*********************************************************************2
