양쪽 이전 판
이전 판
다음 판
|
이전 판
|
dbms:oracle:concept:oraclestruct [2008/02/13 21:05] starlits |
dbms:oracle:concept:oraclestruct [2009/08/31 09:20] (현재) starlits |
===== 개념 ===== | ===== 개념 ===== |
| |
^ 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|}} | {{dbms:oracle:concept:oracleinstancemanagement.jpg?400x300|}} {{dbms:oracle:concept:oraclememorystructures.jpg?400x300|}} |
| |
===== Server Process ===== | ===== Server Process ===== |
==== PGA ==== | |
| - PGA(Program Global Areas) |
| - Dedicated Server Process |
| - Shared Server Process |
| |
| |
===== INSTANCE ===== | ===== INSTANCE ===== |
| |
| === An ORACLE INSTANCE === |
| |
| {{dbms:oracle:concept:oralce_instance.gif|}} |
| |
| |
==== SGA ==== | ==== SGA ==== |
| |
^ **[[dbms:oracle:concept:oraclestruct:sharedpool | Shared Pool]]** | | ^ **[[dbms:oracle:concept:sga#shared_pool | Shared Pool]]** | |
^ **[[dbms:oracle:concept:oraclestruct:databasebuffercache|Database Buffer Cache]]** | | ^ **[[dbms:oracle:concept:sga#database_buffer_cache |Database Buffer Cache]]** | |
^ **[[dbms:oracle:concept:oraclestruct:redologbuffer | Redo Log Buffer ]]** | | ^ **[[dbms:oracle:concept:sga#redo_log_buffer | Redo Log Buffer ]]** | |
^ [[dbms:oracle:concept:oraclestruct:streamspool | Streams Pool ]] | | |
^ [[dbms:oracle:concept:oraclestruct:javapool | Java Pool ]] | | |
^ [[dbms:oracle:concept:sga#large_pool | Large Pool ]] | | ^ [[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 ==== | |
| |
^ 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 ===== | ===== Database Files ===== |