Oracle Database 12c Release 1官方参考手册

需积分: 0 132 浏览量更新于2024-06-27 收藏 11.35MB PDF 举报

"Oracle Database Reference 12c Release 1 (12.1) 是一本由Oracle公司出版的官方文档，旨在为用户和管理员提供关于Oracle 12c数据库第一版的详细参考信息。该文档涵盖了从基础概念到高级特性的广泛内容，包括SQL语法、PL/SQL编程、数据库管理、性能优化等多个方面。文档的主要作者是Bert Rich，还有众多贡献者共同编纂而成，版权归属于Oracle公司及其关联公司。" Oracle 12c数据库是一个企业级的关系型数据库管理系统，它引入了许多创新功能和改进，以提高性能、可扩展性和云集成。以下是一些关键的知识点： 1. **Multitenant架构**：Oracle 12c引入了多租户容器数据库（CDB）的概念，允许在一个物理数据库中包含多个独立的、隔离的数据库实例，称为可插拔数据库（PDB）。这种设计提高了管理效率，并支持快速部署和迁移。 2. **Automatic Memory Management**：Oracle 12c增强了自动内存管理，允许数据库自动调整SGA（系统全局区）和PGA（程序全局区）的大小，从而简化了数据库管理员的工作。 3. **In-Memory Option**：Oracle In-Memory Option提供了高速数据查询，通过将数据的一部分以列存储的方式加载到内存中，显著提升分析查询的性能。 4. **Real Application Clusters (RAC)**：在12c版本中，RAC得到了进一步优化，提供了更高的可用性和容错性，允许多个节点共享同一个数据库，确保在硬件故障时服务不中断。 5. **PL/SQL增强**：PL/SQL编程语言在12c中得到升级，增加了新特性如匿名块的调试、类型安全的游标变量和并行执行支持，使得开发更高效。 6. **SQL增强**：SQL语法也有所改进，如窗口函数的扩展，以及新的聚合函数，如LEAD()和LAG()，用于更复杂的查询和数据分析。 7. **Security增强**：12c提供了更强的数据安全性，包括精细的行级安全、透明数据加密和身份验证机制的改进。 8. **Backup and Recovery**：备份和恢复策略在12c中得到优化，包括更快的数据恢复选项，如RMAN（Recovery Manager）的增强和闪回技术的改进。 9. **Data Guard**：Oracle Data Guard提供高可用性和灾难恢复解决方案，12c版本中加强了与RAC的集成，以及在不影响主数据库的情况下进行物理和逻辑Standby数据库的维护。 10. **Performance and Tuning**：Oracle 12c包含了多种性能监控和调优工具，如Automatic Workload Repository (AWR)、ASH (Active Session History) 和 SQL Performance Analyzer，帮助管理员识别和解决性能瓶颈。以上只是Oracle Database 12c Release 1中部分重要知识点的概述。实际的参考文档会包含更多详细信息，包括配置、操作、故障排除和最佳实践等内容，是Oracle数据库管理员和开发者的必备参考资料。

3.31 ALL_RULE_SET_RULES............................................................................................................. 3-37

3.32 ALL_RULE_SETS.......................................................................................................................... 3-37

3.33 ALL_RULES................................................................................................................................... 3-38

3.34 ALL_SCHEDULER_CHAIN_RULES ........................................................................................ 3-39

3.35 ALL_SCHEDULER_CHAIN_STEPS ......................................................................................... 3-39

3.36 ALL_SCHEDULER_CHAINS..................................................................................................... 3-41

3.37 ALL_SCHEDULER_CREDENTIALS......................................................................................... 3-42

3.38 ALL_SCHEDULER_DB_DESTS ................................................................................................. 3-43

3.39 ALL_SCHEDULER_DESTS......................................................................................................... 3-43

3.40 ALL_SCHEDULER_EXTERNAL_DESTS ................................................................................. 3-44

3.41 ALL_SCHEDULER_FILE_WATCHERS ................................................................................... 3-45

3.42 ALL_SCHEDULER_GLOBAL_ATTRIBUTE............................................................................ 3-46

3.43 ALL_SCHEDULER_GROUP_MEMBERS................................................................................. 3-46

3.44 ALL_SCHEDULER_GROUPS .................................................................................................... 3-47

3.45 ALL_SCHEDULER_JOB_ARGS................................................................................................. 3-48

3.46 ALL_SCHEDULER_JOB_CLASSES........................................................................................... 3-48

3.47 ALL_SCHEDULER_JOB_DESTS................................................................................................ 3-49

3.48 ALL_SCHEDULER_JOB_LOG ................................................................................................... 3-51

3.49 ALL_SCHEDULER_JOB_RUN_DETAILS................................................................................ 3-53

3.50 ALL_SCHEDULER_JOBS............................................................................................................ 3-54

3.51 ALL_SCHEDULER_NOTIFICATIONS..................................................................................... 3-59

3.52 ALL_SCHEDULER_PROGRAM_ARGS ................................................................................... 3-60

3.53 ALL_SCHEDULER_PROGRAMS.............................................................................................. 3-61

3.54 ALL_SCHEDULER_REMOTE_DATABASES.......................................................................... 3-62

3.55 ALL_SCHEDULER_REMOTE_JOBSTATE .............................................................................. 3-63

3.56 ALL_SCHEDULER_RUNNING_CHAINS............................................................................... 3-64

3.57 ALL_SCHEDULER_RUNNING_JOBS...................................................................................... 3-66

3.58 ALL_SCHEDULER_SCHEDULES............................................................................................. 3-67

3.59 ALL_SCHEDULER_WINDOW_DETAILS............................................................................... 3-68

3.60 ALL_SCHEDULER_WINDOW_GROUPS ............................................................................... 3-69

3.61 ALL_SCHEDULER_WINDOW_LOG ....................................................................................... 3-70

3.62 ALL_SCHEDULER_WINDOWS................................................................................................ 3-70

3.63 ALL_SCHEDULER_WINGROUP_MEMBERS ........................................................................ 3-72

3.64 ALL_SEC_RELEVANT_COLS.................................................................................................... 3-72

3.65 ALL_SECONDARY_OBJECTS ................................................................................................... 3-73

3.66 ALL_SEQUENCES ....................................................................................................................... 3-74

3.67 ALL_SERVICES ............................................................................................................................ 3-75

3.68 ALL_SOURCE............................................................................................................................... 3-78

3.69 ALL_SOURCE_AE ....................................................................................................................... 3-78

3.70 ALL_SQL_TRANSLATION_PROFILES ................................................................................... 3-79

3.71 ALL_SQL_TRANSLATIONS ...................................................................................................... 3-80

3.72 ALL_SQLJ_TYPE_ATTRS............................................................................................................ 3-81

3.73 ALL_SQLJ_TYPE_METHODS.................................................................................................... 3-82

xvi

3.74 ALL_SQLJ_TYPES ........................................................................................................................ 3-83

3.75 ALL_SQLSET................................................................................................................................. 3-85

3.76 ALL_SQLSET_BINDS .................................................................................................................. 3-85

3.77 ALL_SQLSET_PLANS ................................................................................................................. 3-86

3.78 ALL_SQLSET_REFERENCES ..................................................................................................... 3-91

3.79 ALL_SQLSET_STATEMENTS.................................................................................................... 3-92

3.80 ALL_STAT_EXTENSIONS.......................................................................................................... 3-94

3.81 ALL_STORED_SETTINGS .......................................................................................................... 3-95

3.82 ALL_STREAMS_COLUMNS...................................................................................................... 3-96

3.83 ALL_STREAMS_GLOBAL_RULES ........................................................................................... 3-97

3.84 ALL_STREAMS_MESSAGE_CONSUMERS ............................................................................ 3-98

3.85 ALL_STREAMS_MESSAGE_RULES......................................................................................... 3-99

3.86 ALL_STREAMS_NEWLY_SUPPORTED.................................................................................. 3-99

3.87 ALL_STREAMS_RULES............................................................................................................ 3-100

3.88 ALL_STREAMS_SCHEMA_RULES ........................................................................................ 3-102

3.89 ALL_STREAMS_TABLE_RULES............................................................................................. 3-103

3.90 ALL_STREAMS_TRANSFORM_FUNCTION ....................................................................... 3-105

3.91 ALL_STREAMS_UNSUPPORTED .......................................................................................... 3-105

3.92 ALL_SUBPART_COL_STATISTICS ........................................................................................ 3-106

3.93 ALL_SUBPART_HISTOGRAMS.............................................................................................. 3-108

3.94 ALL_SUBPART_KEY_COLUMNS .......................................................................................... 3-109

3.95 ALL_SUBPARTITION_TEMPLATES...................................................................................... 3-109

3.96 ALL_SUMDELTA....................................................................................................................... 3-110

3.97 ALL_SYNC_CAPTURE ............................................................................................................. 3-111

3.98 ALL_SYNC_CAPTURE_PREPARED_TABS.......................................................................... 3-111

3.99 ALL_SYNC_CAPTURE_TABLES ............................................................................................ 3-112

3.100 ALL_SYNONYMS .................................................................................................................... 3-112

3.101 ALL_TAB_COL_STATISTICS................................................................................................. 3-114

3.102 ALL_TAB_COLS....................................................................................................................... 3-115

3.103 ALL_TAB_COLUMNS............................................................................................................. 3-119

3.104 ALL_TAB_COMMENTS ......................................................................................................... 3-122

3.105 ALL_TAB_HISTGRM_PENDING_STATS ........................................................................... 3-122

3.106 ALL_TAB_HISTOGRAMS ...................................................................................................... 3-123

3.107 ALL_TAB_IDENTITY_COLS.................................................................................................. 3-124

3.108 ALL_TAB_MODIFICATIONS ................................................................................................ 3-125

3.109 ALL_TAB_PARTITIONS......................................................................................................... 3-126

3.110 ALL_TAB_PENDING_STATS ................................................................................................ 3-132

3.111 ALL_TAB_PRIVS...................................................................................................................... 3-133

3.112 ALL_TAB_PRIVS_MADE ....................................................................................................... 3-134

3.113 ALL_TAB_PRIVS_RECD......................................................................................................... 3-135

3.114 ALL_TAB_STAT_PREFS ......................................................................................................... 3-136

3.115 ALL_TAB_STATISTICS........................................................................................................... 3-136

3.116 ALL_TAB_STATS_HISTORY ................................................................................................. 3-138

xvii

3.117 ALL_TAB_SUBPARTITIONS ................................................................................................. 3-139

3.118 ALL_TABLES ............................................................................................................................ 3-143

3.119 ALL_TRANSFORMATIONS .................................................................................................. 3-149

3.120 ALL_TRIGGER_COLS ............................................................................................................. 3-150

3.121 ALL_TRIGGER_ORDERING.................................................................................................. 3-151

3.122 ALL_TRIGGERS........................................................................................................................ 3-152

3.123 ALL_TSTZ_TAB_COLS ........................................................................................................... 3-154

3.124 ALL_TSTZ_TABLES................................................................................................................. 3-155

3.125 ALL_TYPE_ATTRS................................................................................................................... 3-155

3.126 ALL_TYPE_METHODS........................................................................................................... 3-156

3.127 ALL_TYPE_VERSIONS ........................................................................................................... 3-157

3.128 ALL_TYPES ............................................................................................................................... 3-158

3.129 ALL_UNUSED_COL_TABS.................................................................................................... 3-159

3.130 ALL_UPDATABLE_COLUMNS............................................................................................ 3-160

3.131 ALL_USERS............................................................................................................................... 3-160

3.132 ALL_USTATS............................................................................................................................ 3-161

3.133 ALL_VARRAYS ........................................................................................................................ 3-162

3.134 ALL_VIEWS............................................................................................................................... 3-163

3.135 ALL_VIEWS_AE....................................................................................................................... 3-164

3.136 ALL_WARNING_SETTINGS ................................................................................................. 3-166

3.137 ALL_XML_INDEXES............................................................................................................... 3-167

3.138 ALL_XML_NESTED_TABLES................................................................................................ 3-168

3.139 ALL_XML_OUT_OF_LINE_TABLES.................................................................................... 3-168

3.140 ALL_XML_SCHEMA_ATTRIBUTES .................................................................................... 3-169

3.141 ALL_XML_SCHEMA_COMPLEX_TYPES........................................................................... 3-170

3.142 ALL_XML_SCHEMA_ELEMENTS ....................................................................................... 3-171

3.143 ALL_XML_SCHEMA_NAMESPACES ................................................................................. 3-172

3.144 ALL_XML_SCHEMA_SIMPLE_TYPES ................................................................................ 3-172

3.145 ALL_XML_SCHEMA_SUBSTGRP_HEAD .......................................................................... 3-173

3.146 ALL_XML_SCHEMA_SUBSTGRP_MBRS ........................................................................... 3-174

3.147 ALL_XML_SCHEMAS............................................................................................................. 3-175

3.148 ALL_XML_TAB_COLS............................................................................................................ 3-176

3.149 ALL_XML_TABLES ................................................................................................................. 3-177

3.150 ALL_XML_VIEW_COLS ......................................................................................................... 3-178

3.151 ALL_XML_VIEWS.................................................................................................................... 3-178

3.152 ALL_XSTREAM_ADMINISTRATOR ................................................................................... 3-179

3.153 ALL_XSTREAM_INBOUND .................................................................................................. 3-180

3.154 ALL_XSTREAM_INBOUND_PROGRESS............................................................................ 3-181

3.155 ALL_XSTREAM_OUT_SUPPORT_MODE........................................................................... 3-182

3.156 ALL_XSTREAM_OUTBOUND .............................................................................................. 3-183

3.157 ALL_XSTREAM_OUTBOUND_PROGRESS........................................................................ 3-184

3.158 ALL_XSTREAM_RULES ......................................................................................................... 3-185

3.159 ALL_XSTREAM_TRANSFORMATIONS ............................................................................. 3-186

xviii

3.160 ALL_ZONEMAP_MEASURES............................................................................................... 3-188

3.161 ALL_ZONEMAPS .................................................................................................................... 3-189

3.162 AUDIT_ACTIONS.................................................................................................................... 3-190

3.163 AUDIT_UNIFIED_CONTEXTS.............................................................................................. 3-191

3.164 AUDIT_UNIFIED_ENABLED_POLICIES............................................................................ 3-192

3.165 AUDIT_UNIFIED_POLICIES ................................................................................................. 3-192

3.166 AUDIT_UNIFIED_POLICY_COMMENTS........................................................................... 3-193

3.167 AUDITABLE_SYSTEM_ACTIONS........................................................................................ 3-194

3.168 CAT............................................................................................................................................. 3-195

3.169 CATALOG ................................................................................................................................. 3-195

3.170 CHAINED_ROWS.................................................................................................................... 3-195

3.171 CLIENT_RESULT_CACHE_STATS$ .................................................................................... 3-195

3.172 CLU............................................................................................................................................. 3-196

3.173 COL............................................................................................................................................. 3-196

3.174 COLS........................................................................................................................................... 3-196

3.175 DATABASE_EXPORT_OBJECTS........................................................................................... 3-197

3.176 DATABASE_PROPERTIES ..................................................................................................... 3-197

4 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to

DBA_HIST_JAVA_POOL_ADVICE

4.1 DBA_2PC_NEIGHBORS.................................................................................................................. 4-1

4.2 DBA_2PC_PENDING ...................................................................................................................... 4-1

4.3 DBA_ACL_NAME_MAP ................................................................................................................ 4-2

4.4 DBA_ADDM_FDG_BREAKDOWN .............................................................................................. 4-2

4.5 DBA_ADDM_FINDINGS................................................................................................................ 4-3

4.6 DBA_ADDM_INSTANCES............................................................................................................. 4-5

4.7 DBA_ADDM_SYSTEM_DIRECTIVES .......................................................................................... 4-6

4.8 DBA_ADDM_TASK_DIRECTIVES ............................................................................................... 4-6

4.9 DBA_ADDM_TASKS....................................................................................................................... 4-7

4.10 DBA_ADVISOR_ACTIONS........................................................................................................ 4-10

4.11 DBA_ADVISOR_COMMANDS ................................................................................................. 4-11

4.12 DBA_ADVISOR_DEF_PARAMETERS ..................................................................................... 4-12

4.13 DBA_ADVISOR_DEFINITIONS ................................................................................................ 4-13

4.14 DBA_ADVISOR_DIR_DEFINITIONS ....................................................................................... 4-13

4.15 DBA_ADVISOR_DIR_INSTANCES .......................................................................................... 4-14

4.16 DBA_ADVISOR_DIR_TASK_INST ........................................................................................... 4-14

4.17 DBA_ADVISOR_EXEC_PARAMETERS................................................................................... 4-15

4.18 DBA_ADVISOR_EXECUTION_TYPES .................................................................................... 4-16

4.19 DBA_ADVISOR_EXECUTIONS ................................................................................................ 4-16

4.20 DBA_ADVISOR_FDG_BREAKDOWN..................................................................................... 4-18

4.21 DBA_ADVISOR_FINDING_NAMES........................................................................................ 4-18

4.22 DBA_ADVISOR_FINDINGS ...................................................................................................... 4-18

4.23 DBA_ADVISOR_JOURNAL ....................................................................................................... 4-20

xix

4.24 DBA_ADVISOR_LOG.................................................................................................................. 4-20

4.25 DBA_ADVISOR_OBJECT_TYPES.............................................................................................. 4-21

4.26 DBA_ADVISOR_OBJECTS.......................................................................................................... 4-22

4.27 DBA_ADVISOR_PARAMETERS ............................................................................................... 4-24

4.28 DBA_ADVISOR_RATIONALE .................................................................................................. 4-25

4.29 DBA_ADVISOR_RECOMMENDATIONS ............................................................................... 4-27

4.30 DBA_ADVISOR_SQLA_REC_SUM........................................................................................... 4-28

4.31 DBA_ADVISOR_SQLA_TABLES .............................................................................................. 4-29

4.32 DBA_ADVISOR_SQLA_WK_MAP ........................................................................................... 4-30

4.33 DBA_ADVISOR_SQLA_WK_STMTS........................................................................................ 4-30

4.34 DBA_ADVISOR_SQLPLANS ..................................................................................................... 4-32

4.35 DBA_ADVISOR_SQLSTATS ...................................................................................................... 4-35

4.36 DBA_ADVISOR_SQLW_JOURNAL ......................................................................................... 4-37

4.37 DBA_ADVISOR_SQLW_PARAMETERS ................................................................................. 4-38

4.38 DBA_ADVISOR_SQLW_STMTS................................................................................................ 4-39

4.39 DBA_ADVISOR_SQLW_SUM.................................................................................................... 4-41

4.40 DBA_ADVISOR_SQLW_TABLES.............................................................................................. 4-41

4.41 DBA_ADVISOR_SQLW_TEMPLATES..................................................................................... 4-42

4.42 DBA_ADVISOR_TASKS.............................................................................................................. 4-43

4.43 DBA_ADVISOR_TEMPLATES................................................................................................... 4-45

4.44 DBA_ADVISOR_USAGE ............................................................................................................ 4-45

4.45 DBA_ALERT_HISTORY.............................................................................................................. 4-46

4.46 DBA_ALERT_HISTORY_DETAIL............................................................................................. 4-47

4.47 DBA_ALL_TABLES...................................................................................................................... 4-49

4.48 DBA_APPLICATION_ROLES.................................................................................................... 4-49

4.49 DBA_APPLY.................................................................................................................................. 4-49

4.50 DBA_APPLY_CHANGE_HANDLERS..................................................................................... 4-49

4.51 DBA_APPLY_CONFLICT_COLUMNS .................................................................................... 4-50

4.52 DBA_APPLY_DML_HANDLERS.............................................................................................. 4-50

4.53 DBA_APPLY_ENQUEUE............................................................................................................ 4-50

4.54 DBA_APPLY_ERROR.................................................................................................................. 4-50

4.55 DBA_APPLY_ERROR_MESSAGES........................................................................................... 4-50

4.56 DBA_APPLY_EXECUTE ............................................................................................................. 4-51

4.57 DBA_APPLY_INSTANTIATED_GLOBAL .............................................................................. 4-51

4.58 DBA_APPLY_INSTANTIATED_OBJECTS .............................................................................. 4-51

4.59 DBA_APPLY_INSTANTIATED_SCHEMAS ........................................................................... 4-51

4.60 DBA_APPLY_KEY_COLUMNS................................................................................................. 4-52

4.61 DBA_APPLY_OBJECT_DEPENDENCIES................................................................................ 4-52

4.62 DBA_APPLY_PARAMETERS .................................................................................................... 4-52

4.63 DBA_APPLY_PROGRESS........................................................................................................... 4-52

4.64 DBA_APPLY_SPILL_TXN .......................................................................................................... 4-53

4.65 DBA_APPLY_TABLE_COLUMNS............................................................................................ 4-53

4.66 DBA_APPLY_VALUE_DEPENDENCIES ................................................................................ 4-53

剩余2203页未读，继续阅读

yjb.gz

粉丝: 59
资源: 23

Oracle Database 12c Release 1官方参考手册

Oracle 12c

Oracle SQL for Database 12c

Oracle Database 12c The Complete Reference

Oracle Database PLSQL Packages and Types Reference 12c

Oracle 12c_Administrator’s Reference

oracle-sql.pdf

oracle数据字典各字段解析.pdf

Oracle Certified Professional 063 - Multitenant .docx

[手工整理]208个Oracle安装文档，包含各个平台各个版本的单实例RAC以及DataGuard(1).xlsx

Oracle数据库数据字典字段详析：官方12c Release 2（12.2）详解

最新资源