Skip to main content

Background Processes - Oracle Architecture

SMON - System Monitor 

Performs recovery after instance failure, monitor temporary segments and extents clean those temporary extents and segments. 

PMON - Process Monitor

Failed process resources in shared server architecture monitor and restart any failed dispatcher or server process. 

DBWn - Database Writer

Database Writer process writes new or changed data blocks into the data-files which are in the buffer cache. 

LGWR - Log Writer

Log writer is in change of REDO Log buffer management log writer is one of most active processes until log writer success data commit will not be completed.

ARCn - Archive Process


Copies REDO Logs to one or more destinations.

CKPT - Checkpoint Process

This helps to reduce the amount of time required for instance recovery. During checkpoint updates the header of the control file and data-files to reflect the last successful System Changed Number (SCN) This automatically starts every time the redo log switch occurs. 

RECO - Recover Process

This handles the failures of distributed transactions.

 

Comments

Popular posts from this blog

Behavior Driven Development

Behavior Driven Development (BDD) is a development process that originally associated with Test-Driven Development (TDD).  BDD is written in a readable format in an understandable language for anyone involved in software development.  BDD Features Providing better readability and visibility.  Verifying the software against customer requirements.  Assure the implementation of the system is correct. Derives examples of different expected behaviors of the system. Uses examples as acceptance tests. Focus on customer requirements throughout the development. BDD Practice There are two practices in BDD:-  Specification by Example (SbE). Test-Driven Development (TDD). Specification by example (SbE) uses examples in conversation to illustrate the business rules and the behavior of the software.  This uses to have a better understanding for Business Analyst, Product Owners, Testers and the Developers to reduce the misunderstanding abou...