19c, Database-Course

Oracle 19c Architectural components Part 2

System Global Area

Oracle 19c SGA

The System Global Area (SGA) is the memory area that contains data and control information for one Oracle Database instance. All server and background processes share the SGA. When you start a database instance, the amount of memory allocated for the SGA is displayed. The SGA includes the following data structures:

Continue reading “Oracle 19c Architectural components Part 2”
19c, Database-Course

Oracle 19c Architectural components Part 1

An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical files called data files, and can be a non-container database or a multitenant container database. An Oracle Database also uses several database system files during its operation.

Oracle 19c architecture oviewview
Continue reading “Oracle 19c Architectural components Part 1”