没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle数据库参考10g:核心技术详解
"Oracle数据库手册10g是Oracle公司官方发布的一份技术文档,主要针对Oracle Database 10g Release 1 (10.1)版本。这份参考指南由众多专家共同编撰,旨在为数据库管理员、开发人员和其他IT专业人员提供关于Oracle数据库10g的详细信息和操作指南。手册涵盖了各种主题,包括SQL语法、PL/SQL编程、数据库管理、性能优化以及安全性等。"
Oracle数据库10g作为一款强大的关系型数据库管理系统,引入了许多新特性和改进,以提高性能、可用性和可管理性。以下是一些关键的知识点:
1. **Real Application Clusters (RAC)**: Oracle 10g引入了RAC,允许在多台服务器上共享同一个数据库,提高了高可用性和负载均衡能力。RAC通过Grid Infrastructure提供故障切换和数据访问透明性。
2. **Automatic Storage Management (ASM)**: ASM是一个集成的存储管理解决方案,简化了数据库存储的管理和维护,自动处理磁盘管理和数据放置。
3. **Data Guard**: 提供灾难恢复和数据库保护,通过创建和维护一个或多个备用数据库,可以在主数据库出现故障时无缝切换。
4. **SQL Enhancements**: 包括新的SQL功能,如Analytic Functions、Recursive Subquery Factoring(递归子查询因子)和Materialized Views,以增强数据分析和报表生成能力。
5. **PL/SQL Enhancements**: 提供了更好的调试工具、改进的异常处理和新的包管理功能,增强了PL/SQL的编程体验。
6. **Memory Management**: 引入了Automatic Memory Management,自动调整SGA和PGA的大小,以优化性能。
7. **Performance and Tuning**: 包括自动工作负载 repository (AWR) 和自动数据库诊断监视器 (ADDM),帮助识别和解决性能问题。
8. **SecureFile**: 改进了LOB(大型对象)存储,支持加密、压缩和直接I/O,提高了安全性和效率。
9. **XML Support**: 加强了对XML的支持,包括XMLDB,一个内置的XML存储和处理引擎,以及XQuery和XPath支持。
10. **Application Continuity**: 保证应用程序在数据库错误后能够继续运行,减少了事务失败的可能性。
11. **Grid Infrastructure**: 提供了一种集中式的管理和控制方式,使得在分布式环境中部署和管理Oracle数据库变得更加简单。
这份Oracle数据库10g参考手册是理解、管理和优化Oracle 10g数据库的关键资源,其中包含了详细的操作指南、语法参考、配置建议以及故障排除信息,对于深入学习和实际操作非常有帮助。无论是初学者还是经验丰富的专业人士,都能从中获取所需的信息来提升对Oracle数据库的理解和应用能力。
![](https://csdnimg.cn/release/download_crawler_static/2244106/bg10.jpg)
xvi
DBA_HIST_LATCH.............................................................................................................................. 3-55
DBA_HIST_LATCH_CHILDREN ..................................................................................................... 3-56
DBA_HIST_LATCH_MISSES_SUMMARY .................................................................................... 3-56
DBA_HIST_LATCH_NAME............................................................................................................... 3-57
DBA_HIST_LATCH_PARENT ........................................................................................................... 3-57
DBA_HIST_LIBRARYCACHE ........................................................................................................... 3-57
DBA_HIST_LOG................................................................................................................................... 3-58
DBA_HIST_METRIC_NAME ............................................................................................................ 3-59
DBA_HIST_MTTR_TARGET_ADVICE .......................................................................................... 3-59
DBA_HIST_OPTIMIZER_ENV ......................................................................................................... 3-60
DBA_HIST_OSSTAT............................................................................................................................ 3-60
DBA_HIST_OSSTAT_NAME............................................................................................................. 3-61
DBA_HIST_PARAMETER .................................................................................................................. 3-61
DBA_HIST_PARAMETER_NAME ................................................................................................... 3-61
DBA_HIST_PGA_TARGET_ADVICE.............................................................................................. 3-61
DBA_HIST_PGASTAT......................................................................................................................... 3-62
DBA_HIST_RESOURCE_LIMIT ....................................................................................................... 3-63
DBA_HIST_ROLLSTAT....................................................................................................................... 3-63
DBA_HIST_ROWCACHE_SUMMARY........................................................................................... 3-64
DBA_HIST_SEG_STAT ....................................................................................................................... 3-64
DBA_HIST_SEG_STAT_OBJ.............................................................................................................. 3-66
DBA_HIST_SERVICE_NAME ........................................................................................................... 3-66
DBA_HIST_SERVICE_STAT .............................................................................................................. 3-66
DBA_HIST_SERVICE_WAIT_CLASS .............................................................................................. 3-67
DBA_HIST_SESSMETRIC_HISTORY............................................................................................. 3-67
DBA_HIST_SGA................................................................................................................................... 3-67
DBA_HIST_SGASTAT......................................................................................................................... 3-68
DBA_HIST_SHARED_POOL_ADVICE .......................................................................................... 3-68
DBA_HIST_SNAP_ERROR ................................................................................................................ 3-69
DBA_HIST_SNAPSHOT..................................................................................................................... 3-69
DBA_HIST_SQL_PLAN ...................................................................................................................... 3-69
DBA_HIST_SQL_SUMMARY............................................................................................................ 3-71
DBA_HIST_SQL_WORKAREA_HSTGRM .................................................................................... 3-71
DBA_HIST_SQLBIND......................................................................................................................... 3-72
DBA_HIST_SQLSTAT ......................................................................................................................... 3-72
DBA_HIST_SQLTEXT ......................................................................................................................... 3-75
DBA_HIST_STAT_NAME................................................................................................................... 3-75
DBA_HIST_SYS_TIME_MODEL ...................................................................................................... 3-75
DBA_HIST_SYSMETRIC_HISTORY ............................................................................................... 3-75
DBA_HIST_SYSMETRIC_SUMMARY............................................................................................ 3-76
DBA_HIST_SYSSTAT .......................................................................................................................... 3-76
DBA_HIST_SYSTEM_EVENT ........................................................................................................... 3-77
DBA_HIST_TABLESPACE_STAT...................................................................................................... 3-77
DBA_HIST_TBSPC_SPACE_USAGE ............................................................................................... 3-77
DBA_HIST_TEMPFILE........................................................................................................................ 3-78
DBA_HIST_TEMPSTATXS................................................................................................................. 3-78
DBA_HIST_THREAD .......................................................................................................................... 3-79
![](https://csdnimg.cn/release/download_crawler_static/2244106/bg11.jpg)
xvii
DBA_HIST_UNDOSTAT..................................................................................................................... 3-79
DBA_HIST_WAITCLASSMET_HISTORY...................................................................................... 3-80
DBA_HIST_WAITSTAT....................................................................................................................... 3-81
DBA_HIST_WR_CONTROL .............................................................................................................. 3-81
DBA_IND_COLUMNS ........................................................................................................................ 3-81
DBA_IND_EXPRESSIONS ................................................................................................................. 3-81
DBA_IND_PARTITIONS .................................................................................................................... 3-82
DBA_IND_STATISTICS...................................................................................................................... 3-82
DBA_IND_SUBPARTITIONS............................................................................................................ 3-82
DBA_INDEXES...................................................................................................................................... 3-82
DBA_INDEXTYPE_ARRAYTYPES ................................................................................................... 3-82
DBA_INDEXTYPE_COMMENTS ..................................................................................................... 3-82
DBA_INDEXTYPE_OPERATORS ..................................................................................................... 3-82
DBA_INDEXTYPES.............................................................................................................................. 3-82
DBA_INTERNAL_TRIGGERS .......................................................................................................... 3-83
DBA_JAVA_ARGUMENTS................................................................................................................. 3-83
DBA_JAVA_CLASSES.......................................................................................................................... 3-83
DBA_JAVA_DERIVATIONS ............................................................................................................... 3-83
DBA_JAVA_FIELDS ............................................................................................................................. 3-83
DBA_JAVA_IMPLEMENTS ................................................................................................................ 3-83
DBA_JAVA_INNERS............................................................................................................................ 3-83
DBA_JAVA_LAYOUTS......................................................................................................................... 3-83
DBA_JAVA_METHODS ...................................................................................................................... 3-84
DBA_JAVA_NCOMPS ......................................................................................................................... 3-84
DBA_JAVA_POLICY............................................................................................................................. 3-84
DBA_JAVA_RESOLVERS.................................................................................................................... 3-84
DBA_JAVA_THROWS ......................................................................................................................... 3-84
DBA_JOBS.............................................................................................................................................. 3-85
DBA_JOBS_RUNNING....................................................................................................................... 3-85
DBA_JOIN_IND_COLUMNS ............................................................................................................ 3-85
DBA_KGLLOCK ................................................................................................................................... 3-85
DBA_LIBRARIES.................................................................................................................................. 3-85
DBA_LMT_FREE_SPACE.................................................................................................................... 3-86
DBA_LMT_USED_EXTENTS............................................................................................................. 3-86
DBA_LOB_PARTITIONS.................................................................................................................... 3-86
DBA_LOB_SUBPARTITIONS............................................................................................................ 3-86
DBA_LOB_TEMPLATES ..................................................................................................................... 3-86
DBA_LOBS............................................................................................................................................. 3-86
DBA_LOCK ............................................................................................................................................ 3-87
DBA_LOCK_INTERNAL .................................................................................................................... 3-87
DBA_LOCKS.......................................................................................................................................... 3-87
DBA_LOG_GROUP_COLUMNS ...................................................................................................... 3-87
DBA_LOG_GROUPS ........................................................................................................................... 3-87
DBA_LOGMNR_LOG ......................................................................................................................... 3-88
DBA_LOGMNR_PURGED_LOG...................................................................................................... 3-88
DBA_LOGMNR_SESSION ................................................................................................................ 3-88
DBA_LOGSTDBY_EVENTS .............................................................................................................. 3-89
![](https://csdnimg.cn/release/download_crawler_static/2244106/bg12.jpg)
xviii
DBA_LOGSTDBY_LOG...................................................................................................................... 3-90
DBA_LOGSTDBY_NOT_UNIQUE................................................................................................... 3-90
DBA_LOGSTDBY_PARAMETERS................................................................................................... 3-91
DBA_LOGSTDBY_PROGRESS......................................................................................................... 3-91
DBA_LOGSTDBY_SKIP ..................................................................................................................... 3-92
DBA_LOGSTDBY_SKIP_TRANSACTION .................................................................................... 3-92
DBA_LOGSTDBY_UNSUPPORTED................................................................................................ 3-93
DBA_METHOD_PARAMS................................................................................................................. 3-93
DBA_METHOD_RESULTS................................................................................................................. 3-93
DBA_MVIEW_AGGREGATES.......................................................................................................... 3-93
DBA_MVIEW_ANALYSIS.................................................................................................................. 3-93
DBA_MVIEW_COMMENTS.............................................................................................................. 3-94
DBA_MVIEW_DETAIL_RELATIONS.............................................................................................. 3-94
DBA_MVIEW_JOINS .......................................................................................................................... 3-94
DBA_MVIEW_KEYS ............................................................................................................................ 3-94
DBA_MVIEW_LOG_FILTER_COLS................................................................................................. 3-94
DBA_MVIEW_LOGS ........................................................................................................................... 3-94
DBA_MVIEW_REFRESH_TIMES..................................................................................................... 3-95
DBA_MVIEWS ...................................................................................................................................... 3-95
DBA_NESTED_TABLE_COLS ........................................................................................................... 3-95
DBA_NESTED_TABLES...................................................................................................................... 3-95
DBA_OBJ_AUDIT_OPTS.................................................................................................................... 3-95
DBA_OBJ_COLATTRS ........................................................................................................................ 3-96
DBA_OBJECT_SIZE ............................................................................................................................. 3-96
DBA_OBJECT_TABLES....................................................................................................................... 3-97
DBA_OBJECTS...................................................................................................................................... 3-97
DBA_OPANCILLARY .......................................................................................................................... 3-97
DBA_OPARGUMENTS....................................................................................................................... 3-97
DBA_OPBINDINGS ............................................................................................................................ 3-97
DBA_OPERATOR_COMMENTS ...................................................................................................... 3-97
DBA_OPERATORS............................................................................................................................... 3-97
DBA_ORPHAN_KEY_TABLE ............................................................................................................ 3-97
DBA_OUTLINE_HINTS...................................................................................................................... 3-98
DBA_OUTLINES .................................................................................................................................. 3-98
DBA_OUTSTANDING_ALERTS ...................................................................................................... 3-98
DBA_PART_COL_STATISTICS......................................................................................................... 3-99
DBA_PART_HISTOGRAMS .............................................................................................................. 3-99
DBA_PART_INDEXES ......................................................................................................................... 3-99
DBA_PART_KEY_COLUMNS ........................................................................................................... 3-99
DBA_PART_LOBS ................................................................................................................................ 3-99
DBA_PART_TABLES............................................................................................................................ 3-99
DBA_PARTIAL_DROP_TABS.......................................................................................................... 3-100
DBA_PENDING_CONV_TABLES .................................................................................................. 3-100
DBA_PENDING_TRANSACTIONS .............................................................................................. 3-100
DBA_PLSQL_OBJECT_SETTINGS ................................................................................................ 3-100
DBA_POLICIES................................................................................................................................... 3-100
DBA_POLICY_CONTEXTS .............................................................................................................. 3-100
![](https://csdnimg.cn/release/download_crawler_static/2244106/bg13.jpg)
xix
DBA_POLICY_GROUPS................................................................................................................... 3-100
DBA_PRIV_AUDIT_OPTS ............................................................................................................... 3-101
DBA_PROCEDURES.......................................................................................................................... 3-101
DBA_PROFILES .................................................................................................................................. 3-101
DBA_PROPAGATION....................................................................................................................... 3-101
DBA_PROXIES .................................................................................................................................... 3-101
DBA_PUBLISHED_COLUMNS ...................................................................................................... 3-102
DBA_QUEUE_SCHEDULES ............................................................................................................ 3-102
DBA_QUEUE_TABLES...................................................................................................................... 3-103
DBA_QUEUES..................................................................................................................................... 3-103
DBA_RCHILD ..................................................................................................................................... 3-103
DBA_RECYCLEBIN............................................................................................................................ 3-104
DBA_REDEFINITION_ERRORS .................................................................................................... 3-105
DBA_REDEFINITION_OBJECTS ................................................................................................... 3-105
DBA_REFRESH ................................................................................................................................... 3-106
DBA_REFRESH_CHILDREN........................................................................................................... 3-106
DBA_REFS............................................................................................................................................ 3-106
DBA_REGISTERED_ARCHIVED_LOG........................................................................................ 3-106
DBA_REGISTERED_MVIEW_GROUPS....................................................................................... 3-106
DBA_REGISTERED_MVIEWS........................................................................................................ 3-107
DBA_REGISTRY ................................................................................................................................. 3-107
DBA_REGISTRY_HIERARCHY ...................................................................................................... 3-108
DBA_REPAIR_TABLE........................................................................................................................ 3-108
DBA_RESUMABLE ............................................................................................................................ 3-109
DBA_REWRITE_EQUIVALENCES................................................................................................. 3-110
DBA_RGROUP.................................................................................................................................... 3-110
DBA_ROLE_PRIVS ............................................................................................................................ 3-110
DBA_ROLES ........................................................................................................................................ 3-110
DBA_ROLLBACK_SEGS .................................................................................................................. 3-111
DBA_RSRC_CONSUMER_GROUP_PRIVS................................................................................. 3-111
DBA_RSRC_CONSUMER_GROUPS............................................................................................. 3-112
DBA_RSRC_GROUP_MAPPINGS................................................................................................. 3-112
DBA_RSRC_MANAGER_SYSTEM_PRIVS ................................................................................. 3-112
DBA_RSRC_MAPPING_PRIORITY .............................................................................................. 3-113
DBA_RSRC_PLAN_DIRECTIVES .................................................................................................. 3-113
DBA_RSRC_PLANS........................................................................................................................... 3-114
DBA_RULE_SET_RULES .................................................................................................................. 3-115
DBA_RULE_SETS............................................................................................................................... 3-115
DBA_RULES ........................................................................................................................................ 3-115
DBA_SCHEDULER_JOB_ARGS ..................................................................................................... 3-115
DBA_SCHEDULER_JOB_CLASSES............................................................................................... 3-115
DBA_SCHEDULER_JOB_LOG........................................................................................................ 3-115
DBA_SCHEDULER_JOB_RUN_DETAILS .................................................................................... 3-115
DBA_SCHEDULER_JOBS ................................................................................................................ 3-115
DBA_SCHEDULER_PROGRAM_ARGS....................................................................................... 3-116
DBA_SCHEDULER_PROGRAMS .................................................................................................. 3-116
DBA_SCHEDULER_RUNNING_JOBS.......................................................................................... 3-116
![](https://csdnimg.cn/release/download_crawler_static/2244106/bg14.jpg)
xx
DBA_SCHEDULER_SCHEDULES.................................................................................................. 3-116
DBA_SCHEDULER_WINDOW_DETAILS ................................................................................... 3-116
DBA_SCHEDULER_WINDOW_GROUPS ................................................................................... 3-116
DBA_SCHEDULER_WINDOW_LOG............................................................................................ 3-116
DBA_SCHEDULER_WINDOWS .................................................................................................... 3-117
DBA_SCHEDULER_WINGROUP_MEMBERS............................................................................ 3-117
DBA_SEC_RELEVANT_COLS ......................................................................................................... 3-117
DBA_SEGMENTS............................................................................................................................... 3-117
DBA_SEQUENCES............................................................................................................................. 3-118
DBA_SERVER_REGISTRY ............................................................................................................... 3-118
DBA_SERVICES.................................................................................................................................. 3-118
DBA_SOURCE..................................................................................................................................... 3-119
DBA_SOURCE_TABLES ................................................................................................................... 3-119
DBA_SQL_PROFILES........................................................................................................................ 3-119
DBA_SQLJ_TYPE_ATTRS ................................................................................................................ 3-119
DBA_SQLJ_TYPE_METHODS ........................................................................................................ 3-119
DBA_SQLJ_TYPES ............................................................................................................................. 3-120
DBA_SQLSET ...................................................................................................................................... 3-120
DBA_SQLSET_BINDS....................................................................................................................... 3-120
DBA_SQLSET_REFERENCES.......................................................................................................... 3-120
DBA_SQLSET_STATEMENTS......................................................................................................... 3-121
DBA_SQLTUNE_BINDS................................................................................................................... 3-122
DBA_SQLTUNE_PLANS................................................................................................................... 3-122
DBA_SQLTUNE_RATIONALE_PLAN .......................................................................................... 3-124
DBA_SQLTUNE_STATISTICS......................................................................................................... 3-124
DBA_STMT_AUDIT_OPTS ............................................................................................................. 3-125
DBA_STORED_SETTINGS.............................................................................................................. 3-125
DBA_STREAMS_ADMINISTRATOR ........................................................................................... 3-125
DBA_STREAMS_GLOBAL_RULES ............................................................................................... 3-126
DBA_STREAMS_MESSAGE_CONSUMERS............................................................................... 3-126
DBA_STREAMS_MESSAGE_RULES ............................................................................................ 3-126
DBA_STREAMS_NEWLY_SUPPORTED ...................................................................................... 3-126
DBA_STREAMS_RULES .................................................................................................................. 3-126
DBA_STREAMS_SCHEMA_RULES .............................................................................................. 3-126
DBA_STREAMS_TABLE_RULES ................................................................................................... 3-126
DBA_STREAMS_TRANSFORM_FUNCTION ............................................................................ 3-127
DBA_STREAMS_UNSUPPORTED ................................................................................................ 3-127
DBA_SUBPART_COL_STATISTICS............................................................................................... 3-127
DBA_SUBPART_HISTOGRAMS.................................................................................................... 3-127
DBA_SUBPART_KEY_COLUMNS ................................................................................................. 3-127
DBA_SUBPARTITION_TEMPLATES ............................................................................................ 3-127
DBA_SUBSCRIBED_COLUMNS.................................................................................................... 3-127
DBA_SUBSCRIBED_TABLES.......................................................................................................... 3-128
DBA_SUBSCRIPTIONS .................................................................................................................... 3-128
DBA_SYNONYMS.............................................................................................................................. 3-128
DBA_SYS_PRIVS................................................................................................................................ 3-128
DBA_TAB_COL_STATISTICS ......................................................................................................... 3-128
剩余835页未读,继续阅读
420 浏览量
456 浏览量
140 浏览量
145 浏览量
103 浏览量
点击了解资源详情
341 浏览量
![](https://profile-avatar.csdnimg.cn/2bc11da723784f2eb04d1ea41aa10f6e_icepoint_77.jpg!1)
icepoint_77
- 粉丝: 20
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![](https://csdnimg.cn/release/wenkucmsfe/public/img/voice.245cc511.png)
最新资源
- C语言实现字符串逆置与矩阵转置
- 高质量C/C++编程规范与指南
- Python初学者到专业者指南:从入门到精通
- 探索Socket编程基础与转换技巧
- Linux下Qt编程入门:C++基础知识解析
- Tomcat安装与配置指南
- Qt编程入门:Linux下的HelloWorld教程
- 刘长炯著MyEclipse 6.0 Java开发全攻略
- 支持向量机入门与应用
- Linux下C/C++编程工具与页面置换算法详解
- SharpDevelop插件开发入门:PadPad功能详解
- 迈克尔·巴雷的C/C++嵌入式系统编程指南
- C语言上机实践指南:从编译到调试
- Oracle函数详解:从ASCII到RPAD/LPAD
- JavaScript基础知识点总结
- JSP2.0技术手册:Java Web开发基石
安全验证
文档复制为VIP权益,开通VIP直接复制
![](https://csdnimg.cn/release/wenkucmsfe/public/img/green-success.6a4acb44.png)