Re: Performance Issue over multiple processor server

Please see the correction of my statement below sorry for that
Regards
~Parvinder

Parvinder Singh wrote:

> Hi
>
> I had executed a query on a database which took around 1 min 12
> secs but the same kindda query (with different tables) if executed from
> different machines simultaneoulsy

> 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
Received on Tue Jan 25 2000 - 03:17:25 CST