RE: KEEP creep

This is a multi-part message in MIME format.

------=_NextPart_000_0146_01C00370.57F999D0
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Alex,

Yes, if multiple processes are querying the same block with a snapshot SCN prior to the last change to that block, then each process will have to rollback that change on a new copy of the block, whereas otherwise they might have been able reuse the same cached CR block. This is most likely with index branch blocks after a block spilt.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----

From: Alex Hillman [mailto:alex_hillman_at_physia.com] Sent: Friday, 11 August 2000 8:09
To: 'Steve Adams'
Subject: RE: KEEP creep

Is there any adverse consiquences of using this parameter? Alex Hillman
-----Original Message-----

From: Steve Adams [mailto:steve.adams_at_ixora.com.au] Sent: Thursday, August 10, 2000 3:21 PM To: Alex Hillman; Multiple recipients of list ORACLE-L Subject: RE: KEEP creep

Hi Alex,
I presume that's a typo. It is CR blocks, not CR locks. Sorry if the previous message was a bit cryptic. I was about to go to bed, and I knew

that Mark would still be at work and would appreciate a quick answer. I also knew that he would understand. Anyway, CR means consistent read. A CR block is a temporary copy of the current mode block that has been rolled back for the purposes of read consistency. The parameter setting causes CR blocks to be placed at the LRU end of the cache where they will be immediately reused once unpinned. Regards,
Steve Adams

http://www.ixora.com.au/ 
http://www.oreilly.com/catalog/orinternals/ 
http://www.christianity.net.au/ 

-----Original Message-----

From: Alex Hillman [mailto:alex_hillman_at_physia.com] Sent: Friday, 11 August 2000 3:19
To: Multiple recipients of list ORACLE-L Subject: RE: KEEP creep

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

• ERG Group -------------------------- The contents of this email and any attachments are confidential and may only be read by the intended recipient.

  ---

-- 
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-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). 
-- 
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_000_0146_01C00370.57F999D0

Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+IhUWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCAALAAgALAAAAAUAIwEB
A5AGALQOAAAoAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMANgAA
AAAAHgBwAAEAAAALAAAAS0VFUCBjcmVlcAAAAgFxAAEAAAAWAAAAAcADHIYzWYSppWoyEdS0DAAA
6PB6CAAAAgEdDAEAAAAeAAAAU01UUDpTVEVWRS5BREFNU0BJWE9SQS5DT00uQVUAAAALAAEOAAAA
AEAABg4AuJJ5HAPAAQIBCg4BAAAAGAAAAAAAAAAz2g28Aai9EaxFirPDpUTTwoAAAAsAHw4BAAAA
AgEJEAEAAAAQCgAADAoAANAVAABMWkZ1r7x/OwMACgByY3BnMTI18jIA+zM2AegCpAPjAgAEY2gK
wHNldDAgXwcTAoMAUAPVEVV9CoF2SQiQd2sLgGQ0DGBjBwBQCwMLYG5nMzA4IxHxC8QgSGkRQGxl
XHgsCqIKhAqAWQeQLIIgBpAgbXVsdAUg6RWwIHADYGMHkBEABCBLCsAXoHEKUHJ5C4BnSCB0aBeg
c2EHgCDzAmAX4GsgA/AZMBhQGWBAbmFwc2hvBUBTlENOF7FpBbF0bxkjfQtgcwVAEMEUgBegG8Nh
3wVAGcMW4BkxA6BlANAaUNsXxRoRbAMgENB2HNMDYP0fIGIA0BoAHSMchQIgGmHmbgfRBaBweSEQ
FxAZMn0ddXcZQAlwHEAhEBkxcg8D8RzRGUAh4G1pZ2j7BUAfU2IJ4RhQAmAXoAlwNnUj1BlkYx5B
CYAgQ8JSGbQuIFRoBAAW8AcEIARgHFFsaWtlbN8h4BojE4EVwBmwcgBwHlE/GcMYQQGABJAaYRnE
c3A5AxB0LhX6EdEH8GVnNwsRFtAV9FMqkB9xQWQPGYAQkBYDJIB0cDovRC93LxAuaXgFsGGCLgWg
bS5hdS8uT9UFsGUfEXkvoi8mkAGQeQkAZy8FsAuAKpEaoGz2czAfL6BoBRAcUAcwAwC+dDGQIXAr
kC/3FfotNqJ6TwUQZwuAB0AF0BgBYdccwDajFfRGA2E6FZMVYZsfIAOCWwDAK3FvOgdADRXAXyew
OXNAcGh52wCQL5NdLTUJ8HQ44DigKmkuAHkW4DEskEF1HmclwAVAAdA9wCA4OpQwORX0VDowICct
mWInLTV1YmoFkDxhUsJFOOBLRUVQHHAJ0fJwNY8KSQQgI3IXoABw+yHgGFBkH3AQ8SGhAIEYof8p
wAeRIgElwBj0J8EKsRmB/SqRPwrjCoA5CzZPN11GVX84pC2ZOcccUC2xL+AuAkC9L1pdRlU8NCeg
CHBzPMMZPUUxMBbgPbMzOjK5LJBQTUZVPqI5CjsF0PsXRglwYwUgCJACMESzKHABHFFPUkFDTEUt
/kxNNkAvQTNGVRX6FXZGVbZJF7EHkHUZkR0iJxhB0RkgeXBvJ4BJBUAnwXsnBhbRbhrxJwEqEyeA
U/8FsBjQFvIZMhX0WAETMAhg/ygBN5QaECMxKtEaMEEhWSDdF2BjWVFdlAbgdQVAG8HuZxvRG9Al
AGQW4ABwJuDdV+BrIXIV9B0jTQrAGgH9CGBsJuA0gR8hJQAYUAVA/2IgYfFgcmIkGrBYAVJQHUD/
QxEYkQ3gY3ID4ASQXrIV9L8y8RvQYNMdIxlBYiR1KUHvEPABkBOQJ4BBQ0BdoDzh/ycBB4AGIkQD
S6ECMCWRQ4CfaIFGVScGJ+JY8WVtWTD3KaBbkSG6YwhwCXBqMQRi/xm1ZwQjMSUDFfQf0ibRIBP3
AhAboRlBcAhwWTAYIiIB+2piaahjMZAnkRehRcYZYP8REBdgGQEV9CaQJcFZuV/kPxewC2AX8GQR
X3EZQUxS/lUeIGCBbRYmoiLUI/QV9O8fA2LhB3AHgGRkkiixJaPvd4FEgWfRK2BuIXBocRX0/yy2
TTZKeTM/L1t+LzEvMj7/gB80P3/ZNe9IT0lfOQ86H887KU07PJ9PRjE5UBlRr79Sv1PPVN+FvwhR
YlF5CGD/HiALYAbgKaBksyhwAkAXkf9eAheBHEAXoEmAIuAdQVmk/1oVIuEDoHjZENBkQCUiY6L7
IHNEEWVEX0VsfAZGz4avf4e/Sf9LD0wfTS9OPz2kN/g6MzQRQFAKjz+QT5Ff/5Jvk38VcWHSV2Zz
ERhxJ8H/WoAZYBPQGlAXYAeAX1EngP5XHTKU4hhiEQCBUBkBJ8H/GTIBEanxIfJpIm4SFfQqBP18
BlmU8RrRYkJi4iViG8FvY0QDYGfhRVRiIeBz9l/YZGJfN8AY8V8DUAngyHplXwUAID1QFncw/kV8
D30fgz9/P4BPgV+Cb/+Df4SPqy+eH58vo99PED07+45gpfAzpl+nb6h/we3K799X0RmAGSAY1a3h
abbwIRB/qdMEIHC2QONZMAbwIRI4cC4xLjach5mSB0B5m81xGtF3BCBPEDgsPcLfKgVwsljxJVIW
4HkREBbwvQVAZh8RsDRA47G1dbCh/wXAzvJXZiLgDeApEdExAdD/0Ym4FnMSFcDMsBpwDiDRiv8Y
YiGiCJCa89TUrbLTYbTD/xoiC4BY4gdxnJUocCRQBUH/1bUeAREACsAQwBj2bwEaUPcQwQuABCAo
BbFmgVfgJQD7KHAtsSly80MCGHGt0SNj/5yVzabbwWEmzom4FlfgH1T3CIEm4ADAeAdwWEBgYyRQ
+wMA5aJuWEAlANqxIgG2IeEZw19scnXn0B1AJrH/HuIaQdxmlgMV9LCUXrIfU/9aggRhBpDlIhky
thLnhN6y/+dwE9AokMjg5BhiJFgB1QL/FwFeEd3U67XU1XgUcLIJAN8csQXAcLZvlZqBaQlx1Gv/
31ElAHTTYKPREBkjIuAG8O8c0SVTJ8EmlCkW4C2xA6D/W8Mn8mljYSnc9+fwBjGVxxZzCQBlk0Ho
hU9MVP1BEHM7QGwhFtFEAmhBlnH/BJBwsQOBe1EnwbG1dAGcaf9DQAIgF6D0o5cjG8EciNgx/3di
7+/d1K5GRkYstZ3FYdMPy0/CagZfBsQgRVJH/CBHtLGrEAbPB0jCdHMD/0QBahKa80VjbDCKIWBj
QzL/HUD1kBDA3DDI0hhiRAHTgP9oAA+gEXEKJuXjjRAhEXqR/2LhcfO1YRkyMpIpQSbgyGf/uBYJ
HxN/FI8JTwS/woWcljtfYBrgcokQCjVZYE5FqlSJEG0qkGUckUC+0LxnZwgyL6Kf1mGhQzTR3CBO
c6BjQ4xwclzAmtIDHUGfsSg4NTgpIIA1MzgtNTA1jWB5jMBBWIkQHb25JZ2hRP/Z8F/AaQGKgOuA
0lDmQNKA2yGln7FQqcAocGNZYDKj/9MhdmCa0f1AvzAEQGKgm2L+TMlR/UYVfyYvJz8oT1AXYUCR
TU9WRZTSQ8Fs/3HQtrAbIfc0I/XJQlpgc/D7DGMH0C0j4l0XYSU+sSRi4kdxQHVAZugxNNIbEqYo
WoFxEEVYqOBUAfCvmXBwEJtid6EnLpYnHfCHYHLiu10mQk9EWVpg8cNgY2x1biGVwv7hCuIH3yGb
YYkQVU5TVUL/qL7fcvTyw3DcMXehK6qU0/9doGoxdeSq4OtQ5NBgkCsCfeBxILLyD1JmCSyD9PJI
/EVMQRG7wJ2ROjHSUeF078Ng/KPIAM9BKNzA7UCt8fRic15AaV4AtoDgcRe//xjEuY8Zd6HvovUb
TxxfHW//Hn8fjyCfIa8ivyPPJN9PL/9QP1FPKR8qLys/LE8tXy5v/y9/MI8xnzKvM780zzXfNu//
N/85DzofOy88Pz1PPl8/bgp9ZOAAafAeAEIQAQAAADsAAAA8MjE1M0M5Q0NDOUUzRDIxMUEwRTMw
MDEwNUFFMkI0NzMxNEM0OTZAY29wcGVyLnBoeXNpYS5jb20+AAALAACACCAGAAAAAADAAAAAAAAA
RgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAFgAggBgAAAAAA
wAAAAAAAAEYAAAAAUoUAACdqAQADAAiACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAC4AI
IAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAAHgAVgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEA
AAAEAAAAOS4wAAsAGYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAbgAggBgAAAAAAwAAA
AAAAAEYAAAAAGIUAAAAAAAAeACqACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAA
HgArgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4ALIAIIAYAAAAAAMAAAAAA
AABGAAAAADiFAAABAAAAAQAAAAAAAAALANmACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAsA
2oAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAHgD9gAggBgAAAAAAwAAAAAAAAEYAAAAAg4UA
AAEAAAATAAAANzQyNTYzMjIyLTEwMDgyMDAwAAACAfgPAQAAABAAAAAz2g28Aai9EaxFirPDpUTT
AgH6DwEAAAAQAAAAM9oNvAGovRGsRYqzw6VE0wIB+w8BAAAATQAAAAAAAAA4obsQBeUQGqG7CAAr
KlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4AQCqADfZbgAAAEQ6XE1haWxcZm9sZGVycy5w
c3QAAAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAOAAAADxMTkJCS01FRkxKR0pNT0JKRUZITENF
T0tHTEFBLnN0ZXZlLmFkYW1zQGl4b3JhLmNvbS5hdT4AAwAGEPcJVJgDAAcQDQ8AAAMAEBAAAAAA
AwAREAEAAAAeAAgQAQAAAGUAAABISUFMRVgsWUVTLElGTVVMVElQTEVQUk9DRVNTRVNBUkVRVUVS