Re: free buffers in buffer cache

From: Scott Stefick <sstefick_at_harpercollege.edu>
Date: Mon, 05 May 2003 10:03:14 -0800
Message-ID: <F001.0058FD31.20030505100314@fatcity.com>

Cool Igor, thanks for the tip.

-SS

At 08:47 AM 5/5/03 -0800, you wrote:
>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).

Received on Mon May 05 2003 - 13:03:14 CDT