Strange Oracle behavior between different environments

From: Alex L <aladik_at_gmail.com>
Date: Fri, 19 Aug 2011 08:00:25 -0700 (PDT)
Message-ID: <4d24d1b9-abeb-4e63-ab9a-1a893995d4a3_at_ea4g2000vbb.googlegroups.com>

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 Received on Fri Aug 19 2011 - 10:00:25 CDT