After a LAN, telephone line, or broadband connection is used to establish a connection between the client and the database server, or a distributed connection is established between multiple database servers, if the network fails, the normal operation of the database system will be interrupted.
When a network failure occurs, the Oracle server can automatically process the failure without DBA intervention.
Example:
- For the C/S system, the background process pmon (Process Monitor) can automatically detect user processes with abnormal disconnections, and then automatically roll back user unfinished transactions, and release the server resources and locks it occupies.
- For two-phase distributed transactions, after the network fails to be resolved, the background process reco automatically resolves distributed transactions on all nodes of the distributed database system.
