Why enable MAINTENANCE mode ??


To ensure optimal performance and reduce downtime during patching sessions, Auto-Patch requires that you enable Maintenance mode when you apply a patch. Enabling this feature shuts down the Workflow Business Events System and sets up function security so that Oracle Applications functions are unavailable to users. This provides a clear separation between normal run time operation and system downtime for patching.



               OR


Enabling Maintenance  mode will do these things briefly:-

1) As source code is modifying due to the patch, triggers,workflows events will be disabled.
2) No Users will be able to connect, as which will cause the problems.
 

No comments:

How to add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...