EST_FRAG_STATS
Hi Expert,
I'm current testing on CTX_REPORT to get fragmentation status by specifying STAT_TYPE = 'EST_FRAG_STATS' but I always get value 0 from the output.
Tested on the same method without specify the estimated statistics and the it returns 78% estimated row fragmentation. And of course I did enabled Query Stats for this test.
CTX_REPORT.INDEX_STATS('[index_name]',X,partition_name,stat_type=>'EST_FRAG_STATS');
==>
===========================================================================
STATISTICS FOR "[index_name]"
===========================================================================
Estimated Fragmentation Stats: 0
CTX_REPORT.INDEX_STATS('[index_name]',X,partition_name);
==>
---------------------------------------------------------------------------
FRAGMENTATION STATISTICS
---------------------------------------------------------------------------
total size of $I data: 120,008,006 (114.45 MB)
$I rows: 8,819,811