AWR report with errors
NadviJul 14 2010 — edited Sep 25 2013Hi,
My AWR report is generating some warnings with ORA- errors. Many of the statistics are missing due to this.
The database is in good health and running. Most surprisingly the same happening with another instance too. Both are 11g instances and OS is RHEL.
WARNING (-20023) ORA-20023: Missing start and end values for time model stat: parse time elapsed WARNING (-20023) ORA-20023: Missing start and end values for time model stat: DB CPU WARNING (-20016) ORA-20016: Missing value for SGASTAT: free memory WARNING (-20016) ORA-20016: Missing value for SGASTAT: free memory WARNING (-20009) ORA-20009: Missing System Statistic logons current WARNING (-20009) ORA-20009: Missing System Statistic logons current WARNING (-20009) ORA-20009: Missing System Statistic opened cursors current WARNING (-20009) ORA-20009: Missing System Statistic opened cursors current WARNING (-20023) ORA-20023: Missing start and end values for time model stat: sql execute elapsed time WARNING (-20008) ORA-20008: Missing Init.ora parameter undo_management WARNING (-20008) ORA-20008: Missing Init.ora parameter db_block_size WARNING (-20016) ORA-20016: Missing value for SGASTAT: log_buffer WARNING (-20023) ORA-20023: Missing start and end values for time model stat: DB time WARNING (-20008) ORA-20008: Missing Init.ora parameter timed_statistics WARNING (-20008) ORA-20008: Missing Init.ora parameter timed_statistics WARNING (-20008) ORA-20008: Missing Init.ora parameter statistics_level WARNING (-20008) ORA-20008: Missing Init.ora parameter statistics_level WARNING (-20008) ORA-20008: Missing Init.ora parameter sga_target WARNING (-20008) ORA-20008: Missing Init.ora parameter pga_aggregate_target WARNING (-20023) ORA-20023: Missing start and end values for time model stat: background cpu time WARNING (-20023) ORA-20023: Missing start and end values for time model stat: background elapsed time WARNING (-20023) ORA-20023: Missing start and end values for time model stat: connection management call elapsed time WARNING (-20016) ORA-20016: Missing value for SGASTAT: buffer_cache WARNING (-20016) ORA-20016: Missing value for SGASTAT: buffer_cache WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid.
Any idea?
Thanks.