Exadata X-3 Oracle 11.2.0.3
I am trying to figure out if we have excessive switch log activity.
I am using the following query.
select
inst_id
,to_char(first_time,'YYYY-MM-DD') DAY
,sum(decode(to_char(first_time,'HH24'),'00',1,0) HH00
,sum(decode(to_char(first_time,'HH24'),'01',1,0) HH01
,etc to
,sum(decode(to_char(first_time,'HH24'),'23',1,0) HH23
from gv$log_history
group by
inst_id
,to_char(first_time,'YYYY-MM-DD')
order by
inst_id
,to_char(first_time,'YYYY-MM-DD')
;
Should I be adding
where thread# = inst_id
Regards