Database Tuning (MOSC)

MOSC Banner

HISTGRM$ has highest segment waits. Causes? Resolution?

edited Nov 16, 2016 4:00AM in Database Tuning (MOSC) 1 commentAnswered

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center