SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
Latest Answer : A system Global Area and Oracle Background Processes together consitute an Instance. ...
A user process is created and maintained to execute the software code of an application program. It is a shadow process created automatically to facilitate communication
In a Multi-threaded Server Configuration many user processes share a group of server process.
DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process MonitorARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server.
Latest Answer : Mandatory Processes DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process Monitor Optional Process ARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server. ...
Process Monitor (PMON) performs process recovery when a user process fails PMON is responsible for cleaning up the cache and Freeing resources that the process was using
Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the
Atleast one Dispatcher process is created for every communication protocol in use.
Though a single LCK process is sufficient for most Parallel Server systemsupto Ten Locks (LCK0,....LCK9) are used for inter-instance locking.