arcn

PMON, RECO, and ARCn PMON: processmonitor process Monitoring of oracle 10g processes performs data recovery when the user process is interrupted (abnormal. PMON is responsible for clearing the data buffer pool and releasing resources used by user

TOM's oracle programming art 9i, 10g, 11g   PMON PMON, process monitoring. PMON has three main purposes: 1. Perform cleanup after the process is interrupted abnormally. For example, if the dedicated server fails or is killed for some reason, PMON

TOM 's "Oracle Programming Art 9i,10g,11g" Pmon Pmon , process monitoring. Pmon has 3 main uses:      1 to do cleanup after a non-normal interruption of the process. For example: dedicated server failed or was killed for some reason, this is

8.1 what is an archive log fileOracle databases allow you to store full redo log files to offline directories, which are called archive log files.Archive the process of saving the redo log file to the archive log file. This process can only run in

Background ProcessIn order to provide services to multiple users and ensure system performance, there are multiple Oracle processes called background processes (background process) in a multi-process Oracle System (multiprocess Oracle Systems).  an

Tuning log switching (tuning log switches) Log switching: The LGWR process stops writing logs to the current log file, closes the log file, opens a new log file, and writes the data from the log cache to the new log file. Log switching can

Oracle instances mainly have three types of processes (in Windows, they are actually threads ):· Server process: these processes are completed based on customer requests. Server processes include dedicated servers and shared servers:

MySQL replication and Oracle logical standby are both SQL apply. What is the difference in implementation?Binary log and redo transmission principlesMySQL replication can be easily used for application read expansion, and can also help MySQL

Reference documents: 415938111. Oracle Series Products1.1 The server is divided into database server, application server and Enterprise Manager. Where Enterprise Manager includes database control application server control and Grid control.1.2

RAC is designed to solve single point of failure (spof) and load balancing. However, only one copy of data exists in the RAC solution. The data itself is not redundant and is easy to form a single point of failure (spof ). Data Guard provides data