02_-_FND_-_Basic_Oracle_Concepts

1、Copyright SUPINFO. All rights reservedBasic Oracle ConceptsCourse objectivesBy completing this course, you will learn:Basic Oracle Conceptsn What a database is and what makes a database relationaln What SQL isn Which database objects are supported in Oracle 10gn What a database administrator doesn H

2、ow the Oracle database fits into the Oracle product familyn To explain the Oracle database architecture constructn To explain the instance architectureCourse topicsCourses plan:Basic Oracle Conceptsn Introduction to Database and Relational Modeln Oracle ArchitectureIntroduction to Database and Relat

3、ional ModelBasic Oracle ConceptsPreviewn Oracle Productsn Relational Database Systemsn Structured Query Languagen Tasks of an Oracle Database AdministratorIntroduction to Database and Relational ModelOracle Productsn Oracle Databasen Oracle Application Servern Oracle Applicationsn Oracle Collaborati

4、on Suiten Oracle Development Suiten Oracle ServicesIntroduction to Database and Relational ModelRelational Database SystemsIntroduction to Database and Relational ModelTableColumnRowField or cellRelational Database SystemsIntroduction to Database and Relational ModelEmployeesDepartmentsRelational Da

5、tabase SystemsIntroduction to Database and Relational ModelStructured Query Languagen Structured query language (SQL): A standard interactive and programming language for getting information from and updating information in a databasen SQL provides statements for a variety of tasks, including:n Quer

6、ying datan Inserting, updating, and deleting rows in a tablen Creating, replacing, altering, and dropping objectsn Controlling access to the database and its objectsn Guaranteeing database consistency and integrityIntroduction to Database and Relational ModelTasks of an Oracle Database Administrator

7、Introduction to Database and Relational Modeln Prioritized approach for designing, implementing, and maintaining an Oracle database:n Evaluate the database server hardware.n Install the Oracle software.n Plan the database.n Create and open the database.n Back up the database.n Enroll system users.n

8、Implement the database design.n Recover from database failure.n Monitor database performance.SQLOracle ProductsTasks of a DBAPart 1 SummaryRelational Database SystemsIntroduction to Database and Relational ModelPart 1 Stop-and-thinkIntroduction to Database and Relational ModelDo you have any questio

9、ns ?Oracle ArchitectureBasic Oracle ConceptsPreviewn Storagen Logical Structuresn The Data Dictionaryn Database/Grid ControlOracle ArchitectureStorageOracle ArchitectureControl filesData filesOnline redo log filesParameter filePassword fileArchive log filesStorageOracle ArchitectureContain physical

10、database structure informationMultiplexed to protect against lossRequired to start the instanceControl filesControl FilesStorageOracle ArchitectureRecord changes to the databaseMultiplexed to protect against lossesLog writer LGWRGroup 1Group 2Group 3Redo log bufferRedo Log FilesStorageOracle Archite

11、ctureTablespaces consist of one or more data files.Data files belong to only one tablespace.Data file 1Data file 2USERS TablespaceTablespaces and Data filesStorageOracle ArchitectureSegments exist within a tablespace.Segments are made of a collection of extents.Extents are a collection of data block

12、s.Data blocks are mapped to OS blocks.SegmentExtentsData blocksOS blocksSegments, Extents, and BlocksStorageOracle ArchitectureClick on the links to view detailed informationExploring the Storage StructureLogical structuresOracle ArchitectureSGAShared PoolStreams PoolLarge PoolJava PoolDatabase Buff

13、er CacheRedo Log BufferSystem Monitor SMONProcess Monitor PMONDatabase Writer DBW0Log Writer LGWRCheck point CKPTArchiver ARC0Oracle Instance ManagementLogical structuresOracle ArchitectureSGAShared PoolStreams PoolLarge PoolJava PoolDatabase Buffer CacheRedo Log BufferServer Process 1PGAServer Proc

14、ess 2PGABack-ground ProcessPGAOracle Memory StructuresLogical structuresOracle ArchitectureSystem Global AreaSGAServer ProcessServer ProcessServer ProcessServer ProcessSystem Monitor SMONProcess Monitor PMONDatabaseWriterDBW0Check point CKPTLog Writer LGWRArchiver ARCnBackground ProcessesOracle Proc

15、essesThe Data DictionaryOracle ArchitectureData dictionary in Enterprise ManagerOracle ArchitectureDatabase controlDatabase/Grid ControlDatabase ControlDatabase/Grid ControlOracle ArchitectureGrid controlManagement serverManagement repositoryDatabase controlApplication server controlDatabaseOS/third

16、-party applicationApplication serverManaged targetsAgentAgentAgentGrid ControlStorageLogical StructuresThe Data DictionaryPart 2 SummaryOracle ArchitectureDatabase/Grid ControlOracle ArchitecturePart 2 Stop-and-thinkDo you have any questions ?For moreBasic Oracle ConceptsIf you want to go into these subjects more deeply, CoursesPublicationsWeb siteshttp:/Cursus: Merise & SQLCursus: PL/SQLCursu