Is wrh$_seg_stat bugged? (version 11.1.0.7)
[cross-posted to oracle-l]
I have a table that is showing some really strange "facts" in wrh$_seg_stat. For instance, of 1392 rows stored for this given table, 409 show SPACE_ALLOCATED_TOTAL < SPACE_USED_TOTAL, and one row where SPACE_ALLOCATED_TOTAL is negative! Database-wide, of the 161175 rows in wrh$_seg_stat, 37294 where the allocated < used and 3940 are negative. None are owned by SYS.
Since the total amount of space allocated can never be less than the total amount of space used, much less negative (now that would be a cool trick!), I have to assume there is something buggy about the way the AWR collects segment statistics. I am not finding any information on google or the Oracle KB that would verify this, though.
I have a table that is showing some really strange "facts" in wrh$_seg_stat. For instance, of 1392 rows stored for this given table, 409 show SPACE_ALLOCATED_TOTAL < SPACE_USED_TOTAL, and one row where SPACE_ALLOCATED_TOTAL is negative! Database-wide, of the 161175 rows in wrh$_seg_stat, 37294 where the allocated < used and 3940 are negative. None are owned by SYS.
Since the total amount of space allocated can never be less than the total amount of space used, much less negative (now that would be a cool trick!), I have to assume there is something buggy about the way the AWR collects segment statistics. I am not finding any information on google or the Oracle KB that would verify this, though.
0