Code:
col group# for 99999
col thread# for 99999
col grp_status for a10
col member for a30
col mem_status for a10
col mbytes for 999999

set linesize 400

select a.group#,a.thread#,a.status grp_status,b.member member,b.status mem_status,a.bytes/1024/1024 mbytes from v$log a,v$logfile b where a.group#=b.group# order by a.group#,b.member;

————————————————————————
Ending。

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装