Answer:
Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into the redo log files, they will first brought to redo log buffers in SGA and LGWR will write into files frequently.
LOG_BUFFER parameter will decide the size.
LOG_BUFFER parameter will decide the size.
| Previous Question | Next Question |
| How will you swap objects into a different table space for an existing database? | What is meant by recursive hints? |