Re: Which tables are in buffer cache.?

Been here: this is a really interesting exercise! You can query v$bh (or its x$ base table) which has a record for every buffer cache block. Link on object ID's While tuning a 3000Tx/sec OLTP database I could get constant 24*7 performance by by examining objects in the buffer cache and manually removing unwanted objects at end of business day. This prevents required objects being aged out and having to be reloaded. Typical scenario is to remove the index for the partition for 'todays' transactions to make room in the buffer cache for 'tomorrows' transactions. Its good fun tuning at this level. I wrote a gui via perl & DBI that dumped the bcache contents
(similar to the oracle tablespace manager gui) and allows objects to be
manually/automatically removed from memory. I think DB2 can do this already. Does 9i allow definition of custom buffer pools
(buffer_pool_Transactions for example), each with its own aging algorithm?
Ive got the 9i beta cd here but havent even opened it. Too busy.

Mark Teehan
Singapore

 From: "Bunyamin K.Karadeniz" <bunyamink_at_havelsan.com.tr>  Date: Wed, 2 May 2001 09:23:57 +0300
 Subject: Which tables are in buffer cache.?

This is a multi-part message in MIME format.

------=_NextPart_000_00E6_01C0D2E9.9D9A9360 Content-Type: text/plain;

     charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

 Hi all gurus,
   =20
    I want to learn the way to ook at=20 Which tables are in buffer cache./Analyzed?

Is there a system view showing these tables??

Thanks to All.

Bunyamin K.Karadeniz

    Database Group / Information Systems Department=20     HAVELSAN Ankara /TURKEY
    Tel : +903122873565 / 1681
    Mobile Tel : +90 535 3357729

• ERG Group -------------------------- The contents of this email and any attachments are confidential and may only be read by the intended recipient.

  ---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Teehan
  INET: mteehan_at_erggroup.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).