RE: free buffers in buffer cache

From: Scott Stefick <sstefick_at_harpercollege.edu>
Date: Mon, 05 May 2003 07:26:47 -0800
Message-ID: <F001.0058F780.20030505072647@fatcity.com>

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 - 10:26:47 CDT