5 Replies Latest reply on Oct 1, 2015 9:56 AM by rharland2012

    Can DPA track or report on the amount of time taken by a single execution of a certain query in Oracle?

    rharland2012

      Hi there!

       

      I'm a new user of DPA - we were fortunate to get greenlit to bring it into our environment to give more visibility to our Oracle backend performance.

      I had a question from one of our developers today, and I don't have an answer....so I'm throwing it out to thwack.

      Subject line sums it up, really - Can DPA show how long a certain execution of a query takes?

      One additional small question as well. My dev also asked if DPA prunes data (that is, excludes recording/capture of certain queries), or does it truly capture all queries performed against the DB?

      Thanks for any info!