Re: shared_pool_size=800M ???

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 19 Feb 2004 05:15:01 -0800
Message-ID: <1e8276d6.0402190515.1add7d85@posting.google.com>

Marc Blum <blumNOSPAM_at_marcblum.de> wrote in message news:<nah730d7metm3ce03ua1rh21l3m2hgp55p_at_4ax.com>...
> Now the developers start complaining, the shared pool ought to have 800m !!!
> I myself doesn't have any clue why any app needs so much shared pool. So please
> enlighten me with some serious reasons for that.

It could be even worse:

10:46:19 SQL> show sga

Total System Global Area 3410521788 bytes

Fixed Size                   102076 bytes
Variable Size            1362141184 bytes
Database Buffers         2048000000 bytes
Redo Buffers                 278528 bytes

Quite a big application, not very good code.

--
Dusan Bolek

Received on Thu Feb 19 2004 - 07:15:01 CST