 Related Questions 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. ... 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 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. Tags : 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. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
