Oracle Database 11g Release 2官方参考手册

oracle

需积分: 5 84 浏览量更新于2024-06-25 收藏 8.63MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

"Oracle Database Reference 11g Release 2 (11.2)-1306 是Oracle公司发布的一本官方技术文档，主要针对Oracle数据库11g第二版（11.2）提供详细的技术参考。这本书由众多Oracle专家共同编写，涵盖了从基本概念到高级特性的全面信息，旨在帮助数据库管理员、开发人员和其他IT专业人士理解和操作Oracle 11g数据库系统。" 在Oracle Database Reference 11g Release 2中，你将找到以下关键知识点： 1. **SQL语法与功能**：包括数据查询语言（DQL）、数据操纵语言（DML）、数据定义语言（DDL）和数据控制语言（DCL）的详细说明，以及PL/SQL编程支持。 2. **数据库管理**：涵盖创建、配置、监控和优化数据库的各个方面，如数据库实例管理、表空间、数据文件、控制文件、重做日志、回滚段等。 3. **安全性**：讨论用户管理和权限控制，如角色、权限、加密、审计和网络安全设置。 4. **存储结构**：深入解析Oracle的行和块结构，包括索引、簇、位图索引、分区和分片等高级特性。 5. **备份与恢复**：介绍Oracle RMAN（恢复管理器）和其他备份工具，以及如何执行数据库恢复策略。 6. **性能优化**：包括SQL优化、统计信息、数据库分析工具（如AWR和ASH报告）、数据库调优顾问（DBTA）以及PGA和SGA内存管理。 7. **并行执行**：阐述并行查询和并行服务器的概念，以及如何利用并行处理提高性能。 8. **数据仓库和OLAP**：涵盖Oracle的数据仓库特性，如星型模式、雪花模式，以及联接聚合和物化视图。 9. **集群和高可用性**：讨论RAC（Real Application Clusters）技术，以及故障检测和故障转移机制。 10. **网络和连接**：讲解Oracle Net Services，包括监听器、TNS（Transparent Network Substrate）配置和网络连接问题排查。 11. **数据库云服务**：虽然11g可能不直接涉及云服务，但Oracle后续版本增加了对云环境的支持，这部分可以参考后续版本的文档。 12. **XML支持**：Oracle数据库对XML数据的存储和处理，包括XMLType和XMLDB。 13. **数据泵（Data Pump）**：用于快速导入和导出数据的工具，包括EXPDP和IMPDP。 14. **存储过程和函数**：PL/SQL编程语言的使用，包括包、游标、异常处理和触发器。 15. **调度与作业**：DBMS_JOB和DBMS_SCHEDULER等模块，用于自动化数据库任务。这本参考手册是Oracle数据库管理员和开发者的必备工具，它提供了详尽的技术细节，帮助解决实际问题，并推动数据库系统的高效运行。无论是初学者还是经验丰富的专业人士，都能从中获益匪浅。

资源详情

资源推荐

xvi

ALL_TSTZ_TABLES............................................................................................................................. 3-99

ALL_TYPE_ATTRS............................................................................................................................... 3-99

ALL_TYPE_METHODS ..................................................................................................................... 3-100

ALL_TYPE_VERSIONS ..................................................................................................................... 3-101

ALL_TYPES .......................................................................................................................................... 3-102

ALL_UNUSED_COL_TABS.............................................................................................................. 3-102

ALL_UPDATABLE_COLUMNS ...................................................................................................... 3-103

ALL_USERS.......................................................................................................................................... 3-103

ALL_USTATS ...................................................................................................................................... 3-104

ALL_VARRAYS................................................................................................................................... 3-104

ALL_VIEWS ......................................................................................................................................... 3-105

ALL_VIEWS_AE.................................................................................................................................. 3-106

ALL_WARNING_SETTINGS .......................................................................................................... 3-106

ALL_XML_INDEXES.......................................................................................................................... 3-107

ALL_XML_SCHEMAS ....................................................................................................................... 3-108

ALL_XML_TAB_COLS ...................................................................................................................... 3-109

ALL_XML_TABLES ............................................................................................................................ 3-110

ALL_XML_VIEW_COLS.................................................................................................................... 3-110

ALL_XML_VIEWS .............................................................................................................................. 3-111

ALL_XSTREAM_INBOUND ............................................................................................................ 3-111

ALL_XSTREAM_INBOUND_PROGRESS.................................................................................... 3-112

ALL_XSTREAM_OUTBOUND........................................................................................................ 3-113

ALL_XSTREAM_OUTBOUND_PROGRESS................................................................................ 3-114

ALL_XSTREAM_RULES ................................................................................................................... 3-114

AUDIT_ACTIONS.............................................................................................................................. 3-115

CAT ........................................................................................................................................................ 3-115

CATALOG............................................................................................................................................ 3-115

CHAINED_ROWS .............................................................................................................................. 3-116

CHANGE_PROPAGATION_SETS................................................................................................. 3-116

CHANGE_PROPAGATIONS .......................................................................................................... 3-116

CHANGE_SETS .................................................................................................................................. 3-116

CHANGE_SOURCES......................................................................................................................... 3-116

CHANGE_TABLES............................................................................................................................. 3-116

CLIENT_RESULT_CACHE_STATS$.............................................................................................. 3-116

CLU ........................................................................................................................................................ 3-117

COL ........................................................................................................................................................ 3-117

COLS...................................................................................................................................................... 3-117

DATABASE_PROPERTIES .............................................................................................................. 3-117

4 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_

POOL_ADVICE

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

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

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

DBA_ADDM_FINDINGS...................................................................................................................... 4-2

DBA_ADDM_INSTANCES................................................................................................................... 4-3

DBA_ADDM_SYSTEM_DIRECTIVES............................................................................................... 4-4

xvii

DBA_ADDM_TASK_DIRECTIVES .................................................................................................... 4-4

DBA_ADDM_TASKS ............................................................................................................................. 4-5

DBA_ADVISOR_ACTIONS.................................................................................................................. 4-7

DBA_ADVISOR_COMMANDS........................................................................................................... 4-8

DBA_ADVISOR_DEF_PARAMETERS............................................................................................... 4-8

DBA_ADVISOR_DEFINITIONS ......................................................................................................... 4-9

DBA_ADVISOR_DIR_DEFINITIONS ............................................................................................... 4-9

DBA_ADVISOR_DIR_INSTANCES ................................................................................................ 4-10

DBA_ADVISOR_DIR_TASK_INST................................................................................................. 4-10

DBA_ADVISOR_EXEC_PARAMETERS ......................................................................................... 4-11

DBA_ADVISOR_EXECUTION_TYPES........................................................................................... 4-12

DBA_ADVISOR_EXECUTIONS ....................................................................................................... 4-12

DBA_ADVISOR_FDG_BREAKDOWN........................................................................................... 4-13

DBA_ADVISOR_FINDING_NAMES.............................................................................................. 4-13

DBA_ADVISOR_FINDINGS............................................................................................................. 4-13

DBA_ADVISOR_JOURNAL .............................................................................................................. 4-14

DBA_ADVISOR_LOG......................................................................................................................... 4-15

DBA_ADVISOR_OBJECT_TYPES.................................................................................................... 4-15

DBA_ADVISOR_OBJECTS ................................................................................................................ 4-16

DBA_ADVISOR_PARAMETERS...................................................................................................... 4-17

DBA_ADVISOR_RATIONALE ......................................................................................................... 4-18

DBA_ADVISOR_RECOMMENDATIONS..................................................................................... 4-19

DBA_ADVISOR_SQLA_REC_SUM................................................................................................. 4-20

DBA_ADVISOR_SQLA_TABLES..................................................................................................... 4-21

DBA_ADVISOR_SQLA_WK_MAP.................................................................................................. 4-21

DBA_ADVISOR_SQLA_WK_STMTS ............................................................................................. 4-21

DBA_ADVISOR_SQLPLANS............................................................................................................ 4-23

DBA_ADVISOR_SQLSTATS ............................................................................................................ 4-25

DBA_ADVISOR_SQLW_JOURNAL................................................................................................ 4-26

DBA_ADVISOR_SQLW_PARAMETERS ....................................................................................... 4-27

DBA_ADVISOR_SQLW_STMTS...................................................................................................... 4-27

DBA_ADVISOR_SQLW_SUM .......................................................................................................... 4-28

DBA_ADVISOR_SQLW_TABLES.................................................................................................... 4-29

DBA_ADVISOR_SQLW_TEMPLATES

........................................................................................... 4-29

DBA_ADVISOR_TASKS .................................................................................................................... 4-30

DBA_ADVISOR_TEMPLATES ......................................................................................................... 4-31

DBA_ADVISOR_USAGE.................................................................................................................... 4-32

DBA_ALERT_HISTORY ..................................................................................................................... 4-32

DBA_ALL_TABLES .............................................................................................................................. 4-33

DBA_APPLICATION_ROLES ........................................................................................................... 4-33

DBA_APPLY........................................................................................................................................... 4-33

DBA_APPLY_CHANGE_HANDLERS............................................................................................. 4-33

DBA_APPLY_CONFLICT_COLUMNS............................................................................................ 4-33

DBA_APPLY_DML_HANDLERS...................................................................................................... 4-34

DBA_APPLY_ENQUEUE .................................................................................................................... 4-34

DBA_APPLY_ERROR .......................................................................................................................... 4-35

DBA_APPLY_ERROR_MESSAGES.................................................................................................. 4-36

xviii

DBA_APPLY_EXECUTE...................................................................................................................... 4-36

DBA_APPLY_INSTANTIATED_GLOBAL ..................................................................................... 4-36

DBA_APPLY_INSTANTIATED_OBJECTS .................................................................................... 4-37

DBA_APPLY_INSTANTIATED_SCHEMAS.................................................................................. 4-37

DBA_APPLY_KEY_COLUMNS......................................................................................................... 4-37

DBA_APPLY_OBJECT_DEPENDENCIES....................................................................................... 4-37

DBA_APPLY_PARAMETERS ............................................................................................................ 4-38

DBA_APPLY_PROGRESS .................................................................................................................. 4-38

DBA_APPLY_SPILL_TXN................................................................................................................... 4-38

DBA_APPLY_TABLE_COLUMNS.................................................................................................... 4-38

DBA_APPLY_VALUE_DEPENDENCIES........................................................................................ 4-39

DBA_AQ_AGENT_PRIVS .................................................................................................................. 4-39

DBA_AQ_AGENTS .............................................................................................................................. 4-39

DBA_ARGUMENTS ............................................................................................................................ 4-39

DBA_ASSEMBLIES.............................................................................................................................. 4-40

DBA_ASSOCIATIONS........................................................................................................................ 4-40

DBA_ATTRIBUTE_TRANSFORMATIONS................................................................................... 4-40

DBA_AUDIT_EXISTS.......................................................................................................................... 4-40

DBA_AUDIT_MGMT_CLEAN_EVENTS ....................................................................................... 4-42

DBA_AUDIT_MGMT_CLEANUP_JOBS ........................................................................................ 4-42

DBA_AUDIT_MGMT_CONFIG_PARAMS ................................................................................... 4-42

DBA_AUDIT_MGMT_LAST_ARCH_TS ........................................................................................ 4-43

DBA_AUDIT_OBJECT ........................................................................................................................ 4-43

DBA_AUDIT_POLICIES..................................................................................................................... 4-45

DBA_AUDIT_POLICY_COLUMNS ................................................................................................. 4-45

DBA_AUDIT_SESSION...................................................................................................................... 4-45

DBA_AUDIT_STATEMENT .............................................................................................................. 4-46

DBA_AUDIT_TRAIL ........................................................................................................................... 4-47

DBA_AUTO_SEGADV_CTL.............................................................................................................. 4-49

DBA_AUTO_SEGADV_SUMMARY................................................................................................ 4-50

DBA_AUTOTASK_CLIENT............................................................................................................... 4-50

DBA_AUTOTASK_CLIENT_HISTORY.......................................................................................... 4-51

DBA_AUTOTASK_CLIENT_JOB ..................................................................................................... 4-52

DBA_AUTOTASK_JOB_HISTORY.................................................................................................. 4-52

DBA_AUTOTASK_OPERATION ..................................................................................................... 4-53

DBA_AUTOTASK_SCHEDULE........................................................................................................ 4-53

DBA_AUTOTASK_TASK................................................................................................................... 4-53

DBA_AUTOTASK_WINDOW_CLIENTS ....................................................................................... 4-56

DBA_AUTOTASK_WINDOW_HISTORY...................................................................................... 4-57

DBA_AW_PS.......................................................................................................................................... 4-57

DBA_AWS .............................................................................................................................................. 4-57

DBA_BASE_TABLE_MVIEWS .......................................................................................................... 4-57

DBA_BLOCKERS.................................................................................................................................. 4-57

DBA_CAPTURE .................................................................................................................................... 4-58

DBA_CAPTURE_EXTRA_ATTRIBUTES ........................................................................................ 4-58

DBA_CAPTURE_PARAMETERS...................................................................................................... 4-58

DBA_CAPTURE_PREPARED_DATABASE ................................................................................... 4-58

xix

DBA_CAPTURE_PREPARED_SCHEMAS...................................................................................... 4-58

DBA_CAPTURE_PREPARED_TABLES .......................................................................................... 4-58

DBA_CATALOG................................................................................................................................... 4-59

DBA_CHANGE_NOTIFICATION_REGS....................................................................................... 4-59

DBA_CLU_COLUMNS........................................................................................................................ 4-59

DBA_CLUSTER_HASH_EXPRESSIONS ........................................................................................ 4-60

DBA_CLUSTERS .................................................................................................................................. 4-60

DBA_COL_COMMENTS .................................................................................................................... 4-60

DBA_COL_PENDING_STATS.......................................................................................................... 4-60

DBA_COL_PRIVS................................................................................................................................. 4-60

DBA_COLL_TYPES.............................................................................................................................. 4-60

DBA_COMMON_AUDIT_TRAIL .................................................................................................... 4-61

DBA_COMPARISON .......................................................................................................................... 4-63

DBA_COMPARISON_COLUMNS................................................................................................... 4-64

DBA_COMPARISON_ROW_DIF ..................................................................................................... 4-64

DBA_COMPARISON_SCAN............................................................................................................. 4-64

DBA_COMPARISON_SCAN_VALUES .......................................................................................... 4-65

DBA_CONNECT_ROLE_GRANTEES ............................................................................................. 4-65

DBA_CONS_OBJ_COLUMNS........................................................................................................... 4-66

DBA_CONSTRAINTS ......................................................................................................................... 4-66

DBA_CONTEXT.................................................................................................................................... 4-66

DBA_CPOOL_INFO............................................................................................................................. 4-66

DBA_CPU_USAGE_STATISTICS .................................................................................................... 4-67

DBA_CQ_NOTIFICATION_QUERIES............................................................................................ 4-67

DBA_CUBE_ATTR_VISIBILITY ....................................................................................................... 4-67

DBA_CUBE_ATTRIBUTES ................................................................................................................ 4-67

DBA_CUBE_BUILD_PROCESSES.................................................................................................... 4-68

DBA_CUBE_CALCULATED_MEMBERS ....................................................................................... 4-68

DBA_CUBE_DIM_LEVELS ................................................................................................................ 4-68

DBA_CUBE_DIM_MODELS.............................................................................................................. 4-68

DBA_CUBE_DIM_VIEW_COLUMNS ............................................................................................. 4-68

DBA_CUBE_DIM_VIEWS ..................................................................................................................

4-68

DBA_CUBE_DIMENSIONALITY..................................................................................................... 4-68

DBA_CUBE_DIMENSIONS............................................................................................................... 4-68

DBA_CUBE_HIER_LEVELS ............................................................................................................... 4-69

DBA_CUBE_HIER_VIEW_COLUMNS............................................................................................ 4-69

DBA_CUBE_HIER_VIEWS................................................................................................................. 4-69

DBA_CUBE_HIERARCHIES.............................................................................................................. 4-69

DBA_CUBE_MEASURES.................................................................................................................... 4-69

DBA_CUBE_VIEW_COLUMNS ........................................................................................................ 4-69

DBA_CUBE_VIEWS ............................................................................................................................. 4-69

DBA_CUBES .......................................................................................................................................... 4-70

DBA_DATA_FILES .............................................................................................................................. 4-70

DBA_DATAPUMP_JOBS.................................................................................................................... 4-70

DBA_DATAPUMP_SESSIONS ......................................................................................................... 4-71

DBA_DB_LINKS................................................................................................................................... 4-71

DBA_DDL_LOCKS .............................................................................................................................. 4-71

DBA_DEPENDENCIES ....................................................................................................................... 4-72

DBA_DIM_ATTRIBUTES................................................................................................................... 4-72

DBA_DIM_CHILD_OF........................................................................................................................ 4-72

DBA_DIM_HIERARCHIES ................................................................................................................ 4-72

DBA_DIM_JOIN_KEY......................................................................................................................... 4-72

DBA_DIM_LEVEL_KEY...................................................................................................................... 4-73

DBA_DIM_LEVELS.............................................................................................................................. 4-73

DBA_DIMENSIONS ............................................................................................................................ 4-73

DBA_DIRECTORIES ........................................................................................................................... 4-73

DBA_DML_LOCKS.............................................................................................................................. 4-73

DBA_DMT_FREE_SPACE .................................................................................................................. 4-74

DBA_DMT_USED_EXTENTS............................................................................................................ 4-74

DBA_EDITION_COMMENTS .......................................................................................................... 4-74

DBA_EDITIONING_VIEW_COLS ................................................................................................... 4-74

DBA_EDITIONING_VIEW_COLS_AE............................................................................................ 4-74

DBA_EDITIONING_VIEWS.............................................................................................................. 4-74

DBA_EDITIONING_VIEWS_AE ...................................................................................................... 4-75

DBA_EDITIONS ................................................................................................................................... 4-75

DBA_ENABLED_AGGREGATIONS ............................................................................................... 4-75

DBA_ENABLED_TRACES.................................................................................................................. 4-75

DBA_ENCRYPTED_COLUMNS ....................................................................................................... 4-76

DBA_EPG_DAD_AUTHORIZATION ............................................................................................. 4-76

DBA_ERRORS....................................................................................................................................... 4-76

DBA_ERRORS_AE ............................................................................................................................... 4-76

DBA_EVALUATION_CONTEXT_TABLES.................................................................................... 4-76

DBA_EVALUATION_CONTEXT_VARS........................................................................................ 4-77

DBA_EVALUATION_CONTEXTS ................................................................................................... 4-77

DBA_EXP_FILES ................................................................................................................................... 4-77

DBA_EXP_OBJECTS ............................................................................................................................ 4-77

DBA_EXP_VERSION ........................................................................................................................... 4-77

DBA_EXTENTS ..................................................................................................................................... 4-77

DBA_EXTERNAL_LOCATIONS

....................................................................................................... 4-78

DBA_EXTERNAL_TABLES................................................................................................................ 4-78

DBA_FEATURE_USAGE_STATISTICS .......................................................................................... 4-78

DBA_FGA_AUDIT_TRAIL................................................................................................................. 4-79

DBA_FILE_GROUP_EXPORT_INFO ............................................................................................... 4-80

DBA_FILE_GROUP_FILES................................................................................................................. 4-80

DBA_FILE_GROUP_TABLES ............................................................................................................ 4-80

DBA_FILE_GROUP_TABLESPACES............................................................................................... 4-80

DBA_FILE_GROUP_VERSIONS ...................................................................................................... 4-81

DBA_FILE_GROUPS............................................................................................................................ 4-81

DBA_FLASHBACK_ARCHIVE ......................................................................................................... 4-81

DBA_FLASHBACK_ARCHIVE_TABLES ....................................................................................... 4-81

DBA_FLASHBACK_ARCHIVE_TS.................................................................................................. 4-82

DBA_FLASHBACK_TXN_REPORT ................................................................................................. 4-82

DBA_FLASHBACK_TXN_STATE .................................................................................................... 4-82

DBA_FREE_SPACE .............................................................................................................................. 4-83

剩余1305页未读，继续阅读

weixin_40191861_zj

粉丝: 77
资源: 1万+

Oracle Database 11g Release 2官方参考手册

Oracle Database Net Services Reference 11g Release 2 (11.2)

Oracle® Database SQL Language Reference 11g Release 2 (11.2)

Oracle Database Administrator’s Reference 11g Release 2 (11.2) f

oracle oracle-instantclient11.2-basic-11.2.0.4

oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

下载oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip资源

oracle database instant client 11g 11.2.0.3.0 x64

path /usr in package oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64 is n

centos7怎么查看oracle数据库版本信息

怎么查oracle版本

oracle数据库大作业

oracle 11.2.0.3.0 client下载

linux oracle11g客户端下载

oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

linux 安装sqlplus

如何查看oracle的版本

oracle11g 11.2.0.4.0

oracle11.2.0.4.0下载

11gr2 11.2.0.3 下载

最新资源