Re: RE: Largest shared pool

To paraphrase Tim Allen: AARRRHHHH! AAARRRRHHHHH! AAAARRRRRRHHHHHH!!!

I do think that it is uncommon to have such a large Shared Pool, and also that it is largely unnecessary. But like I said, if we didn't use the memory, it would go unused. :-) There's wastage, and there's wastage...

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

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

  ---

  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

  ---