Re: DB performance

Posted by Roshan on Mar 08, 2023; 3:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DB-performance-tp11685p11708.html

Hi,

I checked with support because disk was already on SSD. I was told to set _use_single_log_writer to true. I saw an improvement in logminer wait on DB.

Please restrict the log writer to single worker process:
ALTER SYSTEM SET "_use_single_log_writer"=TRUE SCOPE=SPFILE;