Sunday, February 7, 2016

REDO LOG SIZES FOR ORACLE ENTERPRISE MANAGER CLOUD CONTROL 13C




REDO LOG SIZES FOR ORACLE ENTERPRISE MANAGER CLOUD CONTROL 13C


There are two types of installations

1.     Simple Installation
2.     Advanced Installation


When we select Advanced Installation, we have an option to choose whether our installation can be small or medium  or large size  installation types

we can check the size of redo log files using


select min(bytes)/(1024*1024) size_in_mb from v$log;

the oracle recommended sizes for the redo logs is as follows

For simple installation, the redo log files size should be 300 MB or greater

 300 MB size for each log file member  for small
 600 MB size or greater for Medium
 1000 MB size or greater for Large 

No comments:

Post a Comment