From hamcdc@yahoo.co.uk Fri, 11 May 2001 11:32:02 -0700 From: =?iso-8859-1?q?Connor=20McDonald?= Date: Fri, 11 May 2001 11:32:02 -0700 Subject: RE: Which tables are in buffer cache.? Message-ID: MIME-Version: 1.0 Content-Type: text/plain I think if you offline a tablespace (or is it read-only? I can't remember), then any relevant buffers are flushed out... hth connor --- "Hillman, Alex" wrote: > Mark, how do you manually remove objects from buffer > cache? I saw you > writing before that you know how to do it and I > would be very interested to > know also if it is not trade secret of course. > > Alex Hillman > > -----Original Message----- > Sent: Friday, May 04, 2001 11:11 PM > To: Multiple recipients of list ORACLE-L > > > 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" > > 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@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@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.com > -- > Author: Hillman, Alex > INET: Alex.Hillman@usmint.treas.gov > > 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@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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc@yahoo.co.uk 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@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).