This discussion is archived
0 Replies Latest reply: Nov 27, 2012 9:31 AM by _Joao_ RSS

ASH Rows Detail report bug

_Joao_ Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points