How to force a log switch?

Options
- By using ALTER SYSTEM LOG
- By using ALTER SYSTEM SWITCH LOGFILE
- By using ALTER SYSTEM SWITCH LOGS
- By using ALTER SYS LOGFILES

CORRECT ANSWER : By using ALTER SYSTEM SWITCH LOGFILE

Discussion Board
Log switch

A log switch occurs when LGWR stops writing to one redo log group and starts writing to another. By default, a log switch occurs automatically when the current redo log file group fills. This option is useful in configurations with large redo log files that take a long time to fill. To force a log switch, you must have the ALTER SYSTEM privilege. Use the ALTER SYSTEM statement with the SWITCH LOGFILE clause.
The following statement forces a log switch: ALTER SYSTEM SWITCH LOGFILE;

Prajakta Pandit 02-9-2017 12:22 AM

Write your comments


Enter the code shown above:

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


Related Content

Advertisement
 
▲