Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: v$bh.class#
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.
> 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).Received on Wed Nov 19 2003 - 08:19:58 CST
![]() |
![]() |