oracle ocp培训Less01_DB_Architecture_MB3.ppt

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 between databases a

2、nd files,Suggested Schedule,1.Introduction 2.Installation 3.DB Creation 4.Instance 5.Storage 6.Users 7.Schema 8.Data & Concurrency 9.Undo 10.Security 11.Network 12.Proactive Maintenance,13.Performance 14.Backup & Recovery Concepts 15.Backup 16.Recovery 17.Flashback 18.Moving Data,Lesson Objectives,A

3、fter 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 Suite Oracle Developer Suite Oracle servic

4、es,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 a database management system that provides an open, comprehensive, integrated approac

5、h to information management Consists of an Oracle instance and an Oracle database,Database Structures,Storage structures,Memory structures,Process structures,Instance,Database files,DB structures - Memory - Process - Storage,Oracle Memory Structures .,Java pool,Database buffer cache,Redo log buffer,

6、Shared pool,Large pool,SGA,Streams pool,Server process 1,PGA,Server process 2,PGA,Background process,PGA,DB structures Memory Process Storage,Oracle Memory StructuresFull Notes Page,Process Structures,User process: Is started at the time a database user requests a connection to the Oracle server Ser

7、ver 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,Instance,Background processes,Server process,PGA,User process,DB structures Memory Process Storage,Oracle Instance Management,System Moni

8、tor (SMON),Database 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,Buffe

9、rs: Pinned 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 structures Memory Process Storage,Physical D

10、atabase StructureFull 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 of data

11、base 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 within

12、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,Extent,Oracl

13、e datablock,Schema,Database StructuresFull 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,Summary,In this lesson, you should have learn