dbms:oracle:concept:oraclestruct

문서의 이전 판입니다!

목차

오라클 구조와 구성요소

오라클 구조와 구성요소

User Process

sqlplus, toad, orange …
oracle database connection pool (weblogic,oracleAS,jeus …)

Server Process

PGA

INSTANCE

SGA(Memory)

Shared Pool
Database Buffer Cache
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.1170320883.txt.gz · 마지막으로 수정됨: 2007/02/01 18:08 저자 starlits