19 lines
378 B
SQL
19 lines
378 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
col logfile_member head MEMBER for a100
|
|
|
|
select
|
|
l.sequence#,
|
|
l.group#,
|
|
l.thread#,
|
|
lf.member logfile_member
|
|
from
|
|
v$log l,
|
|
v$logfile lf
|
|
where
|
|
l.group# = lf.group#
|
|
order by
|
|
l.group#
|
|
/
|