Analysis of information sources in references of the Wikipedia article "Pangkalan data Oracle" in Malay language version.
The worker process is named <instance>_DWnn_<pid>. It is the process that actually performs the heavy-duty work of loading and unloading data. The master process (DMnn) creates the worker process.
The job queue is handled by the job queue coordinator process CJQ0 and job queue slave processes (JNNN).Cite has empty unknown parameter:
|chapterurl= (bantuan)The optional net_timeout parameter to the log_archive_dest_n parameter allows the DB As to specify the number of seconds the log writer process (LGWR) waits for a response from the logwriter network server (LNS) before terminating the process.
Pnnn: Parallel Query Execution Servers [...] Oracle 7.1.6 introduced the parallel query capability into the database. [...] When using parallel query, you see processes named Pnnn. These are the parallel query execution servers themselves.
In Oracle 10.1, a queue monitor coordinator (QMNC) process [...] dynamically spawns queue monitor slaves (q000 to q009).
Redo data transmitted from the primary database is received by the remote file server (RFS) process on the standby system, where the RFS process writes the redo data to archived log files or standby redo log files.
New Oracle Background Processes [...] SMCO: the space management coordinator process is in charge of coordinating the work of space management-related tasks such as space reclamation, for example.
[...] Oracle assigns a unique session ID into the v$session table for each individual user logged on to Oracle.
The SID automatically defaults to the database name portion of the global database name (sales in the example sales.us.example.com) until you reach eight characters or enter a period. You can accept or change the default value.
When a user runs an application program (such as a Pro*C program) or an Oracle tool (such as Enterprise Manager or SQL*Plus), Oracle creates a user process to run the user's application.
A connection is a communication pathway between a user process and an Oracle instance.
A session is a specific connection of a user to an Oracle instance through a user process
V$SESSION displays session information for each current session. [...] SID [...] Session identifier
You can use tablespaces to achieve the following goals: [...] Assign a quota (space allowance or limit) to a database user [...]Unknown parameter
|deadurl= ignored (bantuan)NSVn[:] Data Guard Broker NetSlave Process[:] Performs broker network communications between databases in a Data Guard environment
Process Spawner Process [...] Spawns Oracle background processes after initial instance startupUnknown parameter
|deadurl= ignored (bantuan)Performs monitoring management tasks related to Data Guard on behalf of DMON
SPID VARCHAR2(12) Operating system process identifierInvalid
|script-title=: missing prefix (bantuan)MMON Memory Monitor process is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis.Cite has empty unknown parameters:
|nopp=, |lastauthoramp=, |laydate=, |chapterurl=, |laysummary=, dan |separator= (bantuan)M000 These are MMON background slave (m000) processes.Cite has empty unknown parameters:
|nopp= dan |chapterurl= (bantuan)You can use tablespaces to achieve the following goals: [...] Assign a quota (space allowance or limit) to a database user [...]Unknown parameter
|deadurl= ignored (bantuan)Process Spawner Process [...] Spawns Oracle background processes after initial instance startupUnknown parameter
|deadurl= ignored (bantuan)You can use tablespaces to achieve the following goals: [...] Assign a quota (space allowance or limit) to a database user [...]Unknown parameter
|deadurl= ignored (bantuan)The job queue is handled by the job queue coordinator process CJQ0 and job queue slave processes (JNNN).Cite has empty unknown parameter:
|chapterurl= (bantuan)MMON Memory Monitor process is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis.Cite has empty unknown parameters:
|nopp=, |lastauthoramp=, |laydate=, |chapterurl=, |laysummary=, dan |separator= (bantuan)M000 These are MMON background slave (m000) processes.Cite has empty unknown parameters:
|nopp= dan |chapterurl= (bantuan)Process Spawner Process [...] Spawns Oracle background processes after initial instance startupUnknown parameter
|deadurl= ignored (bantuan)SPID VARCHAR2(12) Operating system process identifierInvalid
|script-title=: missing prefix (bantuan)