Query Speed

From: Joe Condle <condle_at_med.pitt.edu>
Date: Tue, 28 Apr 1998 13:57:44 -0400
Message-ID: <35461898.7126@med.pitt.edu>

I am running Oracle 8 for the Solaris OS. I have supposedly two identical machines with the same databases on them. The database was generated on one and exported to the other. The problem I have is when I run simple sql queries on one the same query runs three times as fast on the other. It is almost exactly three times difference. 22 secs on the origninal machine vers 1 min on the other. My question is where do I start to look for differences. I am a newbie and have started looking throught all the docs. Please point me in the right direction.

Thanks in Advance

Joe Condle
Sys Engr
Medical ARchival Systems Inc.
Univ. of Pittsburgh Medical Center Received on Tue Apr 28 1998 - 12:57:44 CDT