what will happen when
alter system switch logfile;
and alter system checkpoint;
Who is Participating?
slightwv (䄆 Netminder) Commented:
Switch logfile: oracle switches to the next redolog

Checkpoint: the specifics are in the docs but from memory and high level:  oracle flushes dirty blocks to disk and datafiles sync their headers.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.