Re: Query Speed

This is a very broad question and there are lot of places to look for : 1. Check the specs for the 2 machines (RAM, clock speed etc) and confirm if they are the same.
2. The next step is to ensure that your logical database layout and physical database layout are similar to both the databases. (points 3 and 4 below) 3. Identify how many hard disks are there in each machine and locate the datafiles for each database. Make sure that the datafiles relating to TABLE tablespace and INDEX tablespace are on different machines. 4. Make sure that the REDO LOG files are datafiles are different hard disks. 5. Check to see if the parameter files (INITsid.ORA) have the same values for SGA configuration for both the database. 6. Even though they are all the same, if the slow database is on a machine that has a lot of other applications running, accessing the same disks ORACLE is using, you will see a significant difference.

Good luck,
CM
In article <35461898.7126_at_med.pitt.edu>#1/1,   Joe Condle <condle_at_med.pitt.edu> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 13:10:12 CDT