Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWR report with errors

NadviJul 14 2010 — edited Sep 25 2013
Hi,

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.
This post has been answered by baskar.l on Jul 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2013
Added on Jul 14 2010
16 comments
4,114 views