Oracle-L: Re: shared_pool_area size question

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 22 Jan 2003 13:14:53 -0800
Message-ID: <F001.00537E47.20030122131453@fatcity.com>

Try:
compute sum of bytes on report
break on report
column name format a30 heading 'Memory Structure' column bytes format 999,999,999,999 heading 'Bytes' select * from v$sgastat
/

                                                                                                                                       
                      "Guang Mei"                                                                                                      
                      <zlmei                   To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      @hotmail.com>            cc:                                                                                     
                      Sent by: root            Subject: shared_pool_area size question                                                 
                                                                                                                                       
                                                                                                                                       
                      01/22/2003 03:24                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

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

--

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

Author: Thomas Day
INET: tday6_at_csc.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