isitdevops.com/databases

—
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