- 1、本文档共34页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
[Appi
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
您可能关注的文档
- [9.客户机服务器模式应用.ppt
- [abq03112010年塑造企业营销管理讲义-塑造企业价值管理文化ppt99.ppt
- [acceptanceletter.ppt
- [A4V系列力士乐Rexroth柱塞泵资料样本.ppt
- [access2010实例教程.ppt
- [Access1数据库12章.ppt
- [ABBinChinaCN2014.pptx
- [ACCESS2010入门基础教程.ppt
- [AC六章、人力资源管理辅导讲义.ppt
- [ACS-10讲义.ppt
- 硬笔书法基础笔画第三课撇课件-小学生书法.pptx
- 2.2.2一元二次不等式课件-高三中职数学一轮复习.pptx
- 18我喜欢我自己课件-一年级上册心理健康北师大版.pptx
- 第四课《接纳自己的情绪》(给自己的一封信)课件苏教版初中心理健康八年级全一册.pptx
- 第十二课《激发学习动机》课件苏教版心理健康七年级全一册.pptx
- 2.2.3绝对值不等式课件-高三中职数学一轮复习.pptx
- 中学生班主任培训课件.pptx
- 第十六课《你的心情我最懂》(情绪侦探)课件苏教版初中心理健康八年级全一册.pptx
- 专题一集合与简易逻辑课件-广西中职对口升学数学一轮复习.pptx
- 2.3均值定理课件-高三中职数学一轮复习.pptx
最近下载
- 中医整脊疗法选择题及答案.pdf
- 低脂高蛋白的健康风潮——即食鸡胸肉品类报告.pdf
- 统编版2024新版七年级上册道德与法治知识点提纲(实用,必备!).docx
- ANSI CTA-2034-A-2015 家用扬声器的标准测量方法 Standard Method of Measurement for In-Home Loudspeakers.pdf
- 撤销清算组备案及债权人公告范文.docx
- NYT2915-2016 水稻高温热害鉴定与分级.pdf
- 道德与法治优质课教研评比活动总结简报2021《课堂展风采 教研促成长 》.docx
- 端正入党动机以实际行动争取入党课件.pptx VIP
- 15 特殊健康状态儿童预防接种专家共识之十五——自身免疫性疾病与预防接种_孙金峤.pdf VIP
- 医院培训课件:《用药错误案例分析之RCA根本原因分析法》.pptx
文档评论(0)