Re: Strange Oracle behavior between different environments
Date: Fri, 19 Aug 2011 18:24:52 +0000 (UTC)
Message-ID: <pan.2011.08.19.18.24.51_at_email.here.invalid>
On Fri, 19 Aug 2011 08:00:25 -0700, Alex L 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
Is there any difference in the system statistics? What are the values in SYS.AUX_STATS$ table? These values govern the behavior of the CBO. Also, is there any significant discrepancy in the instance parameters?
-- http://mgogala.byethost5.comReceived on Fri Aug 19 2011 - 13:24:52 CDT