redo log file 정보 보기
작성자 관리자 작성시간 2003-07-23 16:39:15
 

col member format a40
select v$logfile.member,v$logfile.group#, v$log.status, bytes
from v$logfile, v$log
where v$logfile.group# = v$log.group#;


SQL> @LABS/redologfile

MEMBER                                      GROUP# STATUS                BYTES
---------------------------------------- ---------- ---------------- ----------
/home/human/oradata/HUMAN/redo01.log              1 CURRENT          104857600
/home/human/oradata/HUMAN/redo01b.rdo            1 CURRENT          104857600
/home/human/oradata/HUMAN/redo02.log              2 INACTIVE          104857600
/home/human/oradata/HUMAN/log02b.rdo              2 INACTIVE          104857600


목록 | 입력 | 수정 | 답변 | 삭제