Categories of oracle processes

Explain the categories of oracle processes i.e. user, data writing processes, logging processes and monitoring processes.

User process - User process is used in invocation of application software.

Data writing process - A database writer process is used to write buffer content into a datafile. They are specifically used to write “dirty block” to data files from the buffer.

Logging processes - Log writer is used to write the redo log buffer from system global area to online redo log file. Only those redo entries are written hat have been copied into the buffer since the last time it wrote.

Monitoring process - this can be either a system monitor process or a process monitor process. System monitor process is mainly used for crash recovery and cleaning up of temporary segments. Process monitor is used to clean all resources acquired by a failed process
What are the Back ground processes in Oracle?
There are a number of background processes running. Each process is used for a specific job....
Guidelines for estimating the space needed for a database
Estimating the space needed for a database is essential to figure out the performance of the application and size of database....
What are background processes in oracle?
What are background processes in oracle? - Oracle uses background process to increase performance....
Post your comment