Log switch is where database starts writing one redo log file & begins writing to another

Q.  A log switch is the point at which the database starts writing to one redo log file and begins writing to another.
- Published on 27 Jul 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - A log switch is the point at which the database stops writing to one redo log file and begins writing to another.

    - Normally, a log switch occurs when the current redo log file is completely filled and writing must continue to the next redo log file.

    - However, you can configure log switches to occur at regular intervals, regardless of whether the current redo log file is completely filled.

    - You can also force log switches manually.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)