《SMSE01_数据库体系结构》-课件设计（公开）.pptVIP

Oracle Architectural ComponentsOracle软件体系结构 Objectives After completing this lesson, you should be able to do the following: Defining the Oracle server: Oracle Database and Oracle Instance Establishing a connection and creating a session Understanding the Oracle Instance: memory structure and process structure Understanding the Oracle Database: physical structure and logical structure Outlining the stages of an SQL statement Other DBMSs Architecture: SQL Server and DB2 DBMS Architecture Overview of Primary Components Oracle Server An Oracle server: Consists of an Oracle instance and an Oracle database Can run on a number of different computers in one of the following ways: Host-Based Client Server Client-Application Server-Server Oracle Instance(Oracle实例、例程) An Oracle instance: Is a means to access an Oracle database Always opens one and only one 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. Dedicated Server Architecture for the User Process and Server Communication Shared Server Architecture for the User Process and Server Communication Memory Structure 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 Sort area Session information Cursor state Stack space System Global Area (SGA) The SGA consists of several memory structures: Shared pool Database buffer cache Redo log buffer Other structures (e.g. lock 、latch and Enqueue management, statistical data) There are two optional memory structures that can be configured within the SGA: Large pool Java pool System Global Area (SGA) SGA is dynamic and sized using SGA_MAX_SIZE. SGA memory allocated and tracked in granules by SGA components Contiguous virtu