Re: v$bh.class#
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. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 4:14 PM > 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" <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > > > 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: [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.net > > -- > > Author: Tanel Poder > > INET: [EMAIL PROTECTED] > > > > 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: [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.net > -- > Author: Daniel Fink > INET: [EMAIL PROTECTED] > > 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: [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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] 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: [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: v$bh.class#
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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [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.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > 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: [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.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] 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: [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: 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. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [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).
v$bh.class#
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: [EMAIL PROTECTED] 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: [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).
