Database word in the phrase "the Oracle database architecture" should be a Database Management System (DBMS). For simplicity mention, Database Management System database is often simply called it.
Generally Oracle DBMS components consist of memory, processes, and files. Furthermore, these components are grouped as follows:
1. Instance
Memory is referred to as the System Global Area (SGA), consisting of: Shared Pool (Libary Cache Cache and Data Dictionary), Database Buffer Cache, Redolog Buffer Cache, Java Pool, Large Pool.
- Back ground process: PMON, SMON, DBWR, LGWR, CKPT, etc.
- Back ground process: PMON, SMON, DBWR, LGWR, CKPT, etc.
2. Database
- Datafile
- ControlFile
- Redo Log File
3. Other component
- Process : Server process, user process.
- Memory : Program Global Area (PGA) .
- File : Archived log, parameter and file password.
reference : rohmad.net
Tidak ada komentar:
Posting Komentar