Database Administration (MOSC)

MOSC Banner

RAC Database - Log Activity per Instance

edited Apr 17, 2017 10:28AM in Database Administration (MOSC) 4 commentsAnswered ✓

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

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