RE: free buffers in buffer cache

From: Arvind Kumar <arvindk_at_sqlstarintl.com>
Date: Mon, 05 May 2003 04:49:00 -0800
Message-ID: <F001.0058F429.20030505044900@fatcity.com>

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.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arvind Kumar
  INET: arvindk_at_sqlstarintl.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). Received on Mon May 05 2003 - 07:49:00 CDT