oracle ocp培训Less01_DB_Architecture_MB3

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-,24,Introduction,CourseObjectives,Aftercompleting thiscourse,youshould be abletodothe following:,Install,create, andadminister OracleDatabase10g,Configurethe database foranapplication,Employbasicmonitoringprocedures,Implementabackupand recovery strategy,Move databetweendatabasesand files,SuggestedSchedule,1.Introduction,2.Installation,3.DBCreation,4.Instance,5.Storage,6.Users,7.Schema,8.Data &Concurrency,9.Undo,10.Security,11.Network,12.Proactive Maintenance,13.Performance,14.Backup &RecoveryConcepts,15.Backup,16.Recovery,17.Flashback,18.Moving Data,LessonObjectives,Aftercompleting thislesson,youshould be abletodothe following:,Describethecourse objectives,Explain theOracleDatabase10garchitecture,OracleProductsand Services,Oracledatabases,OracleApplicationServer,Oracleapplications,OracleCollaborationSuite,OracleDeveloper Suite,Oracleservices,OracleDatabase10g:“g” StandsforGrid,GlobalGridForum,(,(GGF),Oracle,sgrid infrastructure:,Lowcost,High qualityofservice,Easy to manage,Automatic,Storage,Management,Real,Application,Clusters,Oracle,Streams,Enterprise,ManagerGrid Control,Storagegrid,Databasegrid,Applicationgrid,Gridcontrol,GridFull Notes Page,OracleDatabaseArchitecture,AnOracleserver:,Isa database managementsystem thatprovidesanopen,comprehensive,integratedapproachtoinformationmanagement,ConsistsofanOracleinstanceandanOracledatabase,DatabaseStructures,Storage structures,Memorystructures,Process structures,Instance,System Global Area (SGA),Background processes,Databasefiles,DBstructures,-Memory,-Process,-Storage,OracleMemory Structures,.,Java pool,Database,buffercache,Redo log,buffer,Sharedpool,Largepool,SGA,Streams pool,Server,process,1,PGA,Server,process,2,PGA,Background,process,PGA,DBstructures,Memory,Process,Storage,OracleMemory StructuresFullNotesPage,Process Structures,User process,:,:Isstarted at thetime adatabaseuserrequestsa connectiontothe Oracleserver,Serverprocess:ConnectstotheOracle instance andisstarted whenauser establishes asession,Background processes:Arestartedwhen an Oracleinstanceisstarted,Instance,SGA,Background,processes,Server,process,PGA,User process,DBstructures,Memory,Process,Storage,OracleInstanceManagement,System,Monitor,(SMON),Database,Writer,(DBWn),LogWriter,(LGWR),Process,Monitor,(PMON),Archiver,(ARCn),SGA,Java pool,Sharedpool,Largepool,Streams pool,Database,buffercache,Redo log,buffer,Checkpoint,(CKPT),Control,files,Data,files,Redo log,files,Archive,logfiles,ServerProcessandDatabaseBufferCache,Buffers:,Pinned,Clean,Free or unused,Dirty,DBW,n,Server,process,SGA,Database,buffercache,Data files,PhysicalDatabaseStructure,.,Onlineredologfiles,Passwordfile,Parameterfile,Archive logfiles,Control files,Data files,Alertandtracelog files,Backupfiles,DBstructures,Memory,Process,Storage,PhysicalDatabaseStructureFullNotesPage,TablespacesandDataFiles,Tablespacesconsist of oneormore datafiles,.,.,Data files belongtoonly onetablespace.,USERS,tablespace,Data file1,Data file2,SYSTEMandSYSAUXTablespaces,TheSYSTEMandSYSAUXtablespacesaremandatory tablespaces.,They arecreated at thetime of database creation.,They mustbeonline.,TheSYSTEMtablespace is usedfor corefunctionality,(,(for example, datadictionarytables,),).,TheauxiliarySYSAUXtablespace is usedfor additionaldatabasecomponents,(,(suchastheEnterpriseManager Repository,),).,Segments,Extents,and Blocks,Segmentsexistwithinatablespace.,Segmentsaremadeupofa collectionofextents.,Extents area collectionofdatablocks,.,.,Data blocksaremapped to diskblocks.,Segment,Extents,Data blocks,Disk blocks,Logical andPhysicalDatabaseStructures,Database,Logical,Physical,Tablespace,Data file,OSblock,Segment,Extent,Oracledatablock,Schema,DatabaseStructuresFullNotesPage,CourseExamples,:,: TheHRSchema,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,DatabaseArchitecture,:,:SummaryofStructuralComponents,Memorystructures:,SystemGlobal Area,(,(SGA),:,: Database buffercache,redobuffer, andvarious pools,Program GlobalArea (PGA,),),Process structures,:,:,User processand Serverprocess,Background processes:SMON,PMON,DBWn, CKPT, LGWR, ARCn, andsoon,Storage structures,:,:,Logical:Database,schema,tablespace,segment,extent, andOracleblock,Physical:Filesfor data, parameters, redo, andOSblock,Summary,Inthis lesson,you shouldhave learnedhow to:,Install,create, andadminister OracleDatabase10g,Configurethe database foranapplication,Employbasicmonitoringprocedures,Implementabackupand recovery strategy,Move databetweendatabasesand files,