Is wrh$_seg_stat bugged? (version 11.1.0.7)
- From: Charles Schultz <sacrophyte@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2011 09:19:27 -0500
Good day, listers,
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
Other related posts:
- » Is wrh$_seg_stat bugged? (version 11.1.0.7) - Charles Schultz
