Re: Largest shared pool

From: Stefan Moeding <sm_at_kill-9.net>
Date: Tue, 06 Apr 2004 08:36:55 +0200
Message-Id: <20040406063655.53F5D293D3A@pomo.hostsharing.net>

Hi!

On 4/5/2004, "Paul Baumgartel" <treegarden_at_yahoo.com> wrote:

>What's the largest shared pool size you've ever seen?

SQL> show sga

Total System Global Area 3304513412 bytes

Fixed Size                   245636 bytes
Variable Size            2484264960 bytes
Database Buffers          819462144 bytes
Redo Buffers                 540672 bytes

About 5000-6000 connected sessions and almost everything is done in PL/SQL (~1000000 lines of code).

Regards,
Stefan

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 06 2004 - 01:34:54 CDT