App_i.ppt

Oracle Database Architectural Components Objectives After completing this appendix, you should be able to do the following: List the major database architectural components Describe the background processes Explain the memory structures Correlate the logical and physical storage structures Oracle Database Architecture: Overview The Oracle Relational Database Management System (RDBMS) is a database management system that provides an open, comprehensive, integrated approach to information management. Oracle Database Server Structures Connecting to the Database Connection: Communication pathway between a user process and a database instance Session: A specific connection of a user to a database instance through a user process Interacting with an Oracle Database Oracle Memory Architecture Process Architecture User process: Is started when a database user or a batch process connects to the Oracle Database Database processes: 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 Database Writer Process  Writes modified (dirty) buffers in the database buffer cache to disk: Asynchronously while performing other processing Periodically to advance the checkpoint Log Writer Process Writes the redo log buffer to a redo log file on disk LGWR writes: A process commits a transaction When the redo log buffer is one-third full Before a DBWn process writes modified buffers to disk Checkpoint Process  Records checkpoint information in: The control file Each datafile header System Monitor Process  Performs recovery at instance startup Cleans up unused temporary segments Process Monitor Process Performs process recovery when a user process fails: Cleans up the database buffer cache Frees resources used by the user process Monitors sessions for idle session timeout Dynamically registers database services with listeners Oracle Database Storage Architecture Logical an