| 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: KEEP creep
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_01C002E5.1EE02230
Content-Type: text/plain;
charset="iso-8859-1"
Could you elaborate a little bit please - what is CR locks, when they happen and what consequences of using this parameter.
Alex Hillman
-----Original Message-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
Sent: Thursday, August 10, 2000 7:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: KEEP creep
Hi Mark,
There is no such timeout. What you are seeing is the effect of CR mode
blocks.
You should be able to work around this by setting _db_aging_freeze_cr =
TRUE.
Regards,
Steve Adams
http://www.ixora.com.au/ http://www.oreilly.com/catalog/orinternals/ http://www.christianity.net.au/
-----Original Message-----
Sent: Thursday, 10 August 2000 19:33
To: Multiple recipients of list ORACLE-L
I am trying to size objects for the KEEP pool on 8.1.6.
An analyze shows 108,000 blocks for a table, yet it fills the KEEP
buffer pool,
which is 120,000 blocks.
The extra 12,000 blocks are copies of buffers not found within a time
limit
when searching the hash chains (or so I believe). There are no other
objects in
the KEEP pool.
I have tried maximum and minimum numbers of db_block_lru_latches with
little
effect. I have not modified the _db_block_hash_buckets.
I would prefer if it searched the buffer cache for longer for the
required
buffers (because I know the whole table is cached), even if this means
that it
runs a little slower. As with OLTP systems, constant performance is
better.
Anyone know what to change to extend the buffer cache search timeout?
Regards
Mark
-- Author: INET: mteehan_at_erggroup.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-LReceived on Thu Aug 10 2000 - 11:07:40 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Steve Adams INET: steve.adams_at_ixora.com.au 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_01C002E5.1EE02230 Content-Type: text/html; charset="iso-8859-1" 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=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: KEEP creep</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Could you elaborate a little bit please - what is CR = locks, when they happen and what consequences of using this = parameter.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Steve Adams [<A = HREF=3D"mailto:steve.adams_at_ixora.com.au">mailto:steve.adams_at_ixora.com.au= </A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, August 10, 2000 7:34 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: KEEP creep</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi Mark,</FONT> </P> <P><FONT SIZE=3D2>There is no such timeout. What you are seeing is the = effect of CR mode</FONT> <BR><FONT SIZE=3D2>blocks.</FONT> <BR><FONT SIZE=3D2>You should be able to work around this by setting = _db_aging_freeze_cr =3D</FONT> <BR><FONT SIZE=3D2>TRUE.</FONT> </P> <P><FONT SIZE=3D2>Regards,</FONT> <BR><FONT SIZE=3D2>Steve Adams</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.ixora.com.au/" = TARGET=3D"_blank">http://www.ixora.com.au/</A></FONT> <BR><FONT SIZE=3D2><A = HREF=3D"http://www.oreilly.com/catalog/orinternals/" = TARGET=3D"_blank">http://www.oreilly.com/catalog/orinternals/</A></FONT>= <BR><FONT SIZE=3D2><A HREF=3D"http://www.christianity.net.au/" = TARGET=3D"_blank">http://www.christianity.net.au/</A></FONT> </P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, 10 August 2000 19:33</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>I am trying to size objects for the KEEP pool on = 8.1.6.</FONT> <BR><FONT SIZE=3D2>An analyze shows 108,000 blocks for a table, yet it = fills the KEEP</FONT> <BR><FONT SIZE=3D2>buffer pool,</FONT> <BR><FONT SIZE=3D2>which is 120,000 blocks.</FONT> <BR><FONT SIZE=3D2>The extra 12,000 blocks are copies of buffers = not found within a time</FONT> <BR><FONT SIZE=3D2>limit</FONT> <BR><FONT SIZE=3D2>when searching the hash chains (or so I believe). = There are no other</FONT> <BR><FONT SIZE=3D2>objects in</FONT> <BR><FONT SIZE=3D2>the KEEP pool.</FONT> <BR><FONT SIZE=3D2>I have tried maximum and minimum numbers of = db_block_lru_latches with</FONT> <BR><FONT SIZE=3D2>little</FONT> <BR><FONT SIZE=3D2>effect. I have not modified the = _db_block_hash_buckets.</FONT> <BR><FONT SIZE=3D2>I would prefer if it searched the buffer cache for = longer for the</FONT> <BR><FONT SIZE=3D2>required</FONT> <BR><FONT SIZE=3D2>buffers (because I know the whole table is cached), = even if this means</FONT> <BR><FONT SIZE=3D2>that it</FONT> <BR><FONT SIZE=3D2>runs a little slower. As with OLTP systems, constant = performance is</FONT> <BR><FONT SIZE=3D2>better.</FONT> <BR><FONT SIZE=3D2>Anyone know what to change to extend the buffer = cache search timeout?</FONT> </P> <P><FONT SIZE=3D2>Regards</FONT> <BR><FONT SIZE=3D2>Mark</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>---------------------------- ERG Group = --------------------------</FONT> <BR><FONT SIZE=3D2> The contents of this email and any attachments = are confidential</FONT> <BR><FONT SIZE=3D2> and may only be read by the intended = recipient.</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= --</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author:</FONT> <BR><FONT SIZE=3D2> INET: mteehan_at_erggroup.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> <BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Steve Adams</FONT> <BR><FONT SIZE=3D2> INET: steve.adams_at_ixora.com.au</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 =
 |
 |