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" <Alex.Hillman_at_usmint.treas.gov>
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"
> <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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Hillman, Alex
> INET: Alex.Hillman_at_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_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).
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_at_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_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 Fri May 11 2001 - 13:32:02 CDT
