12 lines
435 B
Plaintext
12 lines
435 B
Plaintext
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
|
|
set lines 200
|
|
|
|
-- on PRIMARY database
|
|
----------------------
|
|
select THREAD#, max(SEQUENCE#), max(FIRST_TIME),max(NEXT_TIME),max(COMPLETION_TIME) from gv$archived_log group by THREAD#;
|
|
|
|
-- on STANDBY database
|
|
----------------------
|
|
select THREAD#, max(SEQUENCE#), max(FIRST_TIME),max(NEXT_TIME),max(COMPLETION_TIME) from gv$archived_log
|
|
where APPLIED='YES' group by THREAD#;
|