Re: Largest shared pool

From: Tim Gorman <tim_at_sagelogix.com>
Date: Mon, 05 Apr 2004 21:02:33 -0600
Message-ID: <BC9779E9.12C8D%tim@sagelogix.com>

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

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

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

free memory = 434.05 Mb
SQL area = 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?
>
> 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
-----------------------------------------------------------------

Received on Mon Apr 05 2004 - 21:59:58 CDT