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

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/03/07
Message-ID: <5fponm$rr4@gw.PacBell.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

Roughly...the following is the translation for the states:

0	-	not currently is use
1	-	held exclusive by this instance
2	- 	held shared by this instance 
3	-	only valid for consistent read
4	-	is being read from disk
5	-	in media recovery mode
6	-	in instance (crash) recovery mode

The sum of counts should equal the total number of DB_BLOCK_BUFFERS, as you assumed above.

Johnny Chan
Independent Oracle Specialist Received on Fri Mar 07 1997 - 00:00:00 CST