select name,db_unique_name,open_mode,database_role from v$database;
sho pdbs;
SELECT al.thrd “Thread”,
almax “Last Seq Received”,
lhmax “Last Seq Applied”,
(almax – lhmax) “Difference”
FROM (select thread# thrd, MAX(sequence#) almax FROM v$archived_log WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) al,
(SELECT thread# thrd, MAX(sequence#) lhmax FROM v$log_history WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) lh
WHERE al.thrd = lh.thrd;
select process, status, thread#, sequence#, block#, blocks from v$managed_standby ;
