Re: RE: Largest shared pool
- From: tim@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 6 Apr 2004 08:50:12 -0600 (MDT)
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@xxxxxxxxxxxxx]=20
Sent: Monday, April 05, 2004 11:03 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
