2 instance database physical storage 2 1
62
63 tablespace datafiles 2 2
64 1 2 logical view control files datafiles redo log files
65 2 3 9i OMF Oracle Managed Files, OMF 9i 9i / / OMF 9i
66 8 1MB 8 10MB NT 8 2.5MB 7.5MB
67 7 8 MAXDATAFILES 6 Oracle Parallel Server/Real Application Clusters MAX 2 5 MAXLOGFILES 10 20 MAXLOGMEMBERS2 3 MAXLOGHISTORY
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.
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
70 9i 9i DB_BLOCK_SIZE 2KB 2KB OLTP online transac tion processing index 4KB8KB
71 8KB 16KB I/O inmemory 64KB I/O I/O datafile header checkpoint structure
72 e x t e n t segment 5
7 SELECT UNRECOVERABLE RECOVERABLE 7 3 SQL UNRECOVERABLE 7 NOLOGGING 8 DBA DBA
74 8 LOGGINGNOLOGGING 9i UNRECOVERABLERECOVERABLE 8NOLOGGING NOLOGGING NOLOGGING thread 2 5
primary 7 5
redolog1.log, redolog2.log, redolog3.log 1, 2, 3 redolog1.log 4 redolog2.log 5 2 6 2 6 redog1m1.log, redog1m2.log,... 7 6
redo.log g1m1 g1m2 7 7
78 10
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
80 0 0 0 0 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
81 8 8i 10 8i
82 SGA System Global Area, SGA SQA 9i SGA SGA SGA 9i SGA SGA 9i SGA SGA granule
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
84 9i shared server MTS Multi Threaded Server job queues replication MTS 3 10 2 8 SGA large pool, 2 8 8
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
86 KEEP RECYCLE LRU shared pool constructs SQL LRU metadata redo log buffer
87 2 8 DBWR SGA D B W 0 DBW9 10 DBWR I/O DBWR LRU, least recently used LGWR SGA SGA LGWR
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
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
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