There can be as many NSVn processes (where n is 0- 9 and A-U) created as there are databases in the Data Guard broker configuration. please give your expert advice on this when time permits.. Performs Oracle ASM disk scrubbing check operation. FMON is started by the database whenever the FILE_MAPPING initialization parameter is set to true. DIAG performs diagnostic dumps requested by other processes and dumps triggered by process or instance termination. Manages mapping information for the Oracle Database file mapping interface. Also, the processes help perform two-phase commit for global transactions anywhere in the cluster so that an Oracle RAC database behaves as a single system to the externally coordinated distributed transactions. NSVn is created when a Data Guard broker configuration is enabled. Database instances, XStream Outbound Server, Oracle Streams, Sets resource plans and performs other tasks related to the Database Resource Manager. If the process is specific to a particular feature, then the column names the feature. Database instances, Logical Standby, Oracle Streams, XStream Outbound servers, Oracle GoldenGate, Monitors idle connections and hands off active connections in Database Resident Connection Pooling, Transfers redo from current online redo logs to remote standby destinations configured for SYNC transport. In addition, PMON monitors, spawns, and stops the following as needed: Pooled server processes for database resident connection pooling, See Also: Oracle Database Concepts and Oracle Database Net Services Administrator's Guide, Perform parallel execution of a SQL statement (query, DML, or DDL). Maintains a connection to the Oracle ASM instance for metadata operations, Serves file system requests submitted to an Oracle instance. Initiates automation tasks involved in managing Exadata storage. See Also: Oracle Database The dictionary is necessary for logical standby databases to interpret the redo of the new primary database. When you run the page and click the button, the result should look as follows. In 19c, the background processes are grouped into three categories: mandatory, optional and slave background processes. FMON is started by the database whenever the FILE_MAPPING initialization parameter is set to true. For examples, LCKn manages library and row cache requests. Provides database service run-time load balancing and topology information to clients. PO is approved as if using online mode Issue can be seen in the following excerpt from the wfstat.sql script output : Captures database changes from the redo log by using the infrastructure of LogMiner. Performs database event management and notifications. One process will start for each NUMA node on target machines. The names of the 37th through 100th Database Writer Processes are BW36-BW99. LDDn - Global Enqueue Service Daemon Helper Slave Helps the LMDn processes with various tasks. Initiates background population and repopulation of in-memory enabled objects. Each server class process acts on behalf of an AQ master class process. . SCVn acts as a slave process for SCRB and performs the verifying operations. In the shared server architecture, clients connect to a dispatcher process, which creates a virtual circuit for each connection. Extracts and masks bind values from workloads like SQL tuning sets and DB Replay capture files. As a result, this process can exhibit a variety of behaviors. In RAC, the various ARCH processes can be utilized to ensure that copies of the archived redo logs for each instance are available to the other instances in the RAC setup should they be . I/O slave process can be configured on platforms where asynchronous I/O support is not available. Query V$PROPAGATION_SENDER for information about a propagation sender. Starting with Oracle Database 19c, IMXT (In-Memory External Table) segments are dropped by the IMCO background process. The background processes perform maintenance tasks required to operate the database and to maximize performance for multiple users. These processes help maintain the global information about XA global transactions throughout the cluster. Wnnn processes execute in-memory populate and in-memory repopulate tasks for population or repopulation of in-memory enabled objects. If required, MARK can also be started on demand when disks go offline in the Oracle ASM redundancy disk group. The capture process name is CPnn, where nn can include letters and numbers. AQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. Each of this type of process represents a single class of work item such as AQ notification, queue monitors, and cross process. Performs cleanup of dead processes, killed sessions, killed transactions, and killed network connections. ASMB also runs with Oracle Cluster Registry on Oracle ASM. Processes a set of workload capture files. 3.Checkpoint Process. GCRn processes are transient slaves that are started and stopped as required by LMHB to perform synchronous or resource intensive tasks. These membership changes are required for the file system to maintain file system consistency within the cluster. Up to five process (B000 to B004) can exist depending on the load. VKTM acts as a time publisher for an Oracle instance. Spawns Oracle background processes after initial instance startup. Monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally. Several initialization parameters relate to shared servers. Background processes consolidate functions that would otherwise be handled by multiple database programs running for each user process. 6.Archiver Process. LDDn processes are slave processes spawned on demand by LMDn processes. In this context, a background process is defined as any process that is listed in V$PROCESS and has a non-null value in the PNAME column. GCRn processes are transient slaves that are started and stopped as required by LMHB to perform synchronous or resource intensive tasks. DMON maintains profiles about all database objects in the broker configuration in a binary configuration file. When the THREADED_EXECUTION initialization parameter is set to TRUE on Linux and UNIX, the DBW, PMON, PSP, and VKTM background processes run as operating system processes, and the other background processes run as operating system threads. Thanks Sheik DECLARE l_sql long; l_job number; l_return Varchar2 (32767) ; l_messages dbms_output.chararr; l_numlines integer := 1000000; Begin Check Oracle process. SMCO dynamically spawns slave processes (Wnnn) to implement these tasks. The IMCO background process initiates population (prepopulation) of in-memory enabled objects with priority LOW/MEDIUM/HIGH/CRITICAL. The background process usually is a child process created by a control process for processing a computing task. Performs Oracle ASM post-rebalance activities. MRP0 is spawned at the start of redo apply on a physical standby database. The LSP2 process is created as needed during startup of SQL Apply to update the list of objects that are protected by the database guard. In-memory enabled objects with priority NONE will not be prepopulated but will be populated on demand via Wnnn processes when queried. PRnn serves as a slave process for the coordinator process performing parallel media recovery and carries out tasks assigned by the coordinator. Such requests are passed on to the slave so that the LMS is not stalled. There can be up to 36 of these slave processes (LDD0-LDDz). When a connection becomes active, the connection broker hands off the connection to a compatible pooled server process. Multiple MSnn processes can exists, where n is 0-9 or a-Z. The RMON process is spawned on demand to run the protocol for transitioning an ASM cluster in and out of rolling migration mode. When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. CJQ0 starts only as many job queue processes as required by the number of jobs to run and available resources. The names for CRnn processes will have the format CR0n_