Welcome! Wikis are websites that everyone can build together. It's easy!

Location: The Official Oracle Wiki

Discussion: Analyze AWR reports


Watch

Anonymous  (Get credit for your thread)


luisvelasco

luisvelasco
Analyze AWR reports
Jan 10 2008, 10:30 AM EST
Hi, I am looking for a tool to analyze a set of awr snapshots, something like WISE or spviwer. Any ideas?
Help will be appreciated
Regards,
Luis
4  out of 21 found this valuable. Do you?    
girlgeek
girlgeek
RE: Analyze AWR reports
Jan 10 2008, 3:03 PM EST
Do you mean something other than awrrpt.sql?

Oracle provides reports that you can run to analyze the data in the AWR. These reports are much like the statspack reports prior to Oracle Database 10g. There are two reports: awrrpt.sql and awrrpti.sql, which are available in the directory $ORACLE_HOME/rdbms/admin.
7  out of 23 found this valuable. Do you?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)