신문지한장

[SQL] redo log 그룹, 멤버 조회

현재 logfile 그룹, 멤버 조회 set line 200 col group# for 999 col mb for 999 col member for a60 col seq# for 999 col status for a8 col arc for a5 select a.group#, a.member, b.bytes/1024/1024 MB, b.sequence# "SEQ#", b.status, b.archived "ARC" FROM v$logfile a, v$log b where a.group#=b.group# order by 1,2;
Oracle/sql&script 2024. 1. 4. 10:36
이전 Prev 1 Next 다음