RE: Largest shared pool

From: <jtesta_at_dmc-it.com>
Date: Tue, 6 Apr 2004 10:36:51 -0400 (EDT)
Message-ID: <36949.155.188.255.4.1081262211.squirrel@www.dmc-it.com>

How is this:
SQL> show sga;

Total System Global Area          72243846544 bytes
Fixed Size                             834960 bytes
Variable Size                      2432696320 bytes
Database Buffers                  69809995776 bytes
Redo Buffers                           319488 bytes

SQL> original message below

I've had an Oracle analyst tell me in MetaLink, that it's not uncommon to have a 10GB shared pool, which I thought was ludicrous, but, she was adamant. But, Tim seems to have topped even that statement!

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"

-----Original Message-----
From: Tim Gorman [mailto:tim_at_sagelogix.com]=20 Sent: Monday, April 05, 2004 11:03 PM
To: oracle-l_at_freelists.org
Subject: Re: Largest shared pool

RDBMS 9.2.0.4 64-bit
Solaris 5.9 (E15K, 36 UltraSPARCIII 1.2Ghz CPUs, 160Gb RAM)

SHARED_POOL_SIZE =3D 14,352Mb (i.e. 14.02Gb).

>From V$SGASTAT where POOL =3D 'shared pool':

free memory =3D 434.05 Mb
SQL area =3D 12,099.33 Mb

I think it's way too big for the application (DW), but with 160Gb of RAM to
use up, we're doing our best! I've thought about throwing office parties in
all that RAM, but then I worry about the sticky mess the next day. And don't even ask about DB_CACHE_SIZE... :-)

We're not experiencing problems querying V$SQL or unusual latch contention
or anything (yet)...

on 4/5/04 2:54 PM, Paul Baumgartel at treegarden_at_yahoo.com wrote:

What's the largest shared pool size you've ever seen? =20
I'm doing an evaluation of a company's Oracle environment and, boy, is their shared pool huge. Before I say it's the largest I've ever seen, though, I'd like to get some confirmation!

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
 -----------------------------------------------------------------
 ----------------------------------------------------------------

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

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 - 09:40:30 CDT