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.1170321184.txt.gz · 마지막으로 수정됨: 저자 starlits