2 Replies Latest reply on Dec 15, 2015 4:03 PM by bpeasland

    Oracle Top SQL by Buffer Gets

    bpeasland

      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!