Thanks for the question, Monika.
Asked: July 12, 2016 - 11:14 am UTC
Last updated: July 13, 2016 - 1:23 am UTC
Version: 12.1.0.2.0
Viewed 1000+ times
You Asked
Is it possible to archive contents of log buffer directly to archive logs,instead of writing into redo logs. Will this decrease the load in system I/O.
Please explain the reason if it is not possible.
and Connor said...
"Is it possible to archive contents of log buffer directly..."
No it is not.
"Will this decrease the load in system I/O"
No it would not.
Both redo log writing and archive log writing are predominantly sequential write activity, which even for older disk systems is one of the most efficient things they can do.
If we wrote directly to archives, then the log writer (which is critical for commit performance) would then be responsible for file *creation*, and allocating space to files as they grow...which would probably slow your database down.
Is this answer out of date? If it is, please let us know via a Comment