How to run AWR report in 11g Standard Edition
430060Feb 10 2009 — edited Feb 9 2012Guys
I need to know how to run AWR report in 11g SE. When I run awrrpt.sql I get some warning messages on top of report and no data in report.
I know that It is part of Performance Pack and not available in Standard Edition.
In 10g SE, I am able to run AWR manually. but not in 11g SE
Here is what I get when I run report.
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 suggesstion/workaround?