1、苏州市软件评测中心有限公司,Introduction,Course Objectives,After completing this course, you should be able to do the following: Install, create, and administer Oracle Database 10g Configure the database for an application Employ basic monitoring procedures Implement a backup and recovery strategy Move data betwe
2、en databases and files,Lesson Objectives,After completing this lesson, you should be able to do the following: Describe the course objectives Explain the Oracle Database 10g architecture,Oracle Products and Services,Oracle databases Oracle Application Server Oracle applications Oracle Collaboration
3、Suite Oracle Developer Suite Oracle services,苏州市软件评测中心有限公司,Oracle Database 10g: “g” Stands for Grid,Global Grid Forum (GGF) Oracles grid infrastructure: Low cost High quality of service Easy to manage,苏州市软件评测中心有限公司,Grid Full Notes Page,苏州市软件评测中心有限公司,Oracle Database Architecture,An Oracle server: Is
4、a database management system that provides an open, comprehensive, integrated approach to information management Consists of an Oracle instance and an Oracle database,苏州市软件评测中心有限公司,Database Structures,DB structures- Memory- Process- Storage,Oracle Memory Structures .,Java pool,Database buffer cache,
5、Redo log buffer,Shared pool,Large pool,SGA,Streams pool,Server process 1,PGA,Server process 2,PGA,Background process,PGA,DB structures MemoryProcessStorage,苏州市软件评测中心有限公司,Oracle Memory Structures Full Notes Page,苏州市软件评测中心有限公司,Process Structures,User process: Is started at the time a database user req
6、uests a connection to the Oracle server Server process: Connects to the Oracle instance and is started when a user establishes a session Background processes: Are started when an Oracle instance is started,DB structuresMemory Process Storage,Oracle Instance Management,System Monitor (SMON),Database
7、Writer (DBWn),LogWriter (LGWR),Process Monitor (PMON),Archiver (ARCn),SGA,Java pool,Shared pool,Large pool,Streams pool,Database buffer cache,Redo log buffer,Checkpoint (CKPT),Control files,Data files,Redo log files,Archive log files,苏州市软件评测中心有限公司,Server Process and Database Buffer Cache,Buffers: Pi
8、nned Clean Free or unused Dirty,Server process,SGA,Database buffer cache,Data files,Physical Database Structure .,Online redo log files,Password file,Parameter file,Archive log files,Control files,Data files,Alert and trace log files,Backup files,DB structuresMemoryProcess Storage,Physical Database
9、Structure Full Notes Page,Tablespaces and Data Files,Tablespaces consist of one or more data files. Data files belong to only one tablespace.,Data file 1,Data file 2,苏州市软件评测中心有限公司,SYSTEM and SYSAUX Tablespaces,The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. They are created at the time
10、of database creation. They must be online. The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). The auxiliary SYSAUX tablespace is used for additional database components (such as the Enterprise Manager Repository).,Segments, Extents, and Blocks,Segments exist
11、within a tablespace. Segments are made up of a collection of extents. Extents are a collection of data blocks. Data blocks are mapped to disk blocks.,Segment,Extents,Data blocks,Disk blocks,Logical and Physical Database Structures,Database,Logical,Physical,Tablespace,Data file,OS block,Segment,Exten
12、t,Oracle data block,Schema,苏州市软件评测中心有限公司,Database Structures Full Notes Page,苏州市软件评测中心有限公司,Course Examples: The HR Schema,苏州市软件评测中心有限公司,Database Architecture: Summary of Structural Components,Memory structures: System Global Area (SGA): Database buffer cache, redo buffer, and various pools Program Global Area (PGA) Process structures: User process and Server process Background processes: SMON, PMON, DBWn, CKPT, LGWR, ARCn, and so on Storage structures: Logical: Database, schema, tablespace, segment, extent, and Oracle block Physical: Files for data, parameters, redo, and OS block,
