Eric:
Looking at my own system, the xflags column seems to always be zero and the bflags column does not seem to correspond to the type of page in the buffers. You may have to map the dbspace, chunk, and offset to the sysextents rows of every object and categorize based on whether the sysptnhdr row for that object has nrows = 0, nkeys = 1, and npdata = 0 (index partitions the only indicator that an object may not be a table partition). Though be careful of empty tables. An empty table with one attached index will look the same as a detached or semi-attached index, but probably will have not presence in the buffers anyway. Only legacy tables (those created prior to v7.30) and catalog tables typically have fully attached indexes anyway.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------