Overview Processes Memory Structures Files 9 Oracle Instance
- Slides: 27
Overview Processes Memory Structures Files 9
Oracle Instance SMON SNPn PMON RECO SGA Shared Pool Area DBWR LCKn Database Buffer Cache Pnnn Redo Log Buffer CKPT ARCH LGWR 10
Shared Pool Area System Global Area (SGA) Shared Poll Area Shard SQL Area PL/SQL Procedure and Packages Control Structure Library Cache Dictionary Cache 11
Database Buffer Cache System Global Area (SGA) Shared Pool Database Buffer Cache 12
Redo Log Buffer System Global Area (SGA) Shared Pool Database Buffer Cache Redo Log Buffer 13
Background Processes SMON SNPn PMON RECO SGA Shared Pool DBWR LCKn Database Buffer Cache Pnnn Redo Log Buffer CKPT ARCH LGWR 15
우리 서버 환경 - ps –ef | grep ora ㅁ 207 oracle 7162 1 0 Nov 01 ? 00: 03 ora_pmon_ORCL PMON oracle 7164 1 0 Nov 01 ? 00: 03 ora_dbw 0_ORCL DBWR oracle 7166 1 0 Nov 01 ? 00: 02 ora_lgwr_ORCL LGWR oracle 7168 1 0 Nov 01 ? 00: 13 ora_ckpt_ORCL CKPT oracle 7170 1 0 Nov 01 ? 00: 01 ora_smon_ORCL SMON oracle 7172 1 0 Nov 01 ? 00: 00 ora_reco_ORCL RECO oracle 7174 1 0 Nov 01 ? 00: 06 ora_snp 0_ORCL SNP oracle 7176 1 0 Nov 01 ? 00: 06 ora_snp 1_ORCL SNP oracle 7178 1 0 Nov 01 ? 00: 05 ora_snp 2_ORCL SNP oracle 7180 1 0 Nov 01 ? 00: 05 ora_snp 3_ORCL SNP oracle 7182 1 0 Nov 01 ? 00: 00 ora_s 000_ORCL Shared Server oracle 7184 1 0 Nov 01 ? 00: 00 ora_d 000_ORC Dispatcher Process oracle 1910 1 0 Oct 31 ? 00: 08 ora_pmon_ORCL oracle 1912 1 0 Oct 31 ? 00: 05 ora_dbw 0_ORCL oracle 1914 1 0 Oct 31 ? 00: 05 ora_lgwr_ORCL oracle 1916 1 0 Oct 31 ? 00: 12 ora_ckpt_ORCL oracle 1918 1 0 Oct 31 ? 00: 01 ora_smon_ORCL oracle 1920 1 0 Oct 31 ? 00: 00 ora_reco_ORCL ㅁ EDB 16
User Processes SMON SNPn PMON RECO SGA Shared Pool DBWR LCKn Database Buffer Cache Pnnn Redo Log Buffer CKPT ARCH LGWR User Processes 18
Server Processes SMON SNPn LCKn PMON RECO SGA Shared Pool DBWR Database Buffer Cache Pnnn Redo Log Buffer CKPT ARCH LGWR Server Processes User Processes 19
Instance & Processes Oracle Instance SMON SNPn LCKn PMON DBWR RECO SGA Shared Pool Database Buffer Cache Pnnn Redo Log Buffer LGWR CKPT ARCH Server Processes User Processes 20
Oracle Database Data files Control Files Redo Log Files 21
Control Files ㅁ Control Files • 데이터베이스의 현재 상태와 물리적인 file structure 를 기록하는 binary file 이다. • data file, redo log file 정보 저장. • database 이름 저장. • control file 은 database 를 mount, open, access 하기 위해 필요. • recovery 에 필요한 synchronization 정보 저장. • 최소 2개 이상의 control file 을 서로 다른 디스크에 저장하는 것이 좋음. • initial parameter 중 control_files 라는 parameter 에 control file 의 경로와 이름을 설정. 23
Parameter File Oracle Instance SMON SNPn LCKn PMON DBWR RECO SGA Shared Pool LGWR Database Buffer Cache Pnnn Redo Log Buffer CKPT ARCH Parameter file 25
Trace & Alter Files Oracle Instance SMON SNPn LCKn PMON DBWR RECO SGA Shared Pool Database Buffer Cache Pnnn Redo Log Buffer LGWR CKPT ARCH Parameter file Trace & Alter files 26
Summary Oracle Instance Server Processes SMON SNPn PMON User Processes DBWR LCKn RECO Pnnn SGA Shared Pool Database Buffer Cache Redo Log Buffer LGWR CKPT ARCH Oracle Database Parameter file Trace & Alter files Control Files Data files Redo Log Files 27