Is wrh$_seg_stat bugged? (version 11.1.0.7)

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.

Oracle EE 11.1.0.7.7, retention of 30 days, 30-minute snap interval.

For grins, I checked a 10.2.0.4 database and found that out of 19745 rows in wrh$_seg_stat, 2043 had allocated < used and 0 had negative allocation.

For the bean-counters, yes we are licensed.

--

Charles Schultz

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 01 2011 - 09:19:27 CDT