Re: Strange Oracle behavior between different environments
Date: Fri, 19 Aug 2011 13:34:08 -0700 (PDT)
Message-ID: <a540a743-299d-440a-85c6-d0641c27cbb9_at_a8g2000pro.googlegroups.com>
On Aug 19, 12:19 pm, Alex L <ala..._at_gmail.com> wrote:
>
> Joel, I can gather the information you request, but it won't be
> today. And to clarify, the issue is not with the query exactly, but
> really with an app that is universally slow in the Solaris
> environment, but runs perfectly acceptably in Windows and Redhat
> (though the Redhat environment uses AL32UTF8, which is why we are
> thinking this might be character set related). We have pretty well
> narrowed down that the bottleneck appears to the be DB, rather than
> other network issues.
>
snip
>
> Sorry for the lack of specifics, kinda new to Oracle, and I was mainly
> looking for directions to go in for troubleshooting and gathering more
> specific data. Thanks everyone.
>
> -Alex
Solaris is really picky about configuration, if everything is slow, you probably should read DISM notes on MOS. Just put DISM in the Search Knowledge Base box.
Statspack or AWR may also give more clues.
jg
-- _at_home.com is bogus. "SALESMAN!" - PeeWee Herman http://www.businessweek.com/technology/apotheker-sets-biggest-hp-strategic-bet-in-oracle-rivalry-tech-08192011.html http://www.eweek.com/c/a/IT-Infrastructure/Oracle-Ending-Itanium-Support-Hurting-HP-Server-Sales-425029/?kc=rssReceived on Fri Aug 19 2011 - 15:34:08 CDT