RE: Which tables are in buffer cache.?
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" <[EMAIL PROTECTED]> 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" > <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
RE: Which tables are in buffer cache.?
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: Which tables are in buffer cache.?
Thanks so much Suhen.. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 02, 2001 11:25 AM > Bunyamin, > > You can check how many blocks are in the buffer cache for segments through > the x$bh and v$bh views. > > Try this query, > > select "count",b.object_name from > (select count(*) "count",objd from v$bh > group by objd) a, user_objects b > where a.objd=b.data_object_id > / > > Regards > Suhen > > > > > > Hi all gurus, > > I want to learn the way to ook at > > 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 > HAVELSAN Ankara /TURKEY > Tel : +903122873565 / 1681 > Mobile Tel : +90 535 3357729 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Suhen Pather > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Which tables are in buffer cache.?
Bunyamin, You can check how many blocks are in the buffer cache for segments through the x$bh and v$bh views. Try this query, select "count",b.object_name from (select count(*) "count",objd from v$bh group by objd) a, user_objects b where a.objd=b.data_object_id / Regards Suhen Hi all gurus, I want to learn the way to ook at 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 HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Which tables are in buffer cache.?
Hi all gurus, I want to learn the way to ook at 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 HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
