Program Global Area (PGA) is a memory buffer that contains data and control information for a server process.
Latest Answer : A programme global area is a memory buffer that contains data and consitute the Oracle Database and Instance.Ex: A client server process uses its Pga to hold the state of the session programme variables and packages. ...
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
Server Process handle requests from connected user process. A server process is in charge of communicating with the user process and interacting with ORACLE carry
Dedicated Server Configuration and Multi-threaded Server Configuration.
In a Dedicated Server Configuration a Server Process handles requests for a Single User Process.
In a Multi-threaded Server Configuration many user processes share a group of server process.
A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server.
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. ...
System Monitor (SMON) performs instance recovery at instance start-up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance can also perform
Latest Answer : If server unplanned shutdown, Power failiure SMON Instant recovery. there is two type of Instant recovery 1st is Roll forward 2nd Roll back.Rollback means comitted transaction.Rollforward means uncommitted transaction. ...
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