월별 데이터파일 증가량 확인하기
set pagesize 50000 tti “Database growth per month for last year” select to_char(creation_time, ‘RRRR Month’) “Month”, sum(bytes)/1024/1024 “Growth in Meg” from sys.v_$datafile where creation_time >…
DB Admin Knowhow
set pagesize 50000 tti “Database growth per month for last year” select to_char(creation_time, ‘RRRR Month’) “Month”, sum(bytes)/1024/1024 “Growth in Meg” from sys.v_$datafile where creation_time >…