Re: free buffers in buffer cache

It must be "state" column for X$BH.
And the correspondence between "state" and "status" columns in two views is:

0 - "free"
1 - "xcur"
2 - "scur"
3 - "cr"
4 - "read"
5 - "mrec"
6 - "irec"

You can get this info quering V$FIXED_VIEW_DEFINITION for V$BH and GV$BH views.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, May 05, 2003 11:26 AM

> Although Arvind did a desc on the wrong View "V$BH", I don't have a status
> column on my 8i DB's in X$BH. I am running 8i and 9i. I do use the
> "status" column of "X$BH" in my 9i Databases, but I haven't seen it in my
> 8i Databases.
>
> I don't remember seeing what version of the DB Arvind is running.
>
>
> At 06:02 AM 5/5/03 -0800, you wrote:
> >Read the mail carefully. It is X$BH. NOT V$BH.
> >
> >
> >Best Regards,
> >K Gopalakrishnan
> >
> >
> >
> >
> >-----Original Message-----
> >Kumar
> >Sent: Monday, May 05, 2003 5:49 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >i tried it but no luck...
> >
> >SQL> desc v$bh
> > Name Null? Type
> > ----------------------------------------- -------- -------------
> > FILE# NUMBER
> > BLOCK# NUMBER
> > CLASS# NUMBER
> > STATUS VARCHAR2(4)
> > XNC NUMBER
> > FORCED_READS NUMBER
> > FORCED_WRITES NUMBER
> > LOCK_ELEMENT_ADDR RAW(4)
> > LOCK_ELEMENT_NAME NUMBER
> > LOCK_ELEMENT_CLASS NUMBER
> > DIRTY VARCHAR2(1)
> > TEMP VARCHAR2(1)
> > PING VARCHAR2(1)
> > STALE VARCHAR2(1)
> > DIRECT VARCHAR2(1)
> > NEW CHAR(1)
> > OBJD NUMBER
> > TS# NUMBER
> >
> >-----Original Message-----
> >Sent: Monday, May 05, 2003 4:37 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Arvind:
> >
> >Check X$BH for status=0, i.e count(*) from X$BH where status=0.
> >
> >
> >
> >=====
> >Have a nice day !!
> >------------------------------------------------------------
> >Best Regards,
> >K Gopalakrishnan,
> >Bangalore, INDIA.
>
>
> **************************************
> Scott Stefick
> Systems / Oracle Certified DBA
> Wm. Rainey Harper College
> sstefick_at_harpercollege.edu
> 847.925.6130
> **************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Scott Stefick
> INET: sstefick_at_harpercollege.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).