Performance Issue over multiple processor server

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