SQL：set linesize 400
col name for a65
select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log,(select max(sequence#) "SEQ#" from v$archived_log where applied='YES') b where sequence# between b.seq#-5 and b.seq#+9 order by sequence#;
set linesize 400;
col client_pid for a20;
select process,pid,client_pid,status,delay_mins,known_agents,active_agents from v$managed_standby;
cat alert_xxx.log | grep "Fetching gap sequence" | tail -n 1
cat alert_xxx.log | grep "(in transit)" | tail -n 1
cat
...
继续阅读
(38)