There appear to be two kinds of table data page splits:
In both cases, the split data is stored in an extension page and is counted in SYSTAB.ext_page_count as opposed to SYSTAB.table_page_count. There don't appear to be any statistics, properties or stored procedures that break SYSTAB.ext_page_count into non-blob-versus-blob splits for a table that is subject to both kinds of splits (non-blob columns that grow in size plus blob columns that can grow beyond the split limit). For example, the sa_table_fragmentation() procedure reports the total number of page splits, not the breakdown. Having a breakdown would be very helpful because performance improvement techniques like larger free space and larger page size are more likely to help with non-blob page splits than blob splits, whereas improving blob performance is a whole different area of study. Note: The Help is silent on non-blob page splits being counted in SYSTAB.ext_page_count; in fact, the phrases "page split" and "extension page" do not appear together. asked 14 Jan '15, 09:14 Breck Carter |
Just to cite from that other FAQ - wellknown to you, methinks - where I had asked Ivan:
and he has answered:
Resume: So, basically I would conclude that you are correct: There's currently no reliable/unambiguous way to distinguish between both kinds of row splits. answered 14 Jan '15, 09:31 Volker Barth |