HISTGRM$ has highest segment waits. Causes? Resolution?
When running the following
SELECT owner, object_name, SUM(VALUE) buffer_busy_count ,
round(sum(value) * 100/sum(sum(value)) over(),2) pct
FROM v$segment_statistics
WHERE statistic_name IN ('gc buffer busy', 'buffer busy waits')
AND VALUE > 0
GROUP BY owner, object_name
ORDER BY SUM(VALUE) DESC
/
The two top segments with highest waits are
OWNER | OBJECT_NAME | BUFFER_BUSY_COUNT | PCT |
-------------------- -------------------- -------------------------------- -------
SYS | HISTGRM$ | 32370 22.60 |
SYS | I_WRI$_OPTSTAT_HH_ST | 15250 10.65 |
Have never seen this before. Any ideas on the cause and how to resolve?