![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions 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. ... 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. ... 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 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. ... 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. ... RECOver (RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals,the local Lock (LCKn) are used for inter-instance locking when the ORACLE Parallel Server option is used. Latest Answer : The Oracle call interface (OCI) The Oracle call interface is the lowest level at which client programs are intended to interact with Oracle. This interface is well documented and provides access to most of the functionality of Oracle, including ... Latest Answer : sga stands fro system global area.. which is the part of the oracle instance(includes memory struture and background processes). for faster executon and better performance everthing comes in the sga.so sga is located in oracle instance,,, which itself ... Read Answers (1) | Asked by : madhu
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||