1 Reply Latest reply on May 17, 2014 3:52 PM by Hoek

    SQL execution times

    885820

      Hi There,

       

      Wondering if someone could advise on the best way of capturing the following in an 11g database.

       

      Say we have;

      - a piece of SQL executing around 50 times a minute.

      - single execution times vary.

       

      Aside from going through dba_hist_sqlstat and generating some sort of average over a 30 min period.

      What would be the best way to obtain individual execution times of this piece of SQL in real-time.

       

      say I want the individual execution time of that last 100 executions.

       

      Any help would be appreciated

       

      Thanks