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
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',
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
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