UNSOLVED
AWR Analysis Feature Requests
Greetings!
I'm working on an AWR analysis tool and I'd LOVE to hear some suggestions from my peers! Here's the gist of the tool: Upload an AWR report and receive an analysis based upon the content of that report.
I recognize that the general idea is a bit vague but that's where you come in! What kind of output would you like to see? What do you think is the most important bits? What sort of calculations are most important to you? Let me know and I'll strive to add 'em to the tool. How's that for a deal?
Rob
Allan! Thanks tons for the references.
Right now my goal is to suck in AWR reports so that they can be parsed using a rule engine that can be configured. Once I can successfully parse and store AWR reports I'm going to work on the mechanisms to do calculations and that sort of thing.
R.
dba_hba
63 Posts
207
0
Posted September 20th, 2011 06:00
Robert
Not sure what your approach is to developing an "AWR Analysis tool" but a couple of good starting points when investigating aims and functionality
Have a look at Tyler Muth's blog on his Chrome extension: AWR formatter: http://tylermuth.wordpress.com/2011/07/12/awr-formatter-1-6-released/
An alternative is Karl Arao's various sql scripts and presentation on "Mining the AWR"
http://karlarao.wordpress.com
Kyle Hailey - has good info and scripts on ASM and ASH
http://dboptimizer.com/
Allan