Hi,
I read that we have in 12c the option to configure multiple log writer processes as e.g. from this link https://blogs.oracle.com/UPGRADE/entry/log_writer_slave_issues_in.
++++
You will see multiple LGnn (Log Writer Worker) processes on multiprocessor systems, The LGWR (Log Writer) creates worker processes (slaves) to improve the performance of writing to the redo log. LGnn (Log Writer Worker) processes are not used when there is a SYNC standby destination. Possible processes include LG00-LG99.
++++
Does it mean that avg wait time(ms). for "log file parallel write" and "log file sync" wait event can be reduced in 12c compared to 11g.
For e.g. say if in 11g i see average wait time for "log file parallel write" as 4ms(as given below) can it be reduced with implementation of worker process in 12c.
note: I am talking about a regular single instance single DB not the container DB /pluggable DB feature added in 12c.
I am asking this question just for my academic interest
Regds,
Kunwar