Re: Performance Issue over multiple processor server

A copy of this was sent to Parvinder Singh <parora_at_questone.com> (if that email address didn't require changing) On Tue, 25 Jan 2000 09:12:02 GMT, you 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.
>

what does your IO look like. you have have the fastest machine in the world but if the IO is all going through 1 controller/disk/etc... it'll go only as fast as the disk can.

>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

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 25 2000 - 07:38:00 CST