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).