dbms:oracle:concept:oraclestruct

차이

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

차이 보기로 링크

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

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