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.

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