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.