查看联机重做日志组及成员
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;
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
SQL> col group# for 99999 SQL> col thread# for 99999 SQL> col grp_status for a10 SQL> col member for a30 SQL> col mem_status for a10 SQL> col mbytes for 999999 SQL> SQL> set linesize 400 SQL> SQL> 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; GROUP# THREAD# GRP_STATUS MEMBER MEM_STATUS MBYTES ------ ------- ---------- ------------------------------ ---------- ------- 1 1 INACTIVE /ora_data/allah/redo01.log 50 2 1 CURRENT /ora_data/allah/redo02.log 50 3 1 INACTIVE /ora_data/allah/redo03.log 50 SQL> |
————————————————————————
Ending。
