19c, Oracle

Changes in Oracle 19c standard edition

Oracle has made some huge changes to the standard edition of 19c version.
The changes made are big and we can believe that Oracle is trying to push standard edition users towards enterprise edition.
Let’s take a look at some of the changes in the standard edition 19c onward:

Continue reading “Changes in Oracle 19c standard edition”
Database-Course, Oracle

Oracle 19c Architectural components Part 3

Oracle Background Processes

Background processes are part of the database instance and perform maintenance tasks required to operate the database and to maximize performance for multiple users. Each background process performs a unique task, but works with the other processes. Oracle Database creates background processes automatically when you start a database instance. The background processes that are present depend on the features that are being used in the database. When you start a database instance, mandatory background processes automatically start. You can start optional background processes later as required.

Mandatory background processes are present in all typical database configurations. These processes run by default in a read/write database instance started with a minimally configured initialization parameter file. A read-only database instance disables some of these processes. Mandatory background processes include the
Process Monitor Process (PMON), Process Manager Process (PMAN), Listener Registration Process (LREG), System Monitor Process (SMON), Database Writer Process (DBWn), Checkpoint Process (CKPT), Manageability Monitor Process (MMON), Manageability Monitor Lite Process (MMNL), Recoverer Process (RECO), and Log Writer Process (LGWR).

Continue reading “Oracle 19c Architectural components Part 3”