0 Replies Latest reply: Nov 27, 2012 11:31 AM by _Joao_ RSS

    ASH Rows Detail report bug

    _Joao_
      This is just an excerpt from ASH Rows Detail report:

      select
      to_char(s.begin_interval_time,'mm/dd')  day,
      +'Executions' serial,+
      SUM(sql.executions_delta)     value
      from
      dba_hist_sqlstat        sql,
      dba_hist_snapshot         s
      where
      s.snap_id = sql.snap_id
      AND SQL.sql_id=:SQL_ID
      GROUP BY to_char(s.begin_interval_time,'mm/dd'),sql_id;

      It's missing a predicate chunk:

      and s.instance_number = sql.instance_number

      Otherwise the number of executions will double

      SQLDeveloper version:     3.2.09.30
      Sorry my english