Database Management Systems

This background process is used to resolve distributed transactions that are pending due to a network failure or system failure in a distributed database.

These are the logical structures that directly refer to the database's data.

This memory component of the SGA contains 'dirty' or modified blocks and clean or unused blocks.

Data files can have certain characteristic set to let them automatically extend when the database runs out of space.

This memory component is a circular buffer that contains redo entries,  which reflect changes made to the database.

This background process is designed to perform batched writes with high efficiency.

This memory component of the PGA is used for operations such as bitmap merge, bitmap create operations, etc.

This background process cleans up temporary segments that are no longer in use.

This memory component of the SGA provides large memory allocations for oracle backup and restore operations, I/O processes, etc.

The entries such as tablespace names, checkpoint information, as and when checkpoints are made, etc., are maintained in the control file.

In a shared server environment, private SQL area is located in the system global area.

This type of service of application layer of OSI provides distributed database sources and access for global information about various objects and services.

This file in oracle is very useful in the event of a failure and is used for recovery purposes.

These files are used in oracle in the event of an instance failure.

This mode of shutdown in oracle allows oracle server to automatically rolls back all currently active transactions.