版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、Introduction,Course Objectives,After completing this course, you should be able to do the following: Install, create, and administer Oracle Database 10g Configure the database for an application Employ basic monitoring procedures Implement a backup and recovery strategy Move data between databases a
2、nd files,Suggested Schedule,1.Introduction 2.Installation 3.DB Creation 4.Instance 5.Storage 6.Users 7.Schema 8.Data & Concurrency 9.Undo 10.Security 11.Network 12.Proactive Maintenance,13.Performance 14.Backup & Recovery Concepts 15.Backup 16.Recovery 17.Flashback 18.Moving Data,Lesson Objectives,A
3、fter completing this lesson, you should be able to do the following: Describe the course objectives Explain the Oracle Database 10g architecture,Oracle Products and Services,Oracle databases Oracle Application Server Oracle applications Oracle Collaboration Suite Oracle Developer Suite Oracle servic
4、es,Oracle Database 10g:“g” Stands for Grid,Global Grid Forum (GGF) Oracles 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 approac
5、h to information management Consists of an Oracle instance and an Oracle database,Database Structures,Storage structures,Memory structures,Process structures,Instance,Database files,DB structures - Memory - Process - Storage,Oracle Memory Structures .,Java pool,Database buffer cache,Redo log buffer,
6、Shared pool,Large pool,SGA,Streams pool,Server process 1,PGA,Server process 2,PGA,Background process,PGA,DB structures Memory Process Storage,Oracle Memory StructuresFull Notes Page,Process Structures,User process: Is started at the time a database user requests a connection to the Oracle server Ser
7、ver 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,Instance,Background processes,Server process,PGA,User process,DB structures Memory Process Storage,Oracle Instance Management,System Moni
8、tor (SMON),Database Writer (DBWn),LogWriter (LGWR),Process Monitor (PMON),Archiver (ARCn),SGA,Java pool,Shared pool,Large pool,Streams pool,Database buffer cache,Redo log buffer,Checkpoint (CKPT),Control files,Data files,Redo log files,Archive log files,Server Process and Database Buffer Cache,Buffe
9、rs: Pinned Clean Free or unused Dirty,Server process,SGA,Database buffer cache,Data files,Physical Database Structure .,Online redo log files,Password file,Parameter file,Archive log files,Control files,Data files,Alert and trace log files,Backup files,DB structures Memory Process Storage,Physical D
10、atabase StructureFull Notes Page,Tablespaces and Data Files,Tablespaces consist of one or more data files. Data files belong to only one tablespace.,Data file 1,Data file 2,SYSTEM and SYSAUX Tablespaces,The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. They are created at the time of data
11、base creation. They must be online. The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). The auxiliary SYSAUX tablespace is used for additional database components (such as the Enterprise Manager Repository).,Segments, Extents, and Blocks,Segments exist within
12、a tablespace. Segments are made up of a collection of extents. Extents are a collection of data blocks. Data blocks are mapped to disk blocks.,Segment,Extents,Data blocks,Disk blocks,Logical and Physical Database Structures,Database,Logical,Physical,Tablespace,Data file,OS block,Segment,Extent,Oracl
13、e datablock,Schema,Database StructuresFull Notes Page,Course Examples: The HR Schema,Database Architecture:Summary of Structural Components,Memory structures: System Global Area (SGA): Database buffer cache, redo buffer, and various pools Program Global Area (PGA) Process structures: User process and Server process Background processes: SMON, PMON, DBWn, CKPT, LGWR, ARCn, and so on Storage structures: Logical: Database, schema, tablespace, segment, extent, and Oracle block Physical: Files for data, parameters, redo, and OS block,Summary,In this lesson, you should have learn
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 小学五年级科学《巧用斜面》教学设计:从现象探究到工程建模
- 高三化学教案:化学平衡常数综合计算的三阶突破
- 七年级语文下册《有为有不为》教学设计:义利抉择与君子养心
- 初中七年级英语 Unit 3 My School Section B 语音教学设计
- 小学五年级美术《色彩的色相》教学设计
- 高中二年级英语UNIT 6晨背Topic Talk主题语境词汇教学设计(北师大版选择性必修第二册)
- 2027届高三英语听力教学设计:语篇重构与策略迁移专题第四十三课时
- 2026事业单位工勤技能-新疆-新疆广播电视天线工三级(高级工)历年参考题库含答案详解
- CN119538150A 一种基于机器学习的大数据异常检测处理方法 (深圳市宝龙数据科技有限公司)
- 湖北省荆州市荆州区2026-2027学年上学期期中质量监测七年级语文试题(文字版含答案)
- 工会审计整改报告模板及范例
- 隐睾下降固定术手术规范
- 2025年石河子大学马克思主义基本原理概论期末考试真题汇编
- 2026年医疗保险审核部门面试题及应对策略
- 2026-2031中国法兰行业市场前景分析预测报告
- 施工便道临时方案
- 信息科技课程标准2025年版
- 眼科手术并发症处理规定
- 风机叶片覆冰安全培训课件
- 2025云南曲靖市人力资源和社会保障局招聘公益性岗位工作人员3人考试参考题库及答案解析
- 医院服务接待礼仪
评论
0/150
提交评论