没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle11g数据库管理员指南
Oracle11g数据库管理员指南
需积分: 10 2 下载量 166 浏览量
更新于2024-07-23
收藏 12.67MB PDF 举报
"Oracle11g管理员手册是针对Oracle数据库管理员的重要参考书籍,旨在帮助DBA高效管理和维护Oracle 11g数据库系统。该手册由Steve Fogel为主要作者,并有多位专家共同参与编写,包含了丰富的实践经验和专业指导。"
在Oracle 11g管理员手册中,你将了解到以下关键知识点:
1. **Oracle数据库安装与配置**:手册详细介绍了如何在不同的操作系统平台上安装和配置Oracle 11g数据库,包括硬件和软件需求、安装过程、数据库创建以及网络配置。
2. **数据库管理基础**:涵盖了数据库实例管理、数据文件、控制文件、重做日志文件、表空间和临时表空间的创建与管理,以及数据库备份与恢复策略。
3. **性能优化**:包括SQL性能分析、索引策略、查询优化器的工作原理、数据库调优工具(如DBMS_STATS和Automatic Workload Repository)的使用,以及内存结构如SGA和PGA的调整。
4. **安全性管理**:讲解了用户管理、权限和角色的分配、数据库审计、加密技术以及网络安全措施,确保数据库的安全运行。
5. **高可用性与故障恢复**:讨论了RAC(Real Application Clusters)集群技术、Data Guard、Flashback Technology和LogMiner等工具,以实现高可用性和灾难恢复。
6. **存储管理**:包括存储结构如表、索引、分区和压缩的管理,以及如何利用Oracle的存储优化特性提高存储效率。
7. **数据库维护**:涉及日常维护任务,如数据库备份、归档日志管理、数据库性能监控、数据库升级和补丁应用等。
8. **故障诊断与问题解决**:提供了诊断和解决数据库问题的方法,包括使用Alert Log、Trace文件和Oracle Support Workbench等工具。
9. **自动管理功能**:Oracle 11g引入了许多自动化管理功能,如自动存储管理(ASM)、自动内存管理(AMM)和自动工作负载库(AWR),这些在手册中都有详细解释。
10. **数据库设计与开发**:虽然主要面向管理员,但手册也包含了一些关于数据库设计原则和PL/SQL编程的基础知识,帮助DBA更好地与开发团队协作。
这本手册不仅适合有经验的DBA,也是对Oracle 11g感兴趣的初学者的宝贵资源,通过深入学习,可以提升数据库管理的专业技能,应对各种复杂的企业级数据库挑战。
xvi
20 Managing Clusters
About Clusters ....................................................................................................................................... 20-1
Guidelines for Managing Clusters .................................................................................................... 20-2
Choose Appropriate Tables for the Cluster ................................................................................ 20-3
Choose Appropriate Columns for the Cluster Key.................................................................... 20-3
Specify the Space Required by an Average Cluster Key and Its Associated Rows .............. 20-3
Specify the Location of Each Cluster and Cluster Index Rows ................................................ 20-4
Estimate Cluster Size and Set Storage Parameters..................................................................... 20-4
Creating Clusters................................................................................................................................... 20-4
Creating Clustered Tables.............................................................................................................. 20-5
Creating Cluster Indexes................................................................................................................ 20-5
Altering Clusters ................................................................................................................................... 20-6
Altering Clustered Tables .............................................................................................................. 20-6
Altering Cluster Indexes ................................................................................................................ 20-7
Dropping Clusters................................................................................................................................. 20-7
Dropping Clustered Tables............................................................................................................ 20-8
Dropping Cluster Indexes.............................................................................................................. 20-8
Clusters Data Dictionary Views ......................................................................................................... 20-8
21 Managing Hash Clusters
About Hash Clusters............................................................................................................................. 21-1
When to Use Hash Clusters................................................................................................................. 21-2
Situations Where Hashing Is Useful............................................................................................. 21-2
Situations Where Hashing Is Not Advantageous ...................................................................... 21-2
Creating Hash Clusters ........................................................................................................................ 21-2
Creating a Sorted Hash Cluster..................................................................................................... 21-3
Creating Single-Table Hash Clusters ........................................................................................... 21-4
Controlling Space Use Within a Hash Cluster............................................................................ 21-4
Estimating Size Required by Hash Clusters................................................................................ 21-7
Altering Hash Clusters......................................................................................................................... 21-7
Dropping Hash Clusters ...................................................................................................................... 21-7
Hash Clusters Data Dictionary Views............................................................................................... 21-8
22 Managing Views, Sequences, and Synonyms
Managing Views.................................................................................................................................... 22-1
About Views .................................................................................................................................... 22-1
Creating Views ................................................................................................................................ 22-1
Replacing Views.............................................................................................................................. 22-3
Using Views in Queries ................................................................................................................. 22-4
Updating a Join View ..................................................................................................................... 22-5
Altering Views............................................................................................................................... 22-11
Dropping Views ............................................................................................................................ 22-12
Managing Sequences.......................................................................................................................... 22-12
About Sequences ........................................................................................................................... 22-12
Creating Sequences....................................................................................................................... 22-12
Altering Sequences........................................................................................................................ 22-13
xvii
Using Sequences............................................................................................................................ 22-13
Dropping Sequences..................................................................................................................... 22-16
Managing Synonyms.......................................................................................................................... 22-16
About Synonyms........................................................................................................................... 22-17
Creating Synonyms....................................................................................................................... 22-17
Using Synonyms in DML Statements ....................................................................................... 22-17
Dropping Synonyms..................................................................................................................... 22-18
Views, Synonyms, and Sequences Data Dictionary Views ........................................................ 22-18
23 Repairing Corrupted Data
Options for Repairing Data Block Corruption................................................................................ 23-1
About the DBMS_REPAIR Package .................................................................................................. 23-1
DBMS_REPAIR Procedures........................................................................................................... 23-2
Limitations and Restrictions.......................................................................................................... 23-2
Using the DBMS_REPAIR Package................................................................................................... 23-2
Task 1: Detect and Report Corruptions ....................................................................................... 23-3
Task 2: Evaluate the Costs and Benefits of Using DBMS_REPAIR.......................................... 23-4
Task 3: Make Objects Usable ......................................................................................................... 23-5
Task 4: Repair Corruptions and Rebuild Lost Data................................................................... 23-5
DBMS_REPAIR Examples................................................................................................................... 23-5
Examples: Building a Repair Table or Orphan Key Table ........................................................ 23-6
Example: Detecting Corruption .................................................................................................... 23-7
Example: Fixing Corrupt Blocks ................................................................................................... 23-8
Example: Finding Index Entries Pointing to Corrupt Data Blocks.......................................... 23-9
Example: Skipping Corrupt Blocks .............................................................................................. 23-9
Part IV Database Resource Management and Task Scheduling
24 Managing Automated Database Maintenance Tasks
About Automated Maintenance Tasks.............................................................................................. 24-1
About Maintenance Windows ........................................................................................................... 24-2
Configuring Automated Maintenance Tasks................................................................................... 24-3
Enabling and Disabling Maintenance Tasks for all Maintenance Windows.......................... 24-3
Enabling and Disabling Maintenance Tasks for Specific Maintenance Windows ................ 24-4
Configuring Maintenance Windows ................................................................................................. 24-4
Modifying a Maintenance Window.............................................................................................. 24-4
Creating a New Maintenance Window ....................................................................................... 24-4
Removing a Maintenance Window.............................................................................................. 24-5
Configuring Resource Allocations for Automated Maintenance Tasks..................................... 24-5
About Resource Allocations for Automated Maintenance Tasks............................................ 24-5
Changing Resource Allocations for Automated Maintenance Tasks...................................... 24-6
Automated Maintenance Tasks Reference ....................................................................................... 24-6
Predefined Maintenance Windows .............................................................................................. 24-7
Automated Maintenance Tasks Database Dictionary Views.................................................... 24-7
xviii
25 Managing Resource Allocation with Oracle Database Resource Manager
About Oracle Database Resource Manager...................................................................................... 25-1
What Problems Does the Resource Manager Address? ............................................................ 25-2
How Does the Resource Manager Address These Problems?.................................................. 25-2
Elements of the Resource Manager .............................................................................................. 25-3
About Resource Allocation Methods ........................................................................................... 25-6
About Resource Manager Administration Privileges................................................................ 25-8
Creating a Simple Resource Plan ...................................................................................................... 25-9
Creating a Complex Resource Plan.................................................................................................. 25-11
About the Pending Area .............................................................................................................. 25-11
Creating a Pending Area.............................................................................................................. 25-12
Creating Resource Consumer Groups ...................................................................................... 25-12
Creating a Resource Plan ............................................................................................................. 25-13
Creating Resource Plan Directives ............................................................................................ 25-14
Validating the Pending Area....................................................................................................... 25-18
Submitting the Pending Area...................................................................................................... 25-19
Clearing the Pending Area .......................................................................................................... 25-20
Assigning Sessions to Resource Consumer Groups..................................................................... 25-20
Overview of Assigning Sessions to Resource Consumer Groups ......................................... 25-21
Assigning an Initial Resource Consumer Group...................................................................... 25-21
Manually Switching Resource Consumer Groups................................................................... 25-21
Specifying Automatic Resource Consumer Group Switching ............................................... 25-22
Specifying Session-to–Consumer Group Mapping Rules....................................................... 25-24
Enabling Users or Applications to Manually Switch Consumer Groups............................. 25-27
Granting and Revoking the Switch Privilege............................................................................ 25-28
Enabling Oracle Database Resource Manager and Switching Plans........................................ 25-30
Putting It All Together: Oracle Database Resource Manager Examples .................................. 25-31
Multilevel Plan Example.............................................................................................................. 25-31
Example of Using Several Resource Allocation Methods....................................................... 25-33
An Oracle-Supplied Mixed Workload Plan .............................................................................. 25-34
Maintaining Consumer Groups, Plans, and Directives............................................................... 25-35
Updating a Consumer Group...................................................................................................... 25-36
Deleting a Consumer Group ....................................................................................................... 25-36
Updating a Plan............................................................................................................................. 25-36
Deleting a Plan............................................................................................................................... 25-36
Updating a Resource Plan Directive .......................................................................................... 25-37
Deleting a Resource Plan Directive ............................................................................................ 25-37
Viewing Database Resource Manager Configuration and Status
............................................. 25-37
Viewing Consumer Groups Granted to Users or Roles .......................................................... 25-37
Viewing Plan Information ........................................................................................................... 25-38
Viewing Current Consumer Groups for Sessions.................................................................... 25-38
Viewing the Currently Active Plans........................................................................................... 25-38
Monitoring Oracle Database Resource Manager.......................................................................... 25-39
Interacting with Operating-System Resource Control ................................................................ 25-41
Guidelines for Using Operating-System Resource Control.................................................... 25-42
Oracle Database Resource Manager Reference............................................................................. 25-42
Predefined Resource Plans and Consumer Groups................................................................. 25-43
xix
DBMS_RESOURCE_MANAGER Package Procedures Summary ........................................ 25-44
Resource Manager Data Dictionary Views ............................................................................... 25-45
26 Oracle Scheduler Concepts
Overview of Oracle Scheduler............................................................................................................ 26-1
What Can the Scheduler Do?......................................................................................................... 26-1
Scheduler Objects............................................................................................................................ 26-3
Programs.................................................................................................................................................. 26-3
Schedules ................................................................................................................................................ 26-4
Jobs........................................................................................................................................................... 26-4
Job Instances..................................................................................................................................... 26-5
Job Arguments................................................................................................................................. 26-5
How Programs, Jobs, and Schedules are Related....................................................................... 26-6
Job Categories .................................................................................................................................. 26-6
Chains .................................................................................................................................................... 26-11
Job Classes ............................................................................................................................................ 26-12
Windows ............................................................................................................................................... 26-14
Window Groups .................................................................................................................................. 26-15
Scheduler Architecture....................................................................................................................... 26-15
The Job Table.................................................................................................................................. 26-16
The Job Coordinator ..................................................................................................................... 26-16
How Jobs Execute.......................................................................................................................... 26-17
Job Slaves........................................................................................................................................ 26-17
Using the Scheduler in Real Application Clusters Environments......................................... 26-17
Scheduler Support for Oracle Data Guard..................................................................................... 26-19
27 Scheduling Jobs with Oracle Scheduler
Scheduler Objects and Their Naming............................................................................................... 27-1
Using Jobs ............................................................................................................................................... 27-2
Job Tasks and Their Procedures.................................................................................................... 27-2
Creating Jobs.................................................................................................................................... 27-2
Altering Jobs .................................................................................................................................. 27-12
Running Jobs.................................................................................................................................. 27-12
Stopping Jobs ................................................................................................................................. 27-13
Dropping Jobs................................................................................................................................ 27-14
Disabling Jobs ................................................................................................................................ 27-15
Enabling Jobs ................................................................................................................................. 27-16
Copying Jobs.................................................................................................................................. 27-16
Viewing the Job Log...................................................................................................................... 27-16
Viewing stdout and stderr for External Jobs............................................................................. 27-18
Using Programs.................................................................................................................................... 27-19
Program Tasks and Their Procedures........................................................................................ 27-19
Creating Programs ........................................................................................................................ 27-20
Altering Programs......................................................................................................................... 27-21
Dropping Programs...................................................................................................................... 27-22
Disabling Programs ...................................................................................................................... 27-22
xx
Enabling Programs........................................................................................................................ 27-22
Using Schedules .................................................................................................................................. 27-23
Schedule Tasks and Their Procedures ....................................................................................... 27-23
Creating Schedules........................................................................................................................ 27-23
Altering Schedules ........................................................................................................................ 27-24
Dropping Schedules...................................................................................................................... 27-24
Setting the Repeat Interval........................................................................................................... 27-24
Using Job Classes ................................................................................................................................ 27-28
Job Class Tasks and Their Procedures ....................................................................................... 27-28
Creating Job Classes...................................................................................................................... 27-29
Altering Job Classes ...................................................................................................................... 27-29
Dropping Job Classes.................................................................................................................... 27-29
Using Windows.................................................................................................................................... 27-30
Window Tasks and Their Procedures........................................................................................ 27-30
Creating Windows ........................................................................................................................ 27-31
Altering Windows......................................................................................................................... 27-32
Opening Windows........................................................................................................................ 27-32
Closing Windows.......................................................................................................................... 27-33
Dropping Windows ...................................................................................................................... 27-34
Disabling Windows ...................................................................................................................... 27-34
Enabling Windows........................................................................................................................ 27-34
Overlapping Windows................................................................................................................. 27-35
Using Window Groups....................................................................................................................... 27-37
Window Group Tasks and Their Procedures ........................................................................... 27-37
Creating Window Groups............................................................................................................ 27-38
Dropping Window Groups.......................................................................................................... 27-38
Adding a Member to a Window Group .................................................................................... 27-39
Dropping a Member from a Window Group............................................................................ 27-39
Enabling a Window Group.......................................................................................................... 27-39
Disabling a Window Group......................................................................................................... 27-39
Using Events......................................................................................................................................... 27-40
About Events.................................................................................................................................. 27-40
Using Events Raised by the Scheduler....................................................................................... 27-41
Using Events Raised by an Application..................................................................................... 27-43
Using Chains ........................................................................................................................................
27-47
Chain Tasks and Their Procedures............................................................................................. 27-48
Creating Chains............................................................................................................................. 27-49
Defining Chain Steps.................................................................................................................... 27-49
Adding Rules to a Chain.............................................................................................................. 27-50
Enabling Chains ............................................................................................................................ 27-53
Creating Jobs for Chains .............................................................................................................. 27-54
Dropping Chains........................................................................................................................... 27-55
Running Chains............................................................................................................................. 27-55
Dropping Chain Rules.................................................................................................................. 27-55
Disabling Chains ........................................................................................................................... 27-56
Dropping Chain Steps .................................................................................................................. 27-56
Stopping Chains ............................................................................................................................ 27-56
剩余881页未读,继续阅读
2019-09-23 上传
2012-05-11 上传
2023-07-14 上传
2023-07-09 上传
2023-07-11 上传
2024-01-25 上传
2023-10-23 上传
2023-07-15 上传
lzz7658823
- 粉丝: 3
- 资源: 13
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- C语言快速排序算法的实现与应用
- KityFormula 编辑器压缩包功能解析
- 离线搭建Kubernetes 1.17.0集群教程与资源包分享
- Java毕业设计教学平台完整教程与源码
- 综合数据集汇总:浏览记录与市场研究分析
- STM32智能家居控制系统:创新设计与无线通讯
- 深入浅出C++20标准:四大新特性解析
- Real-ESRGAN: 开源项目提升图像超分辨率技术
- 植物大战僵尸杂交版v2.0.88:新元素新挑战
- 掌握数据分析核心模型,预测未来不是梦
- Android平台蓝牙HC-06/08模块数据交互技巧
- Python源码分享:计算100至200之间的所有素数
- 免费视频修复利器:Digital Video Repair
- Chrome浏览器新版本Adblock Plus插件发布
- GifSplitter:Linux下GIF转BMP的核心工具
- Vue.js开发教程:全面学习资源指南
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功