Re: Query Speed

From: james scharpf <j.scharpf_at_worldnet.att.net>
Date: Fri, 08 May 1998 21:54:28 -0700
Message-ID: <6j1qj3$apu@bgtnsc01.worldnet.att.net>

Joe,

Before doing anything else, I would perform an 'explain plan' for the queries in question on each of the two machines. The access path could tell you a lot about what is going on. If they are exactly the same, you could try using the sql trace facility. This will give you information like logical vs. physical reads, etc.

regards,
James Scharpf

Joe Condle wrote:
>
> 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 Fri May 08 1998 - 23:54:28 CDT