oracle ocp培训Less01_DB_Architecture_MB37730

Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Copyright 2005,Oracle.All rights reserved.,1-,*,Introduction,Course Objectives,After completing this course,you should be able to do the following:,Install,create,and administer Oracle Database 10,g,Configure the database for an application,Employ basic monitoring procedures,Implement a backup and recovery strategy,Move data between databases and 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,After completing this lesson,you should be able to do the following:,Describe the course objectives,Explain the Oracle Database 10,g,architecture,Oracle Products and Services,Oracle databases,Oracle Application Server,Oracle applications,Oracle Collaboration Suite,Oracle Developer Suite,Oracle services,Oracle Database 10,g,:“,g,”Stands for Grid,Global Grid Forum(GGF),Oracles grid infrastructure:,Low cost,High quality of service,Easy to manage,Automatic,Storage,Management,Real,Application,Clusters,Oracle,Streams,Enterprise,ManagerGrid Control,Storagegrid,Databasegrid,Applicationgrid,Gridcontrol,Grid Full Notes Page,Oracle Database Architecture,An Oracle server:,Is 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,Storage structures,Memory structures,Process structures,Instance,System Global Area(SGA),Background processes,Database files,DB structures,-Memory,-Process,-Storage,Oracle Memory Structures,.,Java pool,Database,buffer cache,Redo log,buffer,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,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,Instance,SGA,Background,processes,Server,process,PGA,User process,DB structures,Memory,Process,Storage,Oracle Instance Management,System,Monitor,(SMON),Database,Writer,(DBW,n,),LogWriter,(LGWR),Process,Monitor,(PMON),Archiver,(ARC,n,),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:,Pinned,Clean,Free or unused,Dirty,DBW,n,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 Database StructureFull Notes Page,Tablespaces and Data Files,Tablespaces consist of one or more data files.,Data files belong to only one tablespace.,USERS,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 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 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,Extent,Oracle datablock,Schema,Database StructuresFull Notes Page,Course Examples:The,HR,Schema,REGIONS,REGION_ID(PK),REGION_NAME,COUNTRIES,COUNTRY_ID(PK),COUNTRY_NAME,REGION_ID(FK),LOCATIONS,LOCATION_ID(PK),STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID(FK),DEPARTMENTS,DEPARTMENT_ID(PK),DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID(FK),JOBS,JOB_ID(PK),JOB_TITLE,MIN_SALARY,MAX_SALARY,EMPLOYEES,EMPLOYEE_ID(PK),FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID(FK),SALARY,COMMISION_PCT,MANAGER_ID(FK),DEPARTMENT_ID(FK),JOB_HISTORY,EMPLOYEE_ID(PK),START_DATE(PK),END_DATE,JOB_ID(FK),DEPARTMENT_ID(FK),REGIONS,COUNTRIES,LOCATIONS,DEPARTMENTS,JOBS,EMPLOYEES,JOB_HISTORY,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,DBW,n,CKPT,LGWR,ARC,n,and so on,Storage structures:,Logical:Database,schema,tablespace,segment