Database Tuning (MOSC)

MOSC Banner

dba_hist_sqlstat, snap_id's 'Execution_total'

edited Jun 27, 2014 5:00AM in Database Tuning (MOSC) 3 commentsAnswered


How is the figure 'excutions_total' derived (how does it come to this figure) in:

select to_char(s.begin_interval_time,'mm-dd hh24')  c1 ,a.snap_id  c2, sum(sq.executions_total) c3

from dba_hist_sqlstat sq, dba_hist_snapshot s

where s.snap_id=sq.snap_id

and s,begin_interval_time between to_date('2014/06/07 00:00:00,'yyyy/mm/dd HH24:MI:SS')

     and to_date('2014/06/07 23:59:59','yyyy/mm/dd HH24:MI:SS')

group by s.snap_id, begin_interval_time

order by c1;

I tried to look in the awr report for a select snap_id in the report, the total of executes in the snap_id does not add up to that number in the report above. Where does this number, the come from? how is it calculated? anyone have any idea?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center