OPTIMAL_LOGFILE_SIZE
Hi,
on 11.2.0.4 on Unix
I have 10Gb proposed by advisor for log file size :
select optimal_logfile_size from v$instance_recovery
OPTIMAL_LOGFILE_SIZE |
---------------------------------------
10215 |
Is it a reasonable value ?
Am-I wrong somewhere ?
select group#,bytes from v$log;
GROUP# | BYTES |
--------------------------------------- ---------------------------------------
1 | 943718400 | |
2 | 943718400 | |
3 | 943718400 | |
4 | 943718400 | |
9 | 943718400 | |
10 | 943718400 |
Thank you.