Re: what happened to this table x$kcbrbh ? renamed ? or Disappeared for ever

this was posted some times ago :

From: Steve Adams <steve.adams_at_ixora.com.au> To: <ORACLE-L_at_fatcity.com>; 'Marin Dimitrov' <marin_at_sirma.bg> Sent: Friday, June 23, 2000 03:59
Subject: 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"





================================================================