dbms:oracle:concept:oraclestruct

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- dbms:oracle:concept:oraclestruct [2008/02/13 23:37]
starlits
+++ dbms:oracle:concept:oraclestruct [2009/08/31 09:20] (현재)
starlits
@@ 줄 7: / 줄 7: @@
 ===== 개념 =====
-^ User Process | 사용자가 오라클 데이타베이스 접근을 하기 위해 사용하는 프로그램 |
+^ User Process    | 사용자가 오라클 데이타베이스 접근을 하기 위해 사용하는 프로그램 |
-^ Server Process | 서버 프로세스가 PGA를 이용하여 데이타베이스에 접근한다 |
+^ Server Process  | 서버 프로세스가 PGA를 이용하여 데이타베이스에 접근한다 |
-^ Instance | 오라클 데이타베이스의 Memory 영역 (SGA + Backgroup Process) |
+^ Instance        | 오라클 데이타베이스의 Memory 영역 (SGA + Backgroup Process) |
-^ Database Files | 오라클 데이타베이스의 물리적인 데이타파일 영역 |
+^ Database Files  | 오라클 데이타베이스의 물리적인 데이타파일 영역 |
 {{dbms:oracle:concept:oracleinstancemanagement.jpg?400x300|}} {{dbms:oracle:concept:oraclememorystructures.jpg?400x300|}}
@@ 줄 24: / 줄 24: @@
   - Dedicated Server Process
   - Shared Server Process
 ===== INSTANCE =====
+=== An ORACLE INSTANCE ===
+{{dbms:oracle:concept:oralce_instance.gif|}}
@@ 줄 41: / 줄 46: @@
 ^ [[dbms:oracle:concept:sga#java_pool | Java Pool ]] |
 ^ [[dbms:oracle:concept:sga#streams_pool | Streams Pool ]] |
@@ 줄 46: / 줄 52: @@
 ==== Background Process ====
-^ DBWn | Database Writer Process |
+^ [[dbms:oracle:concept:oracleprocesses#dbwn|DBWn]] | Database Writer Process |
-^ LGWR | Log Writer Process |
+^ [[dbms:oracle:concept:oracleprocesses#lgwr|LGWR]] | Log Writer Process |
-^ CKPT | Checkpoint Process |
+^ [[dbms:oracle:concept:oracleprocesses#ckpt|CKPT]] | Checkpoint Process |
-^ SMON | System Monitor Process |
+^ [[dbms:oracle:concept:oracleprocesses#smon|SMON]] | System Monitor Process |
-^ PMON | Process Monitor Process |
+^ [[dbms:oracle:concept:oracleprocesses#pmon|PMON]] | Process Monitor Process |
-^ RECO | Recoverer Process |
+^ [[dbms:oracle:concept:oracleprocesses#reco|RECO]] | Recoverer Process |
-^ Jnnn | Job Queue Process |
+^ [[dbms:oracle:concept:oracleprocesses#jnnn|Jnnn]] | Job Queue Process |
-^ CJQn | Coordinator Job Queue Process |
+^ [[dbms:oracle:concept:oracleprocesses#cjqn|CJQn]] | Coordinator Job Queue Process |
-^ ARCn | Archiver Process |
+^ [[dbms:oracle:concept:oracleprocesses#arcn|ARCn]] | Archiver Process |
-^ Dnnn | Dispatcher Process |
+^ [[dbms:oracle:concept:oracleprocesses#dnnn|Dnnn]] | Dispatcher Process |
-^ QMNn | Queue Monitor Process |
+^ [[dbms:oracle:concept:oracleprocesses#qmnn|QMNn]] | Queue Monitor Process |
-^ MMAN | Memory Manager Process |
+^ [[dbms:oracle:concept:oracleprocesses#mman|MMAN]] | Memory Manager Process |
-^ RVWR | Recovery Writer Process |
+^ [[dbms:oracle:concept:oracleprocesses#rvwr|RVWR]] | Recovery Writer Process |
-^ CTWR | Change Tracking Writer Process |
+^ [[dbms:oracle:concept:oracleprocesses#ctwr|CTWR]] | Change Tracking Writer Process |
-^ MMNL | Memory Monitor Light Process |
+^ [[dbms:oracle:concept:oracleprocesses#mmnl|MMNL]] | Memory Monitor Light Process |
-^ MMON | Memory Monitor Process |
+^ [[dbms:oracle:concept:oracleprocesses#mmon|MMON]] | Memory Monitor Process |
 ===== Database Files =====

dbms/oracle/concept/oraclestruct.1202913472.txt.gz · 마지막으로 수정됨: 2008/02/13 23:37 저자 starlits