Database Tuning (MOSC)

MOSC Banner

Timed OS Statistics and Plan Execution Statistics are not showed in awr report when statistics_level

edited Jan 25, 2015 10:00AM in Database Tuning (MOSC) 2 commentsAnswered

---In order to see some plan statistics in awr report i set the statistics_level to ALL

SQL> show parameter statistics_l

NAME TYPE VALUE

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

statistics_level string ALL

select * from v$statistics_level where ACTIVATION_LEVEL='ALL'

STATISTICS_NAME DESCRIPTION SESSION_ SYSTEM_S ACTIVAT STATISTICS_VIEW_NAME SES

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

Timed OS Statistics Enables gathering of timed ope ENABLED ENABLED ALL YES

rating system statistics

Plan Execution Statistics Enables collection of plan exe ENABLED ENABLED ALL V$SQL_PLAN_STATISTICS YES

cution statistics

But I did not find any information about "Plan Execution Statistics" in the generated awr report.

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