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 <[EMAIL PROTECTED]>
@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
