Supplemental Logging and Securefiles Causing DBWn to Block This is an off-site link.  Please review our Terms of Service for additional information.

(Don Seiler) A few weeks back, we began making changes to prepare for using Oracle Golden Gate. One of the first steps required is to enable "minimal supplemental logging" at the database level. We did this during an evening maintenance window. However by the time the morning workload picked up, we started seeing a lot of sessions blocking, and the root blocker was one of the DB Writer (DBWn) processes.

Read this article...

comments powered by Disqus