shared_pool_area size question

From: Guang Mei <zlmei_at_hotmail.com>
Date: Wed, 22 Jan 2003 12:24:59 -0800
Message-ID: <F001.00537D1A.20030122122459@fatcity.com>

Hi,

According to book "Oracle Performance Tuning 101" (By Gaja K. Vaidyanatha), page 316:

Oracle SGA Component Percent Memory Allocation

Database buffer cache         ~ 80
Shared Pool area              ~ 12

...

This means 80% of SGA should be allocated to "Database buffer cache". Now I have an oracle 8173 db running on Sun 2.8:

SQL> select * from v$sga;

NAME                      VALUE
-------------------- ----------
Fixed Size                73888
Variable Size         278183936
Database Buffers      409600000
Redo Buffers            1040384

How would I know if my "Variable Size" is too large or not? Which tables or views that I can query to find if my shared_pool_area is set properly? BTW, the db performance has been fine so far for about a year.

TIA. Guang Mei

---

The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

--

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

Author: Guang Mei
  INET: zlmei_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 22 2003 - 14:24:59 CST