Re: locks DB 19c

Posted by ErmanArslansOracleBlog on May 12, 2023; 3:46pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/locks-DB-19c-tp11870p11872.html

No. You already have redologs which are unused.
You have to concantrate on the log file sync wait.

Also cancel these kinds of things : dbms_stats.gather_database_stats_job_proc (), take them to non-business hours.

Try to decrease the utilization of CPU and I/O Subsystem in general.. Log File sync will be increased by the increase of CPU and I/O utilization.. Frequent and concurrent commit can also increase it.. Check your env with these in mind.