Creative Oracle 12c Redo Maneuvers

• Speed means sometimes breaking the rules •

Download Now

Oracle database performance can be hindered by the flow of redo. In Oracle 12c and prior releases there are a number of creative maneuvers Oracle DBAs can implement that increase the redo flow, reducing log file sync and log file parallel write wait times. This presentation explores such maneuvers, as well as redo process and memory architecture. Conclusions are reached and explained through experimental research (which is presented) and operating system tracing of Oracle processes.

Search Craig's blog for relevant posts, here.

Presentation Outline:

  • Redo memory architecture
  • Fundamental system comparison/profiling
  • What is the log file sync wait event?
  • Using multiple Oracle 12c log writers
  • Using the commit write facility
  • Changing process OS priority through Oracle

Related Videos