Re: Strange Oracle behavior between different environments
From: Richard <richard.rankin_at_ieee.org>
Date: Mon, 22 Aug 2011 08:19:03 -0700 (PDT)
Message-ID: <b1b46db7-0d5a-483c-8822-8d525b4fb574_at_d25g2000yqh.googlegroups.com>
On Aug 19, 10:00 am, Alex L <ala..._at_gmail.com> wrote:
> We have a 10g database on Solaris 10 that is having some serious
> performance issues. The same database restored onto a Windows machine
> performs fine.
>
> I'm not sure if the Solaris/Windows thing makes a difference at all,
> but I'm curious if anyone knows of anything.
>
> Some background: We discovered the issue while optimizing a query,
> and examining the explain plan cost of the query. Unoptimized, this
> query had a cost of 256000 in 10g/Solaris. It had a cost of 6 in 10g/
> Windows.
>
> Optimized, the query had a cost of 51 in 10g/Solaris, and a cost of 4
> in 10g/Windows. So we're still seeing a pretty huge difference on
> this query alone, and the general performance of the Solaris DB is
> just very poor, despite the hardware being far superior to the Windows
> machine.
>
> The Solaris DB is WE8ISO8859P1 character set. The Windows DB is
> WE8MSWIN1252. Any ideas? Other information I can provide?
>
> Thanks,
> Alex
Date: Mon, 22 Aug 2011 08:19:03 -0700 (PDT)
Message-ID: <b1b46db7-0d5a-483c-8822-8d525b4fb574_at_d25g2000yqh.googlegroups.com>
On Aug 19, 10:00 am, Alex L <ala..._at_gmail.com> wrote:
> We have a 10g database on Solaris 10 that is having some serious
> performance issues. The same database restored onto a Windows machine
> performs fine.
>
> I'm not sure if the Solaris/Windows thing makes a difference at all,
> but I'm curious if anyone knows of anything.
>
> Some background: We discovered the issue while optimizing a query,
> and examining the explain plan cost of the query. Unoptimized, this
> query had a cost of 256000 in 10g/Solaris. It had a cost of 6 in 10g/
> Windows.
>
> Optimized, the query had a cost of 51 in 10g/Solaris, and a cost of 4
> in 10g/Windows. So we're still seeing a pretty huge difference on
> this query alone, and the general performance of the Solaris DB is
> just very poor, despite the hardware being far superior to the Windows
> machine.
>
> The Solaris DB is WE8ISO8859P1 character set. The Windows DB is
> WE8MSWIN1252. Any ideas? Other information I can provide?
>
> Thanks,
> Alex
I worked for an Oracle development company that made accounting software for the Agribusiness sector at my suggestion, they did not buy a $500K HP and started using three $5K Windows/Intel machines for development. We had a customer with a .5 mil HP that sent us their entire system which when installed on one of the Windows boxes run much faster than their HP. They sent sent their people over to sort it out and we never did figure it out. Money doesn't buy happiness. Received on Mon Aug 22 2011 - 10:19:03 CDT