Why I found database locks in standby database (open in readonly)
edited Dec 5, 2017 7:57AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered ✓
Hello,
Anyone knows why appear database locks in standby database? (active dataguard)
I can find it with this query:
SELECT s.last_call_et, s.username, s.machine, s.program
FROM V$SESSION s
s.sid in(select blocking_session from v$session)
and s.last_call_et>40 ;
0