Oracle Database Architecture Components

Показать описание

Oracle Database Architecture. An #Oracle #database is a collection of #data treated as a unit. The purpose of a database is to store and retrieve related information. A database #server is the key to solving the problems of information management.
In this video, you will learn about the ORACLE DATABASE Architecture components such as Log Writer, DB Writer, etc (Background Processes), #SGA, Buffer Cache, Shared Pool, etc (Memory Layout – Memory Buffer), #Datafiles, #Controlfiles, etc (Physical Oracle Layout).
All these components, running together play an important part in the Oracle Architecture.

00:00 Oracle 11g Architecture
02:04 User Process
02:21 Server Process
02:57 Private Global Area (PGA)
04:46 PGA_AGGREGATE_TARGET
04:35 Before 9i, PGA configure
05:51 PGA Sorting
06:49 What is Oracle Instance
07:16 Shared Global Area (SGA)
08:29 Shared Pool
09:26 Database Buffer Cache
09:59 Status of Block in DBC
10:39 Log Buffer Cache
10:58 Large Pool