Re: Strange Oracle behavior between different environments

From: joel garry <joel-garry_at_home.com>
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=rss
Received on Fri Aug 19 2011 - 15:34:08 CDT

Original text of this message