show archive and redo logs.sql
—
col grp form 99
col sequ form 99999
col thrd form 999
col siz_k form 999,999
col file_name form a30 wrap
select log.group#Â Â Â Â Â Â Â Â grp
,log.thread#Â Â Â Â Â Â Â Â Â Â Â Â Â thrd
,log.sequence#Â Â Â Â Â Â Â Â Â Â Â sequ
,log.bytes/1024Â Â Â Â Â Â Â Â Â Â siz_k
,to_char(log.first_time,’DD-MM-HH:MI.SS’) first_tim
,substr(log.archived,1,1) ar
,substr(log.status,1,4)Â Â sts
,logf.member             file_name
from v$log log
,v$logfile logf
where log.group#=logf.group#
order by log.group#,file_name
/
clear col
Discussion ¬