Database Tuning (MOSC)

MOSC Banner

SQL AREA STATS and SQL AREA BUILD

edited Mar 17, 2015 9:47AM in Database Tuning (MOSC) 10 commentsAnswered

Hi,

First timer on the discussion board and was wondering if someone can help/advise.  We have setup StatsPack to run on a number of system recently and noticed that Library Cache Activity is reporting very high miss rates for the SQL AREA STATS and SQL AREA BUILDS, both of which are in the high 90% ratio.


Am I correct in thinking that the SQL is being constantly reloaded? Is this normal?

Library Cache Activity  DB/Inst: Snaps: 143-153

->"Pct Misses"  should be very low

                         Get  Pct        Pin        Pct               Invali-

Namespace           Requests  Miss     Requests     Miss     Reloads  dations

--------------- ------------ ------ -------------- ------ ---------- --------

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