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 Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution
Latest Answer : HiShared SQL areas are shared memory areas; any Oracle process can use a shared SQL area. The use of shared SQL areas reduces memory usage on the database server, thereby increasing system throughput. Shared SQL areas are aged out of the shared ...
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. ...
