Re: An oldie on Blocksize and Performance?

Be careful with CACHE tables in 8.0
The feature is deprecated or obsoleted
(isn't great the way Oracle nounises it verbs and verbalises its nouns) in 8.1

There is a bug which makes a CACHE
table load itself ENTIRELY into the
pool irrespective of its size. (In 7.3 the CACHE directive is ignored if
the table size is larger than the
cache_size_threshold).

BTW its the 'cache buffers lru chain' of which there is only one, and that applies to tablescans. Have you been trying to confuse us ?

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ross Mohan wrote in message <7h5k2h$680_at_sjx-ixn1.ix.netcom.com>...
>The tickler about v$latch_children is an excellent point, worthy of the
>B & B. I had thought there was only one CBC latch, and so the kids don't
>make any
>sense to me....Could you say a bit more about the children in this case?
>
>Hash buckets r us, so I don't think I've gotten to the core
>of the problem yet. Sad truth is, i don't yet have a feel for the multiple
>buffer pool in 8 yet, and suspect i am flushing madly in the first 64K of
>the CBC due to wild full table scans....but, this is a guess...i need,
>somehow
>to "instrument" my buffer cache to nail this one down....
>
>Sorry, JL, but plane fare's your worry! :) I won't order your Newcastle or
>Smithick's
>until you land.
Received on Tue May 11 1999 - 15:35:14 CDT