- 매일 적재량 select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 size_MB from v$ARCHIVED_LOG group by trunc(completion_time); - 로그파일 사이즈 select a.group#, a.thread#, a.sequence#, a.archived, a.status, b.member as relog_file_name, a.bytes/1024/1024 as size_mb from v$log a inner join v$logfile b on a.group#=b.group# order by a.group# asc; - 파일사이즈 조정 alter system checkpoint; alter dat..