dbms:oracle:concept:oraclestruct

차이

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

차이 보기로 링크

--- dbms:oracle:concept:oraclestruct [2008/02/13 21:07]
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|}}
@@ 줄 20: / 줄 20: @@
 ===== Server Process =====
-==== PGA ====
+  - PGA(Program Global Areas)
+  - Dedicated Server Process
+  - Shared Server Process
 ===== INSTANCE =====
+=== An ORACLE INSTANCE ===
+{{dbms:oracle:concept:oralce_instance.gif|}}
@@ 줄 40: / 줄 48: @@
-==== Background Process ====
-^ SMON | (System Monitor) |
-^ PMON | (Process Monitor) |
-^ DBWn | (Database Writer) |
-^ LGWR | (Log Writer) |
-^ CKPT | (Check Point) |
-^ ARCn | (Archive Log) |
+==== 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.1202904460.txt.gz · 마지막으로 수정됨: 2008/02/13 21:07 저자 starlits