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”
19c, Database-Course

Oracle 19c Features.

Oracle Database 19c, is the long term support release of the Oracle Database 12c and 18c family of products, offering customers Premier and Extended Support through to March 2023 and March 2026 respectively. It is available on Linux, Windows, Solaris, HP/UX and AIX platforms as well as the Oracle Cloud. Oracle Database 19c offers customers the best performance, scalability, reliability and security for all their operational and analytical workloads.

Installation and Upgrades

  • RPM Based Installation  install Oracle 19c Database using RPM method
  • Simplified Image based installation of client as well
  • Auto Upgrade Utility for Oracle Database
  • Docker Container for Oracle 19c
  • DryRun mode for GridSetup in clusterware Installation
Continue reading “Oracle 19c Features.”