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 · 마지막으로 수정됨: 2008/02/13 00:09 저자 starlits