Message-Id: <10742.126679@fatcity.com> From: "Koivu, Lisa" Date: Mon, 15 Jan 2001 10:56:03 -0500 Subject: 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 http://www.qode.com "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@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@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@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 RE: Simple SGA help

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 =3D 'consistent gets'
and p.name =3D 'physical reads'
and d.name =3D '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
http://www.qode.com

"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@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@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@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