Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |