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. ...
Database writer writes modified blocks from the database buffer cache to the data files.
DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data
Latest Answer: DBWn writes when:1)checkpoint occurs2)dirty buffers reach threshold3)there are no free buffers4)timeout occurs5)RAC ping request is made6)when any tablespace is taken offline,read only,drop or truncated & when begin backup ...
Log Writer (LGWR) writes redo log entries generated in the redo log buffer of the SGA to on-line Redo Log File.
Latest Answer: LGWR is oracle background process.. all changes which have been made inthe database gets recorded in the redolog buffer.. so when the users fires an commit statement , LGWR writes these changes it into thr redolog files. and also writes it into ...
LGWR writes redo log entries into an on-line redo log file when transactions commit and the log buffer files are full.
Latest Answer: The LGWR writes redo log entries into an on-line redo log file when 1. transaction is committed.2. More than 1 MB of redo log buffer enteries.3. 1/3 of the redo log ...
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
Archiver (ARCH) copies the on-line redo log files to archival storage when they are full. ARCH is active only when a database's redo log is used in ARCHIVELOG mode.
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
Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the
View page << Previous 1 2 [3] 4 Next >>
Go Top
