| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simple SGA help
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07F0B.A9DDF57C
Content-Type: text/plain
William,
What tool? I don't trust them as far as I can throw them.
What does this query show you?
elect trunc(100*(1-(p.value/(d.value+c.value))),1)
from v$sysstat p, v$sysstat d, v$sysstat c
where c.name = 'consistent gets'
and p.name = 'physical reads'
and d.name = 'db block gets'
/
What type of application runs on this system? When was the last time the database came down? What recent activity has happened on the database? Depending on the answer to these questions, you may or may not want to strive for a better buffer cache hit ratio - what you have may be reasonable.
db_block_buffers will increase the db buffer cache in your sga and may
"improve" your buffer cache hit ratio.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: William Rogge [mailto:William_Rogge_at_voltek.com]
Sent: Monday, January 15, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L
Subject: Simple SGA help
OK, so I have a new utility to monitor overall SGA usage. Breaks it down to show statistics on the major components.
Nothing that unusual, but, I notice that 'Buffer Cache Hit Ratio' is low from my perspective (78.56%). 'Library Cache Hit Ratio' is running at 97.54%, while 'Data Dictionary Cache Hit' is running at 96.11%. I would like to increase 'Buffer Cache Hit Ratio' to about 93-95% but am unsure which SGA parameter I need to increase.
Thanks for your assistance.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: William_Rogge_at_voltek.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ------_=_NextPart_001_01C07F0B.A9DDF57C Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Simple SGA help</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>William, </FONT> </P> <P><FONT SIZE=3D2>What tool? I don't trust them as far as I can = throw them. </FONT> </P> <P><FONT SIZE=3D2>What does this query show you?</FONT> </P> <P><FONT SIZE=3D2>elect = trunc(100*(1-(p.value/(d.value+c.value))),1)</FONT> <BR><FONT SIZE=3D2>from v$sysstat p, v$sysstat d, v$sysstat c</FONT> <BR><FONT SIZE=3D2>where c.name =3D 'consistent gets'</FONT> <BR><FONT SIZE=3D2>and p.name =3D 'physical reads'</FONT> <BR><FONT SIZE=3D2>and d.name =3D 'db block gets'</FONT> <BR><FONT SIZE=3D2>/</FONT> </P> <P><FONT SIZE=3D2>What type of application runs on this system? = When was the last time the database came down? What recent = activity has happened on the database? Depending on the answer to = these questions, you may or may not want to strive for a better buffer = cache hit ratio - what you have may be reasonable.</FONT></P> <P><FONT SIZE=3D2>db_block_buffers will increase the db buffer cache in = your sga and may "improve" your buffer cache hit = ratio.</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: William Rogge [<A = HREF=3D"mailto:William_Rogge_at_voltek.com">mailto:William_Rogge_at_voltek.com= </A>]</FONT> <BR><FONT SIZE=3D2>Sent: Monday, January 15, 2001 9:01 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Simple SGA help</FONT> </P> <BR> <P><FONT SIZE=3D2>OK, so I have a new utility to monitor overall SGA = usage. Breaks it down </FONT> <BR><FONT SIZE=3D2>to show statistics on the major components.</FONT> </P> <P><FONT SIZE=3D2>Nothing that unusual, but, I notice that 'Buffer = Cache Hit Ratio' is low </FONT> <BR><FONT SIZE=3D2>from my perspective (78.56%). 'Library Cache = Hit Ratio' is running at </FONT> <BR><FONT SIZE=3D2>97.54%, while 'Data Dictionary Cache Hit' is running = at 96.11%. I would </FONT> <BR><FONT SIZE=3D2>like to increase 'Buffer Cache Hit Ratio' to about = 93-95% but am unsure </FONT> <BR><FONT SIZE=3D2>which SGA parameter I need to increase.</FONT> </P> <P><FONT SIZE=3D2>Thanks for your assistance.</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: William Rogge</FONT> <BR><FONT SIZE=3D2> INET: William_Rogge_at_voltek.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT>Received on Mon Jan 15 2001 - 09:56:03 CST
 |
 |