Oracle8i培训文档.pptVIP

Oracle8i培训文档 来源：Down自网上 培训目的：基于数据库的系统概念， 对Oracle这个具体的数据 库产品有一个总体认识 3G平台/数据库开发组：李晓鹏 Oracle8i 培训文档 Architecture and Administration Network Administration Oracle Server组成 Oracle Database Files Data files contain the actual data in the database. The data is stored in user-defined tables, but data files also contain the data dictionary, before-images of modified data, indexes, and other types of structures. A database has at least one data file.The characteristics of data files are: A data file can be associated with only one database. Data files can have certain characteristics set to allow them to automatically extend when the database runs out of space. One or more data files form a logical unit of database storage called a tablespace. Oracle Database Files cont… Redo logs contain a record of changes made to the database to enable recovery of the data in case of failures. A database requires at least two redo log files. Control files contain information necessary to maintain and verify database integrity. For example, a control file is used to identify the data files and redo log files. A database needs at least one control file. Other Files The parameter file defines the characteristics of an Oracle instance. For example, it contains parameters that size some of the memory structures in the SGA. The password file authenticates which users are permitted to start up and shutdown an Oracle instance. Archived redo log files are offline copies of the redo log files that may be necessary to recover from media failures. Oracle Instance － SGA Shared pool SHARED_POOL_SIZE Database buffer cache DB_BLOCK_SIZE DB_BLOCK_BUFFERS Redo log buffer LOG_BUFFER Large buffer LARGE_POOL_SIZE Oracle Instance － Backgroud Process Database Writer (DBW0) is responsible for writing changed data from the database buffer cache to the data files. Log Writer (LGWR) writes changes registered in the redo log buffer to the redo log files. System Monitor (SMON) check