DPA is great for sending me a weekly report on my Top SQL. However, those SQL in the report are those that experience high waits. I often have to tune SQL statements that use lots of CPU. These high CPU consumers often have a very large number of Buffer Gets per execution (logical I/O). Since the blocks are in the Buffer Cache, there is very little wait events. How can I get Solarwinds DPA for Oracle to report on top CPU consumers or those with lots of I/O? I can't seem to find a canned report ready for me.
Thanks in advance!
