Oracle's Architecture Learning

Instance:

is the database service: It can be understood as a service:

Multiple processes + memory structure

Database:

Instance + file

RAC: DB cluster

　　Multiple instances + files (shared)---at the moment Io is not resolved

Memory structure:

Some cache pools, each of which is used by different programs, so you can understand that different functions are placed in different caches

Process structure:

Oracle This software, there are multiple processes work, coordination between processes, complete functions, different processes have different functions (software development such as garbage collection process, the project's own implementation of the user management process, etc.)

Smon:undo,temp, table Space Reclamation

LGWR: A service that writes a buffer inside a memory structure to a file

CKPT: Trigger mechanism write process, dirty data written to database file

Pmon: Resource cleanup process

Attention:

The resource that the process structure targets is the memory structure

　　　

　　　　　

　　

Oracle's Architecture Learning