RE: missing x$kcbrbh in 8.1.6

Hi Marin,

This method of sizing the cache has been of dubious value since the introduction of multiple lru latches in 7.3, more so with the introduction of multiple buffer pools in 8.0 and would be entirely wrong with the introduction of the new cache aging and replacement policies in 8.1. Therefore, it exists no more, and in my opinion that's a good thing. There is still a lack of tuning information in this area, but better that than bad information.

Have a look at the Buffer Cache tuning scripts on my web site for some hints as to how to proceed.

Regards,
Steve Adams

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


-----Original Message-----
From:	Marin Dimitrov [SMTP:marin_at_sirma.bg]
Sent:	Thursday, June 22, 2000 7:37 PM
To:	Multiple recipients of list ORACLE-L
Subject:	missing x$kcbrbh in 8.1.6

hello,

regarding the discussion about increasing/decreasing buffers , Niemiec's book (and some papers) recommend querying x$kcbrbh and x$kcbcbh

If I query them I get "table or view does not exist" on the 8.1.6 instance , but I can query them in the 8.0.5 instance. Also the related parameter DB_BLOCK_LRU_STATISTICS seems to be obsolete since 8.1.3

So, my question is - how do I get this information in 8.1.6?

thanx,

    Marin

"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"

--
Author: Marin Dimitrov
  INET: marin_at_sirma.bg

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).