Re: Oracle - Win/Nt - 4GB Memory

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 18 Apr 2001 13:20:07 GMT
Message-ID: <bwgD6.25817$xN4.1796599@news1.sttls1.wa.home.com>

Processor utilization is probably not a ram problem. So adding more ram might not help. I suspect that the application that you are performance testing does not use host variables and it may not reuse cursors. This behavior will lead to excessive cpu usage. (see developer's manuals) If you have 8.1.7 you can try cursor_sharing=force and that might help. Of course, using host variables would be better, but that might help.

Jim

"ast" <adolf.steitz_at_also.de> wrote in message news:3add8584$0$1819$4dbef881_at_businessnews.de.uu.net...
> Hi,
>
> we're runnig OndWorld with Oracle Database on Prolinat ML5700 4x700 mhz
Xeon
> with 4 GB memory.
>
> During performance testing, processor utilization go's up an stayed on 100
%
> (all 4 processors!).
>
> Now we believe, that the problem comes up, when the oracle needs more than
2
> GB memory.
>
> Does anyone has any idea??
> Every hint is appreciated!!
>
> Thank's
>
> A. Steitz
>
>
Received on Wed Apr 18 2001 - 08:20:07 CDT