Re: Performance problem Linux vs. Solaris

I'm not sure resource costs alone will determine how performance runs, especially on two different platforms.

I have had queries on the same machine have hugely different resource costs, the one with the higher cost finishes first.

I'd stongly suggest you don't just go by an explain plan and actually let queries run to their completion with a method of timing involved.

oracle at levinsong dot com

"chao_ping" <chao_ping_at_163.com> wrote in message news:3cf32072$1_at_usenetgateway.com...
> I once also made a same test on a linux pc server and an sun v220
> server. Linux with 2 p3 1.4G processors and 2G mem. Sun with 2 450
> processor(8M cache) and 2G mem. I installed the same database, same
> pressure on two server, and the result is that linux outperforms sun
> a bit. while the linux pc server costs 30000 unit of cost, the sun
> costs 200000 unit of costs. So we give up the sun machine and choose
> the linux.
>
>
>
> --
> an oracle fan,
> an oracle beginner
>
> an oracle fan,
> an oracle beginner
>
> Posted via dBforums
> http://dbforums.com
Received on Tue May 28 2002 - 19:21:20 CDT