Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: v$bh.class#

Re: v$bh.class#

From: Anjo Kolk <anjo_at_oraperf.com>
Date: Thu, 20 Nov 2003 05:19:54 -0800
Message-ID: <F001.005D742D.20031120051954@fatcity.com>


This one is easy:

look in v$waitstat. That has the class numbers for all block classes. Then add to that the undo segments. Each undo segment has two types of class. A undo header class and undo block class. So by looking at v$waitstat you should be able to tell that 36 is a undo block that belongs to rollback segment 10 or so (depending on the number of rows in v$waitstat).

Anjo.

> Tanel,
>
> Thanks for the info, unfortunately it does not explain what I am seeing
> (almost, but not quite). I'll see if I can figure it out.
>
> Daniel
>
> Tanel Poder wrote:
>
> > I think Ixora website had the list with 9i stuff in it, but you also can
get
> > some of the class definitions out by checking gv$waitstat's source:
> >
> > select inst_id,decode(indx,1,'data block',2,'sort block',3,'save undo
> > block', 4,'segment header',5,'save undo
> > header',6,'free list',7,'extent map', 8,'1st level bmb',9,'2nd level
> > bmb',10,'3rd level bmb', 11,'bitmap blo
> > ck',12,'bitmap index block',13,'file header block',14,'unused',
15,'system
> > undo header',16,'system undo block
> > ', 17,'undo header',18,'undo block'), count,time from x$kcbwait where
> > indx!=0
> >
> > Tanel.
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, November 19, 2003 12:14 AM
> >
> > > In constructing my last answer, I looked at v$bh and the class#
> > > column (thinking that perhaps indexes or index headers had their
> > > own class). I came across several different values for the
> > > class# from 0 to 36 (not inclusive). Oracle's doc does not clear
> > > it up and Steve Adam's book's information does not match up to a
> > > 9i db. Before I head down the path of figuring this out on my
> > > own, anyone have a listing for the class# in 9i?
> > >
> > > Daniel Fink
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Daniel Fink
> > > INET: Daniel.Fink_at_Sun.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: Tanel Poder
> > INET: tanel.poder.003_at_mail.ee
> >
> > 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: Daniel Fink
> INET: Daniel.Fink_at_Sun.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: Anjo Kolk
  INET: anjo_at_oraperf.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 Thu Nov 20 2003 - 07:19:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US