SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
Latest Answer : Oracle Instance is an combination of background process and memory structures. ...
The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
Latest Answer : System Global Area (SGA) is component of instance which consist shared memory & control information of the instance It consist of shared pool, database buffer cached, redo log buffer, large pool, Java pool. ...
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. ...