Re: Performance Issue over multiple processor server

In article <388D6874.CBEBE770_at_questone.com>,   parora_at_questone.com wrote:
> Hi
>
> I had executed a query on a database which took around 1 min
12
> secs but the same kindda query (different tables) if executed from
> different machines it takes double the time (> 2 minutes).I have got
an
> Pentium 550 Xeon server with two processors.
>
> Any idea what can i do in this regard ? Do i need to do any kind of
> homework like set some parameters in the initorcl.ora ? (for e.g : set
> the PARALLEL_AUTOMATIC_TUNING parameter ..but in which file should i
set
> this ? ...i tried with init<sid>.ora but doesnt work )
>
> Thanks & Regards
>
> ~Parvinder
>
>

--
They may be the "same kinda query" but if they are against two different tables on two different machines, you are compareing apples and oranges.

Exactly how do the queries differ? Saying they are the same "kind" of query suggests to me the aren't the *same* query. SELECT EMPID FROM EMP; and SELECT DEPT_ID FROM DEPT; are the same kind of query, but I wouldn't expect the same performance from them.

How do the tables differ? If one has block and row sizing that allows more rows per block than the other, then it different amounts of IO will be required to scan the same number of rows.

Indexing? Perhaps one query is able to use an index and the other requires a table scan.
What is the difference between the two machines you are running the queries on? Is on the host server and the other a remote workstation going over a slow network connection?

Read up on "autotrace", then use it on the two different queries and compare the results.

Ed Stevens
(Opinions are not necessarily those of my employer)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 07:22:41 CST