(5.6)
show binary logs;
(12cR1)
select * from v$log order by group#,thread#;
select * from v$logfile order by group#,member;
https://tihiro.hatenablog.com/entry/2020/04/24/080849
(9.4)
select pg_xlogfile_name( pg_current_xlog_location() );
(10)
select pg_walfile_name( pg_current_wal_lsn() );
select * from sys.database_files
where type = 1
;