RAC Database - Log Activity per Instance
Hi
Hi
Why do I get identical log activity for RAC instances when each RAC should have it's own archive logs, online redo logs and undo tablespaces? Each instance also performs it's own DML and jobs.. I'm back to square one with RAC after two years of practical experience lol
What concept am I missing?
see select result
select
inst_id c1,
trunc(first_time) as "Date",
count(*) as "Log Activity"
from
gv$log_history
where
trunc(first_time) > last_day(sysdate-100) +1
group by
inst_id, trunc(first_time)
order by 2, 3, 1;
Thank you