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
and he has answered:
So, basically I would conclude that you are correct: There's currently no reliable/unambiguous way to distinguish between both kinds of row splits.