Re: Enterprise slow, Standard fast?

From: Arska <NaruArska_at_hotmail.com>
Date: Sat, 06 Nov 2004 14:49:31 +0200
Message-ID: <cmih7b$eob$1@plaza.suomi.net>

Sybrand Bakker wrote:

> On Sat, 06 Nov 2004 10:07:18 +0200, Arska <NaruArska_at_hotmail.com>
> wrote:
> 
> 

>>Can anyone tell me what we need to different way in EE?
>>Modifications to application? Oracle settings? OS?
>>
>>About enviroment:
>>HP Proliant DL 380 G4
>>2 * 3.6 GHz Xeon
>>4 GB RAM
>>12 * 36 GB 15000 rpm disk, RAID 0+1
>>White Box Enterprise Linux 3.0
>>(Tested with RH7.3 and FC2 too)
>>Tested with oracle:
>>9.2.0.4 SE (fast)
>>9.2.0.5 SE (fast)
>>9.2.0.4 EE (slow)
>>9.2.0.5 EE (slow)
>>10.2.0.3 EE (slow)
>>
>>Settings:
>>Shared pool: 600 MB
>>Buffer cache: 400 MB
>>Large pool: 400 MB
>>Java pool: 32 MB
>>Aggregate PGA target: 665 MB
>>Open cursors: 10000
>>Processes: 300
>>Other settings have default value.

> 
> 
> 
> I would recommend trying to learn Oracle and trying to learn to
> develop applications instead of just cranking up settings.
> The above settings are absolutely ridiculous, especially the open
> cursors as that is a *per session limit*.
> Also your post doesn't contain the slightest trace of analysis what
> the EE instance is waiting for.
> Your general claim EE is slower than SE is just absolute nonsense, and
> shows your ignoramce.
> 
> 
> --
> Sybrand Bakker, Senior Oracle DBA

Thanks for the nice answer.
You are absolutely right. I don't konow much about oracle. But I know, if I set open cursors to, for example 1000, sometimes one of our applications can not get cursor.
And I know, our application develeper know something about oracle and he can't understand what is wrong in our installation. Installed many times beginning from OS inst, but result is always the same: SE works ok, but EE is REALLY slow.
EE instance is waiting nothing, but still it does not use cpu more than 25%.
Just like there is limit for cpu usage, but it should not be exist.

If my settings are plain wrong, why SE does perform ok? Received on Sat Nov 06 2004 - 06:49:31 CST