양쪽 이전 판
이전 판
다음 판
|
이전 판
|
dbms:oracle:concept:oraclestruct [2007/02/01 18:08] starlits |
dbms:oracle:concept:oraclestruct [2009/08/31 09:20] starlits |
====== 오라클 구조와 구성요소 ====== | ====== 오라클 구조와 구성요소 ====== |
| |
| |
| |
| |
| |
| ===== 개념 ===== |
| |
| ^ User Process | 사용자가 오라클 데이타베이스 접근을 하기 위해 사용하는 프로그램 | |
| ^ Server Process | 서버 프로세스가 PGA를 이용하여 데이타베이스에 접근한다 | |
| ^ Instance | 오라클 데이타베이스의 Memory 영역 (SGA + Backgroup Process) | |
| ^ Database Files | 오라클 데이타베이스의 물리적인 데이타파일 영역 | |
| |
| {{dbms:oracle:concept:oracleinstancemanagement.jpg?400x300|}} {{dbms:oracle:concept:oraclememorystructures.jpg?400x300|}} |
| |
| |
===== User Process ===== | ===== User Process ===== |
| |
===== Server Process ===== | ===== Server Process ===== |
==== PGA ==== | |
| - PGA(Program Global Areas) |
| - Dedicated Server Process |
| - Shared Server Process |
| |
| |
===== INSTANCE ===== | ===== INSTANCE ===== |
==== SGA(Memory) ==== | |
- Shared Pool | === An ORACLE INSTANCE === |
- Database Buffer Cache | |
- Redo Log Buffer | {{dbms:oracle:concept:oralce_instance.gif|}} |
- Streams Pool | |
- Java Pool | |
- Large Pool | |
| |
| |
| |
| ==== SGA ==== |
| |
| ^ **[[dbms:oracle:concept:sga#shared_pool | Shared Pool]]** | |
| ^ **[[dbms:oracle:concept:sga#database_buffer_cache |Database Buffer Cache]]** | |
| ^ **[[dbms:oracle:concept:sga#redo_log_buffer | Redo Log Buffer ]]** | |
| ^ [[dbms:oracle:concept:sga#large_pool | Large Pool ]] | |
| ^ [[dbms:oracle:concept:sga#java_pool | Java Pool ]] | |
| ^ [[dbms:oracle:concept:sga#streams_pool | Streams Pool ]] | |
| |
| |
| |
==== Background Process ==== | ==== Background Process ==== |
- SMON (System Monitor) | |
- PMON (Process Monitor) | ^ [[dbms:oracle:concept:oracleprocesses#dbwn|DBWn]] | Database Writer Process | |
- DBWn (Database Writer) | ^ [[dbms:oracle:concept:oracleprocesses#lgwr|LGWR]] | Log Writer Process | |
- LGWR (Log Writer) | ^ [[dbms:oracle:concept:oracleprocesses#ckpt|CKPT]] | Checkpoint Process | |
- CKPT (Check Point) | ^ [[dbms:oracle:concept:oracleprocesses#smon|SMON]] | System Monitor Process | |
- ARCn (Archive Log) | ^ [[dbms:oracle:concept:oracleprocesses#pmon|PMON]] | Process Monitor Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#reco|RECO]] | Recoverer Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#jnnn|Jnnn]] | Job Queue Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#cjqn|CJQn]] | Coordinator Job Queue Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#arcn|ARCn]] | Archiver Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#dnnn|Dnnn]] | Dispatcher Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#qmnn|QMNn]] | Queue Monitor Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#mman|MMAN]] | Memory Manager Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#rvwr|RVWR]] | Recovery Writer Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#ctwr|CTWR]] | Change Tracking Writer Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#mmnl|MMNL]] | Memory Monitor Light Process | |
| ^ [[dbms:oracle:concept:oracleprocesses#mmon|MMON]] | Memory Monitor Process | |
| |
===== Database Files ===== | ===== Database Files ===== |
- **Control files** : DB의 물리적 구조(physical structure), #1개이상필요 | |
- **Data files** : 유저데이타(user data) + 메타데이타(meta data - data dictionary) | ^ **Control files** | DB의 물리적 구조(physical structure), #1개이상필요 | |
- **Redo Log files** : DB에 가해진 모든 변경사항 (최소 2group 1member) | ^ **Data files** | 유저데이타(user data) + 메타데이타(meta data - data dictionary) | |
- Archive Log files | ^ **Redo Log files** | DB에 가해진 모든 변경사항 (최소 2group 1member) | |
- Parameter file | ^ Archive Log files | | |
- Password file | ^ Parameter file | | |
- Alert log file , Trace file | ^ Password file | | |
- Online Redo Log files | ^ Alert log file , Trace file | | |
- Backup files | ^ Online Redo Log files | | |
| ^ Backup files | | |
| |
| |
| |