OracleDB_Architecture_MB.pptVIP

引言 本课程的目的 After completing this course, you should be able to do the following: 安装、创建、管理 Oracle Database 10g 为一个应用配置数据库 使用一些基本的监视程序 实现 backup and recovery strategy 在数据库与文件之间移动数据（Move data） 这节课的目的 After completing this lesson, you should be able to do the following: 掌握 Oracle Database 10g 的体系结构 Oracle Products and Services Oracle databases Oracle Application Server Oracle applications Oracle Collaboration Suite Oracle Developer Suite Oracle services Oracle Database 10g:“g” Stands for Grid Global Grid Forum (GGF) Oracle’s 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 approach to information management Consists of an Oracle instance and an Oracle database Oracle Instance An Oracle instance: Is a means to access an Oracle database Consists of memory and process structures Establishing a Connection and Creating a Session Connecting to an Oracle instance consists of establishing a user connection and creating a session. Overview of Primary Components Database Structures Oracle Memory Structures . Oracle Memory StructuresFull Notes Page Memory Structure Oracle’s memory structure consists of two memory areas known as: System Global Area (SGA): Allocated at instance startup, and is a fundamental component of an Oracle Instance Program Global Area (PGA): Allocated when the server process is started System Global Area (SGA) The SGA consists of several memory structures: Shared pool Database buffer cache Redo log buffer Other structures (e.g. lock and latch management, statistical data) There are two optional memory structures that can be configured within the SGA: Large pool Java pool Shared Pool The shared pool is used to store the most recently executed SQL statements and the most recently used data definitions. It consists of two key performance-related memory structures: Library cache Data diction