SELECT
TO_CHAR(NEXT_TIME,'YY/MM/DD(DY) HH24') "NEXT_TIME"
, COUNT(DISTINCT NAME) "TOTAL_ARC_COUNT"
, ROUND(SUM(DISTINCT BLOCKS*BLOCK_SIZE)/1024/1024/1024,2) "TOTAL_SIZE_GB"
, SUM(CASE WHEN INST_ID = 1 AND THREAD# = 1 THEN 1 ELSE 0 END) "RAC1"
, SUM(CASE WHEN INST_ID = 2 AND THREAD# = 2 THEN 1 ELSE 0 END) "RAC2"
, SUM(CASE WHEN INST_ID = 3 AND THREAD# = 3 THEN 1 ELSE 0 END) "RAC3"
, SUM(CASE WHEN INST_ID = 4 AND THREAD# = 4 THEN 1 ELSE 0 END) "RAC4"
FROM GV$ARCHIVED_LOG
WHERE NEXT_TIME >= TRUNC(SYSDATE) -10
GROUP BY TO_CHAR(NEXT_TIME,'YY/MM/DD(DY) HH24')
ORDER BY 1;
select *
from GV$ARCHIVED_LOG;
select * from v$recovery_file_dest;
select * from V$ARCHIVED_LOG;
select * from v$archive;
select * from v$log;
select * from v$archive_dest;
select * from v$archive_processes;
select dest_name, name, sequence#, b.status
from v$archive_dest a, v$archived_log b
where a.dest_id = b.dest_id;
'DataBase > Oracle 11g - 12c' 카테고리의 다른 글
오라클 계정 비밀번호 찾기 (0) | 2020.09.18 |
---|---|
오라클 오브젝트 컴파일 쿼리 (0) | 2020.06.24 |
오라클 락 조회, 킬 (0) | 2020.06.24 |
오라클 계정의 비밀번호 만료일 변경 (0) | 2020.06.24 |
오라클 STARTUP, SHUTDOWN (0) | 2020.06.24 |