====== 오라클 구조와 구성요소 ======





===== 개념 =====

^ 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 =====
  - sqlplus, toad, orange ...
  - oracle database connection pool (weblogic,oracleAS,jeus ...)

===== Server Process =====

  - 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 ]] |




==== 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 =====

^ **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 |  |