차이

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

--- dbms:oracle:concept:oraclestruct [2007/02/01 18:13]
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 ====
+^ **[[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 ]] |
-==== 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)
+^ [[dbms:oracle:concept:oracleprocesses#dbwn|DBWn]] | Database Writer Process |
-  - DBWn (Database Writer)
+^ [[dbms:oracle:concept:oracleprocesses#lgwr|LGWR]] | Log Writer Process |
-  - LGWR (Log Writer)
+^ [[dbms:oracle:concept:oracleprocesses#ckpt|CKPT]] | Checkpoint Process |
-  - CKPT (Check Point)
+^ [[dbms:oracle:concept:oracleprocesses#smon|SMON]] | System Monitor Process |
-  - ARCn (Archive Log)
+^ [[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 =====
-  - **Control files** : DB의 물리적 구조(physical structure), #1개이상필요
-  - **Data files** : 유저데이타(user data) + 메타데이타(meta data - data dictionary)
+^ **Control files** | DB의 물리적 구조(physical structure), #1개이상필요 |
-  - **Redo Log files** : DB에 가해진 모든 변경사항 (최소 2group 1member)
+^ **Data files** | 유저데이타(user data) + 메타데이타(meta data - data dictionary) |
-  - Archive Log files
+^ **Redo Log files** | DB에 가해진 모든 변경사항 (최소 2group 1member) |
-  - Parameter file
+^ Archive Log files |  |
-  - Password file
+^ Parameter file |  |
-  - Alert log file , Trace file
+^ Password file |  |
-  - Online Redo Log files
+^ Alert log file , Trace file |  |
-  - Backup files
+^ Online Redo Log files |  |
+^ Backup files |  |

adminschool.net wiki

사용자 도구

사이트 도구

차이

문서 도구