62

Size: px

Start display at page:

Download "62"

한비 가
6 years ago
Views:

1 2 instance database physical storage 2 1

2 62

3 63 tablespace datafiles 2 2

4 logical view control files datafiles redo log files

5 i OMF Oracle Managed Files, OMF 9i 9i / / OMF 9i

6 66 8 1MB 8 10MB NT 8 2.5MB 7.5MB

7 MAXDATAFILES 6 Oracle Parallel Server/Real Application Clusters MAX 2 5 MAXLOGFILES MAXLOGMEMBERS2 3 MAXLOGHISTORY

8 68 CONTROL_FILES CONTROL_FILES = (/u00/oradata/prod/prodctl1.ctl, / u 0 1 / o r a d a t a / p r o d / p r o d c t l 2. c t l, / u 0 2 / o r a d a t a / p r o d / p r o d c t l 3. c t l ) RAID 1 RAID 5 RAID6 redundant array of inexpensive disks 1. 6 striped array mirror pair 2.

9 69 mirrored I/O 7 c o n s i s t e n c y 2KB 32KB DEC VLM Very Large Memory 64KB BOB Big Oracle Blocks 9i 9i 5 2 4

10 70 9i 9i DB_BLOCK_SIZE 2KB 2KB OLTP online transac tion processing index 4KB8KB

11 71 8KB 16KB I/O inmemory 64KB I/O I/O datafile header checkpoint structure

12 72 e x t e n t segment 5

13 7 SELECT UNRECOVERABLE RECOVERABLE 7 3 SQL UNRECOVERABLE 7 NOLOGGING 8 DBA DBA

14 74 8 LOGGINGNOLOGGING 9i UNRECOVERABLERECOVERABLE 8NOLOGGING NOLOGGING NOLOGGING thread 2 5

15 primary 7 5

16 redolog1.log, redolog2.log, redolog3.log 1, 2, 3 redolog1.log 4 redolog2.log redog1m1.log, redog1m2.log,

17 redo.log g1m1 g1m2 7 7

18 78 10

19 79 SQL ALTER DATABASE ARCHIVELOG ARCHIVELOG LOG_ARCHIVE_START = TRUE L O G _ A R C H I V E _ D E S TA R C H I V E _ F O R MAT LOG_ARCHIVE_DEST = C:\ORANT\DATABASE\ARCHIVE LOG_ARCHIVE_FORMAT = O R C L % S. A R C ORCL.ARC %S 0

20 LOG_ARCHIVE_FORMAT = O R C L % T % S. A R C ARCHIVELOG ARCHIVELOG L O G _ A R C H I V E _ S TA RT FA L S E ARCHIVELOG LOG_ARCHIVE_START ARCHIVELOG ALTER DATABASE ARCHIVELOG 2 7

21 81 8 8i 10 8i

22 82 SGA System Global Area, SGA SQA 9i SGA SGA SGA 9i SGA SGA 9i SGA SGA granule

23 83 9i INIT.ORA 9i INIT.ORA SPFILE 9i SPFILE INIT.ORA 9i SPFILE INIT.ORA CONFIG.ORA Oracle Parallel Server/Real Application Clusters ID DBA 2 8

24 84 9i shared server MTS Multi Threaded Server job queues replication MTS SGA large pool, 2 8 8

25 85 I/O Multi Threaded Server 12 XA LARGE_POOL_SIZE SGA 6 SGA database buffer cache LRU least recently used I/O I/O 7 8 8

26 86 KEEP RECYCLE LRU shared pool constructs SQL LRU metadata redo log buffer

27 DBWR SGA D B W 0 DBW9 10 DBWR I/O DBWR LRU, least recently used LGWR SGA SGA LGWR

28 88 SMON SMON Oracle Parallel Server/Real Application Clusters SMON PMON PMON lock ARCH 8iARCn 10 ARCH LGWR LOG_ARCHIVE_MAX_PROCESSES ARCH CKPT DBWR CKPT RECO 10

29 89 DBWR LGWR process NT thread NT DBWR LGWR DBWR LGWR 7 M u l t i T h r e a d e d Server 9i NT real threads simulated threads Oracle Data Dictionary SQL 2 1

30 90 V$ GV$ DBA_ ALL_ USER_ V $ D A T A B A S E DBA_TABLESPACES, DBA_DATA_FILES, DBA_FREE_SPACE V$CONTROLFILE, V$PARAMETER, V $ C O N T R O L F I L E _ R E C O R D _ S E C T I O N V$DATAFILE, V$DATAFILE_HEADER, V$FILESTAT, D B A _ D A T A _ F I L E S D B A _ S E G M E N T S D B A _ E X T E N T S,, V$THREAD, V$LOG, V$LOGFILE V$DATABASE, V$LOG, V$ARCHIVED_LOG, V $ A R C H I V E _ D E S T V$INSTANCE, V$PARAMETER, V$SYSTEM_PARAMETER V$SGA, V$SGASTAT, V$DB_OBJECT_CACHE, V$SQL, V$SQLTEXT, V$SQLAREA V$BGPROCESS, V$SESSION

목 차

목 차 Oracle 9i Admim 1. Oracle RDBMS 1.1 (System Global Area:SGA) 1.1.1 (Shared Pool) 1.1.2 (Database Buffer Cache) 1.1.3 (Redo Log Buffer) 1.1.4 Java Pool Large Pool 1.2 Program Global Area (PGA) 1.3 Oracle