Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to translate the value of state in the X$BH?

How to translate the value of state in the X$BH?

From: Reza Abouk <Reza.Abouk_at_mci.com>
Date: 1997/03/07
Message-ID: <332029ff.242247833@news.internetmci.com>#1/1

Are the following assumption correct??

SQL> select state, count(*)
  2 from x$bh
  3 group by state;

STATE COUNT(*) Assumption

---------     ---------       --------------------
        0         2         Total blocks NOT been used ?
        1      3968      Total blocks  used ?
        3        30         ?
             ----------
              4000         Total DB_BLOCK_BUFFERS

Regards,

Reza Abouk Received on Fri Mar 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US