dbms:oracle:concept:oraclestruct
문서의 이전 판입니다!
목차
오라클 구조와 구성요소
User Process
- sqlplus, toad, orange …
- oracle database connection pool (weblogic,oracleAS,jeus …)
Server Process
PGA
INSTANCE
SGA(Memory)
- Shared Pool
- Redo Log Buffer
- Streams Pool
- Java Pool
- Large Pool
Background Process
- SMON (System Monitor)
- PMON (Process Monitor)
- DBWn (Database Writer)
- LGWR (Log Writer)
- CKPT (Check Point)
- ARCn (Archive Log)
Database Files
| Control files | DB의 물리적 구조(physical structure), #1개이상필요 |
|---|---|
| Data files | 유저데이타(user data) + 메타데이타(meta data - data dictionary) |
| Redo Log files | DB에 가해진 모든 변경사항 (최소 2group 1member) |
| Archive Log files | |
| Parameter file | |
| Password file | |
| Alert log file , Trace file | |
| Online Redo Log files | |
| Backup files |
dbms/oracle/concept/oraclestruct.1202828954.txt.gz · 마지막으로 수정됨: 저자 starlits