오라클
controlfile 크기 확인
pat98
2018. 8. 3. 10:45
Dictionary view 를 통해서 controlfile 의 크기를 확인.
sys@ORA12> select name, block_size, file_size_blks, (block_size*file_size_blks) + block_size as "SIZE" from v$controlfile;
NAME BLOCK_SIZE FILE_SIZE_BLKS SIZE
------------------------------------------------------------ ---------- -------------- ----------
/oradata/ORA12/control01.ctl 16384 646 10600448
/oradata/ORA12/control02.ctl 16384 646 10600448