es-plugins-head.zip

可直接放置在tomcat的elasticsearch-head-master插件，已经编译。无需node再次编译，直接放在tomcat下运行。

阿里edas开发工具包edas-sdk

阿里edas开发工具包，

常见算法题库

常见算法题库，包含 河内塔 费式数列 巴斯卡三角形 三色棋 老鼠走迷官（一） 老鼠走迷官（二） 骑士走棋盘 八个皇后 八枚银币 生命游戏 字串核对 双色、三色河内塔 背包问题（Knapsack Problem）

Dom4j使用简介

Dom4j使用简介，日志 开发java必看，初级高级开发必看

python 网络爬虫并保存text

python 网络爬虫并保存text，爬取网上试题网站，然后将网站内容保存到text

java如何连接数据库jdbc详解

最详细的java连接数据库，教你如何利用java连接数据库

Java学习笔记

Java学习笔记面向对象主要针对面向过程。 面向过程的基本单元是函数。 什么是对象：EVERYTHING IS OBJECT（万物皆对象） 所有的事物都有两个方面： 有什么（属性）：用来描述对象。 能够做什么（方法）：告诉外界对象有那些功能。 后者以前者为基础。 大的对象的属性也可以是一个对象。 为什么要使用面向对象： 首先，面向对象符合人类看待事物的一般规律。 对象的方法的实现细节是屏蔽的，只有对象方法的实现者了解细节。 方法的定义非常重要。方法有参数，也可能有返回值。 注意区分：对象（本身）、对象的实现者、对象的调用者。 分析对象主要从方法开始。 我们通过类来看待对象，类是对象的抽象。 其次，采用面向对象方法可以使系统各部分各司其职、各尽所能。 对象之间的耦合性一定要低（比如不同硬盘和不同主板之间的关系、、、、、、

JavaWeb 面试

1、jsp有哪些内置对象?作用分别是什么？ 2、jsp有哪些动作?作用分别是什么? 3、JSP中动态INCLUDE与静态INCLUDE的区别 4、两种跳转方式分别是什么?有什么区别? 5、说一说Servlet的生命周期? 6、Servlet版本间(忘了问的是哪两个版本了)的不同? 7、JAVA SERVLET API中forward() 与redirect()的区别？ 8、Servlet的基本架构 。。。。。。。。。。。。。。。。。。。。。。

Oracle 10G DBA Reference.chm

资料来源 资料来源：Oracle OTN 文档库 适用版本：Oracle -------------------------------------------------------------------------------- 版权声明 您可以自由地将此文档复制发行，但请保留此声明页。 请勿将此文档用于任何商业用途。

Ora9iSQLRef.chm

A ACTIVE_INSTANCE_COUNT initialization parameter, 1-15 ALL_ALL_TABLES view, 2-6 ALL_APPLY view, 2-8 ALL_APPLY_CONFLICT_COLUMNS view, 2-9 ALL_APPLY_DML_HANDLERS view, 2-10 ALL_APPLY_ERROR view, 2-10 ALL_APPLY_KEY_COLUMNS view, 2-11 ALL_APPLY_PARAMETERS view, 2-12 ALL_APPLY_PROGRESS view, 2-12 ALL_ARGUMENTS view, 2-13 ALL_ASSOCIATIONS view, 2-14 ALL_AUDIT_POLICIES view, 2-15 ALL_BASE_TABLE_MVIEWS view, 2-16 ALL_CAPTURE view, 2-17 ALL_CAPTURE_PARAMETERS view, 2-18 ALL_CAPTURE_PREPARED_DATABASE view, 2-18 ALL_CAPTURE_PREPARED_SCHEMAS view, 2-19 ALL_CAPTURE_PREPARED_TABLES view, 2-19 ALL_CATALOG view, 2-20 ALL_CLUSTER_HASH_EXPRESSIONS view, 2-20 ALL_CLUSTERS view, 2-21 ALL_COL_COMMENTS view, 2-22 ALL_COL_PRIVS view, 2-22 ALL_COL_PRIVS_MADE view, 2-23 ALL_COL_PRIVS_RECD view, 2-24 ALL_COLL_TYPES view, 2-25 ALL_CONS_COLUMNS view, 2-25 ALL_CONS_OBJ_COLUMNS view, 2-26 ALL_CONSTRAINTS view, 2-27 ALL_CONTEXT view, 2-28 ALL_DB_LINKS view, 2-29 ALL_DEF_AUDIT_OPTS view, 2-29 ALL_DEPENDENCIES view, 2-30 ALL_DIM_ATTRIBUTES view, 2-31 ALL_DIM_CHILD_OF view, 2-32 ALL_DIM_HIERARCHIES view, 2-32 ALL_DIM_JOIN_KEY view, 2-33 ALL_DIM_LEVEL_KEY view, 2-33 ALL_DIM_LEVELS view, 2-34 ALL_DIMENSIONS view, 2-34 ALL_DIRECTORIES view, 2-35 ALL_ERRORS view, 2-35 ALL_EVALUATION_CONTEXT_TABLES view, 2-36 ALL_EVALUATION_CONTEXT_VARS view, 2-36 ALL_EVALUATION_CONTEXTS view, 2-37 ALL_EXTERNAL_LOCATIONS view, 2-38 ALL_EXTERNAL_TABLES view, 2-39 ALL_IND_COLUMNS view, 2-40 ALL_IND_EXPRESSIONS view, 2-41 ALL_IND_PARTITIONS view, 2-41 ALL_IND_SUBPARTITIONS view, 2-43 ALL_INDEXES view, 2-45 ALL_INDEXTYPE_COMMENTS view, 2-48 ALL_INDEXTYPE_OPERATORS view, 2-49 ALL_INDEXTYPES view, 2-50 ALL_INTERNAL_TRIGGERS view, 2-50 ALL_JAVA_ARGUMENTS view, 2-51 ALL_JAVA_CLASSES view, 2-52 ALL_JAVA_DERIVATIONS view, 2-53 ALL_JAVA_FIELDS view, 2-54 ALL_JAVA_IMPLEMENTS view, 2-55 ALL_JAVA_INNERS view, 2-56 ALL_JAVA_LAYOUTS view, 2-57 ALL_JAVA_METHODS view, 2-58 ALL_JAVA_NCOMPS view, 2-59 ALL_JAVA_RESOLVERS view, 2-60 ALL_JAVA_THROWS view, 2-61 ALL_JOBS view, 2-61 ALL_JOIN_IND_COLUMNS view, 2-63 ALL_LIBRARIES view, 2-63 ALL_LOB_PARTITIONS view, 2-64 ALL_LOB_SUBPARTITIONS view, 2-65 ALL_LOB_TEMPLATES view, 2-66 ALL_LOBS view, 2-67 ALL_LOG_GROUP_COLUMNS view, 2-68 ALL_LOG_GROUPS view, 2-69 ALL_METHOD_PARAMS view, 2-69 ALL_METHOD_RESULTS view, 2-70 ALL_MVIEW_AGGREGATES view, 2-71 ALL_MVIEW_ANALYSIS view, 2-72 ALL_MVIEW_DETAIL_RELATIONS view, 2-73 ALL_MVIEW_JOINS view, 2-74 ALL_MVIEW_KEYS view, 2-75 ALL_MVIEW_LOGS view, 2-76 ALL_MVIEW_REFRESH_TIMES view, 2-77 ALL_MVIEWS view, 2-77 ALL_NESTED_TABLES view, 2-82 ALL_OBJ_COLATTRS view, 2-82 ALL_OBJECT_TABLES view, 2-83 ALL_OBJECTS view, 2-85 ALL_OPANCILLARY view, 2-86 ALL_OPARGUMENTS view, 2-87 ALL_OPBINDINGS view, 2-87 ALL_OPERATOR_COMMENTS view, 2-88 ALL_OPERATORS view, 2-89 ALL_OUTLINE_HINTS view, 2-89 ALL_OUTLINES view, 2-90 ALL_PART_COL_STATISTICS view, 2-91 ALL_PART_HISTOGRAMS view, 2-92 ALL_PART_INDEXES view, 2-92 ALL_PART_KEY_COLUMNS view, 2-94 ALL_PART_LOBS view, 2-95 ALL_PART_TABLES view, 2-96 ALL_PARTIAL_DROP_TABS view, 2-98 ALL_PENDING_CONV_TABLES view, 2-98 ALL_POLICIES view, 2-99 ALL_POLICY_CONTEXTS view, 2-100 ALL_POLICY_GROUPS view, 2-101 ALL_PROCEDURES view, 2-101 ALL_PROPAGATION view, 2-102 ALL_PUBLISHED_COLUMNS view, 2-103 ALL_QUEUE_TABLES view, 2-103 ALL_QUEUES view, 2-105 ALL_REFRESH view, 2-105 ALL_REFRESH_CHILDREN view, 2-106 ALL_REFRESH_DEPENDENCIES view, 2-107 ALL_REFS view, 2-108 ALL_REGISTERED_MVIEWS view, 2-108 ALL_REGISTRY_BANNERS view, 2-109 ALL_REPAUDIT_ATTRIBUTE view, 2-2 ALL_REPAUDIT_COLUMN view, 2-2 ALL_REPCAT view, 2-2 ALL_REPCAT_REFRESH_TEMPLATES view, 2-2 ALL_REPCAT_TEMPLATE_OBJECTS view, 2-2 ALL_REPCAT_TEMPLATE_PARMS view, 2-2 ALL_REPCAT_TEMPLATE_SITES view, 2-2 ALL_REPCAT_USER_AUTHORIZATIONS view, 2-2 ALL_REPCAT_USER_PARM_VALUES view, 2-2 ALL_REPCATLOG view, 2-2 ALL_REPCOLUMN view, 2-2 ALL_REPCOLUMN_GROUP view, 2-2 ALL_REPCONFLICT view, 2-2 ALL_REPDDL view, 2-2 ALL_REPFLAVOR_COLUMNS view, 2-2 ALL_REPFLAVOR_OBJECTS view, 2-2 ALL_REPFLAVORS view, 2-2 ALL_REPGENERATED view, 2-2 ALL_REPGENOBJECTS view, 2-2 ALL_REPGROUP view, 2-2 ALL_REPGROUP_PRIVILEGES view, 2-2 ALL_REPGROUPED_COLUMN view, 2-2 ALL_REPKEY_COLUMNS view, 2-2 ALL_REPOBJECT view, 2-2 ALL_REPPARAMETER_COLUMN view, 2-2 ALL_REPPRIORITY view, 2-2 ALL_REPPRIORITY_GROUP view, 2-2 ALL_REPPROP view, 2-2 ALL_REPRESOL_STATS_CONTROL view, 2-2 ALL_REPRESOLUTION view, 2-2 ALL_REPRESOLUTION_METHOD view, 2-2 ALL_REPRESOLUTION_STATISTICS view, 2-2 ALL_REPSCHEMA view, 2-2 ALL_REPSITES view, 2-2 ALL_RULE_SET_RULES view, 2-110 ALL_RULE_SETS view, 2-110 ALL_RULES view, 2-111 ALL_SEQUENCES view, 2-112 ALL_SOURCE view, 2-112 ALL_SOURCE_TABLES view, 2-113 ALL_SQLJ_TYPE_ATTRS view, 2-113 ALL_SQLJ_TYPE_METHODS view, 2-114 ALL_SQLJ_TYPES view, 2-115 ALL_STORED_SETTINGS view, 2-116 ALL_STREAMS_GLOBAL_RULES view, 2-117 ALL_STREAMS_SCHEMA_RULES view, 2-118 ALL_STREAMS_TABLE_RULES view, 2-119 ALL_SUBPART_COL_STATISTICS view, 2-121 ALL_SUBPART_HISTOGRAMS view, 2-122 ALL_SUBPART_KEY_COLUMNS view, 2-123 ALL_SUBPARTITION_TEMPLATES view, 2-124 ALL_SUBSCRIBED_COLUMNS view, 2-124 ALL_SUBSCRIBED_TABLES view, 2-125 ALL_SUBSCRIPTIONS view, 2-125 ALL_SUMDELTA view, 2-126 ALL_SYNONYMS view, 2-126 ALL_TAB_COL_STATISTICS view, 2-127 ALL_TAB_COLUMNS view, 2-128 ALL_TAB_COMMENTS view, 2-130 ALL_TAB_HISTOGRAMS view, 2-130 ALL_TAB_MODIFICATIONS view, 2-131 ALL_TAB_PARTITIONS view, 2-132 ALL_TAB_PRIVS view, 2-133 ALL_TAB_PRIVS_MADE view, 2-134 ALL_TAB_PRIVS_RECD view, 2-135 ALL_TAB_SUBPARTITIONS view, 2-136 ALL_TABLES view, 2-137 ALL_TRIGGER_COLS view, 2-140 ALL_TRIGGERS view, 2-141 ALL_TYPE_ATTRS view, 2-142 ALL_TYPE_METHODS view, 2-143 ALL_TYPE_VERSIONS view, 2-144 ALL_TYPES view, 2-144 ALL_UNUSED_COL_TABS view, 2-145 ALL_UPDATABLE_COLUMNS view, 2-146 ALL_USERS view, 2-146 ALL_USTATS view, 2-147 ALL_VARRAYS view, 2-148 ALL_VERSION_HVIEW view, 2-3 ALL_VIEWS view, 2-148 ALL_WM_LOCKED_TABLES view, 2-3 ALL_WM_MODIFIED_TABLES view, 2-3 ALL_WM_RIC_INFO view, 2-3 ALL_WM_TAB_TRIGGERS view, 2-3 ALL_WM_VERSIONED_TABLES view, 2-3 ALL_WM_VT_ERRORS view, 2-3 ALL_WORKSPACE_PRIVS view, 2-3 ALL_WORKSPACE_SAVEPOINTS view, 2-3 ALL_WORKSPACES view, 2-3 ALL_XML_SCHEMAS view, 2-149 ALL_XML_TAB_COLS view, 2-150 ALL_XML_TABLES view, 2-151 ALL_XML_VIEW_COLS view, 2-151 ALL_XML_VIEWS view, 2-152 ALLOCATE EXTENT clause of ALTER TABLE instance number, 1-67 allocation PCM locks, 1-60 ALTER DATABASE statement ADD LOGFILE, 1-160 database name, 1-44 ENABLE THREAD, 1-160 THREAD, 1-160 ALTER SESSION statement SET HASH_AREA_SIZE clause, 1-63 SET HASH_JOIN_ENABLED clause, 1-64 ALTER TABLE statement allocating extents, 1-67 ANALYZE statement, 2-45, 2-128, 2-130, 2-137, 2-183, 2-226, 2-227, 2-289, 2-291 AQ_TM_PROCESSES initialization parameter, 1-15 ARCHIVE LOG START statement automatic archiving, 1-75 ARCHIVE_LAG_TARGET initialization parameter, 1-16 archived redo logs automatic versus manual, 1-83 destination file, 1-75 storage device, 1-75, 1-80 ARCHIVELOG mode, 1-75 archiving destination, 1-75, 1-80 automatic archiving, 1-83 AUDIT_ACTIONS table, 2-153 AUDIT_FILE_DEST initialization parameter, 1-17 AUDIT_SYS_OPERATIONS initialization parameter, 1-17 AUDIT_TRAIL initialization parameter, 1-17 authenticating remote clients, 1-140 authenticating users, 1-119 -------------------------------------------------------------------------------- B BACKGROUND_CORE_DUMP initialization parameter, 1-18 BACKGROUND_DUMP_DEST initialization parameter, 1-18 BACKUP_TAPE_IO_SLAVES initialization parameter, 1-19 BITMAP_MERGE_AREA_SIZE initialization parameter, 1-20 BLANK_TRIMMING initialization parameter, 1-21 blocks PCM lock, 1-60 redo log, 1-86 size, 1-32, 1-36, 1-44, 4-2 BUFFER_POOL_KEEP initialization parameter, 1-21 BUFFER_POOL_RECYCLE initialization parameter, 1-22 -------------------------------------------------------------------------------- C cache dictionary, 3-98, 3-123, 3-124, 3-126, 3-127 statistics, 1-86 CAT synonym for USER_CATALOG view, 2-153 CATALOG view, 2-153 CATALOG.SQL script, 5-2 creating V$ views, 3-1 CATAUDIT.SQL script audit trail records created by, 2-264 audit trails for connections and disconnections, 2-264 auditing characteristics described by, 2-278 CATBLOCK.SQL script, 5-3 CATCLUST.SQL script, 5-2 CATEXP7.SQL script, 5-3 CATHS.SQL script, 5-3 CATIO.SQL script, 5-3 CATJAVA.SQL script, 5-8 CATNOADT.SQL script, 5-6 CATNOAUD.SQL script, 5-6 CATNOHS.SQL script, 5-6 CATNOPRT.SQL script, 5-6 CATNOQUE.SQL script, 5-6 CATNORMN.SQL script, 5-6 CATNOSVM.SQL script, 5-6 CATNSNMP.SQL script, 5-6 CATOCTK.SQL script, 5-3 CATPROC.SQL script, 5-2 CATQUEUE.SQL script, 5-3 CATREP.SQL script, 5-3 CATRMAN.SQL script, 5-3 CHAINED_ROWS table, 2-153 CHANGE_SETS view, 2-154 CHANGE_SOURCES view, 2-154 CHANGE_TABLES view, 2-155 characters numeric group separators, 1-101 checkpoints checkpoint interval, 1-86 statistics, 1-86 CIRCUITS initialization parameter, 1-24 CLU synonym for USER_CLUSTERS view, 2-155 CLUSTER_DATABASE initialization parameter, 1-24 CLUSTER_DATABASE_INSTANCES initialization parameter, 1-25 CLUSTER_INTERCONNECTS initialization parameter, 1-25 CMPDBMIG.SQL script, 5-7 CODE_PIECES view, 2-156 CODE_SIZE view, 2-156 COL view, 2-156 COLS synonym for USER_TAB_COLUMNS view, 2-156 COLUMN_PRIVILEGES view, 2-156 COMMIT_POINT_STRENGTH initialization parameter, 1-26 COMPATIBLE initialization parameter, 1-27 concurrency ROW_LOCKING initialization parameter, 1-144 contention block-level, 3-189 control files names, 1-28 specifying, 1-28 CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1-28 CONTROL_FILES initialization parameter, 1-28 CORE_DUMP_DEST initialization parameter, 1-29 cost-based optimization, 1-114 favoring IN-list iterators, 1-112 CPU_COUNT initialization parameter, 1-29 CREATE DATABASE statement database name, 1-44 setting the log mode, 1-83 CREATE TABLE statement FREELIST GROUPS clause, 1-67 CREATE_BITMAP_AREA_SIZE initialization parameter, 1-30 creating a database setting block size, 1-32, 1-36, 1-44 currency, 1-96 international currency symbol, 1-99 CURSOR_SHARING initialization parameter, 1-31 CURSOR_SPACE_FOR_TIME initialization parameter, 1-31 cursors OPEN_CURSORS initialization parameter, 1-107 shared pool, 1-64, 1-149, 1-151 -------------------------------------------------------------------------------- D D0801070.SQL script, 5-7 D0900010.SQL script, 5-7 data blocks reading multiple, 1-40 size of, 1-32, 1-36, 1-44 data dictionary, 2-1 cache, 3-98, 3-123, 3-124, 3-126, 3-127 datafiles, 1-60 scripts, 5-3 SQL scripts, 5-2 tables, 2-1 views, 1-60 overview, 2-1 user views, 2-1 database migration scripts, 5-7 database writer process (DBWR) checkpoint, 1-86 DATABASE_PROPERTIES view, 2-156 databases block size, 4-2 database limits, 4-1 default language, 1-99 name, 1-44, 1-45 resource limits, 1-141, 1-142 valid characters for database name, 1-44 datafiles mapping blocks to PCM locks, 1-60 maximum number, 1-43 parameter, 1-43 unspecified for PCM locks, 1-60 dates language used for, 1-98, 1-103, 1-104 setting SYSDATE, 1-60 TO_CHAR function, 1-97 TO_DATE function, 1-97 DB_BLOCK_BUFFERS initialization parameter, 1-33 DB_BLOCK_CHECKING initialization parameter, 1-35 DB_BLOCK_CHECKSUM initialization parameter, 1-35 DB_BLOCK_SIZE initialization parameter, 1-36 DB_CACHE_ADVICE initialization parameter, 1-37 DB_CACHE_SIZE initialization parameter, 1-38 DB_CREATE_FILE_DEST initialization parameter, 1-38 DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1-39 DB_DOMAIN initialization parameter, 1-39 DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1-40 DB_FILE_NAME_CONVERT initialization parameter, 1-41 DB_FILES initialization parameter, 1-43 DB_KEEP_CACHE_SIZE initialization parameter, 1-44 DB_NAME initialization parameter, 1-44 DB_nK_CACHE_SIZE initialization parameter, 1-32 DB_RECYCLE_CACHE_SIZE initialization parameter, 1-45 DB_WRITER_PROCESSES initialization parameter, 1-45 DBA_2PC_NEIGHBORS view, 2-157 DBA_2PC_PENDING view, 2-157 DBA_ALL_TABLES view, 2-158 DBA_APPLICATION_ROLES view, 2-158 DBA_APPLY view, 2-158 DBA_APPLY_CONFLICT_COLUMNS view, 2-159 DBA_APPLY_DML_HANDLERS view, 2-159 DBA_APPLY_ERROR view, 2-159 DBA_APPLY_INSTANTIATED_OBJECTS view, 2-159 DBA_APPLY_KEY_COLUMNS view, 2-160 DBA_APPLY_PARAMETERS view, 2-160 DBA_APPLY_PROGRESS view, 2-160 DBA_AQ_AGENT_PRIVS view, 2-160 DBA_AQ_AGENTS view, 2-161 DBA_ASSOCIATIONS view, 2-161 DBA_ATTRIBUTE_TRANSFORMATIONS view, 2-161 DBA_AUDIT_EXISTS view, 2-162 DBA_AUDIT_OBJECT view, 2-163 DBA_AUDIT_POLICIES view, 2-164 DBA_AUDIT_SESSION view, 2-164 DBA_AUDIT_STATEMENT view, 2-165 DBA_AUDIT_TRAIL view, 2-167 DBA_AW_PS view, 2-169 DBA_AWS view, 2-169 DBA_BASE_TABLE_MVIEWS view, 2-170 DBA_BLOCKERS view, 2-170 DBA_CAPTURE view, 2-170 DBA_CAPTURE_PARAMETERS view, 2-171 DBA_CAPTURE_PREPARED_DATABASE view, 2-171 DBA_CAPTURE_PREPARED_SCHEMAS view, 2-171 DBA_CAPTURE_PREPARED_TABLES view, 2-171 DBA_CATALOG view, 2-171 DBA_CLU_COLUMNS view, 2-172 DBA_CLUSTER_HASH_EXPRESSIONS view, 2-172 DBA_CLUSTERS view, 2-172 DBA_COL_COMMENTS view, 2-172 DBA_COL_PRIVS view, 2-172 DBA_COLL_TYPES view, 2-173 DBA_CONS_COLUMNS view, 2-173 DBA_CONS_OBJ_COLUMNS view, 2-173 DBA_CONSTRAINTS view, 2-174 DBA_CONTEXT view, 2-174 DBA_DATA_FILES view, 1-60, 2-174, 2-239 DBA_DB_LINKS view, 2-174 DBA_DDL_LOCKS view, 2-175 DBA_DEPENDENCIES view, 2-175 DBA_DIM_ATTRIBUTES view, 2-176 DBA_DIM_CHILD_OF view, 2-176 DBA_DIM_HIERARCHIES view, 2-176 DBA_DIM_JOIN_KEY view, 2-176 DBA_DIM_LEVEL_KEY view, 2-176 DBA_DIM_LEVELS view, 2-176 DBA_DIMENSIONS view, 2-177 DBA_DIRECTORIES view, 2-177 DBA_DML_LOCKS view, 2-177 DBA_DMT_FREE_SPACE view, 2-178 DBA_DMT_USED_EXTENTS view, 2-178 DBA_ERRORS view, 2-178 DBA_EVALUATION_CONTEXT_TABLES view, 2-178 DBA_EVALUATION_CONTEXT_VARS view, 2-179 DBA_EVALUATION_CONTEXTS view, 2-179 DBA_EXP_FILES view, 2-179 DBA_EXP_OBJECTS view, 2-179 DBA_EXP_VERSION view, 2-180 DBA_EXTENTS view, 2-180 DBA_EXTERNAL_LOCATIONS view, 2-181 DBA_EXTERNAL_TABLES view, 2-181 DBA_FGA_AUDIT_TRAIL view, 2-181 DBA_FREE_SPACE view, 2-182 DBA_FREE_SPACE_COALESCED view, 2-182 DBA_IND_COLUMNS view, 2-183 DBA_IND_EXPRESSIONS view, 2-183 DBA_IND_PARTITIONS view, 2-183 DBA_IND_SUBPARTITIONS view, 2-183 DBA_INDEXES view, 2-183 collecting statistics for, 2-183 DBA_INDEXTYPE_COMMENTS view, 2-183 DBA_INDEXTYPE_OPERATORS view, 2-184 DBA_INDEXTYPES view, 2-184 DBA_INTERNAL_TRIGGERS view, 2-184 DBA_JAVA_ARGUMENTS view, 2-184 DBA_JAVA_CLASSES view, 2-184 DBA_JAVA_DERIVATIONS view, 2-184 DBA_JAVA_FIELDS view, 2-185 DBA_JAVA_IMPLEMENTS view, 2-185 DBA_JAVA_INNERS view, 2-185 DBA_JAVA_LAYOUTS view, 2-185 DBA_JAVA_METHODS view, 2-185 DBA_JAVA_NCOMPS view, 2-185 DBA_JAVA_POLICY view, 2-186 DBA_JAVA_RESOLVERS view, 2-186 DBA_JAVA_THROWS view, 2-187 DBA_JOBS view, 2-187 DBA_JOBS_RUNNING view, 2-187 DBA_JOIN_IND_COLUMNS view, 2-187 DBA_KGLLOCK view, 2-188 DBA_LIBRARIES view, 2-188 DBA_LMT_FREE_SPACE view, 2-188 DBA_LMT_USED_EXTENTS view, 2-188 DBA_LOB_PARTITIONS view, 2-189 DBA_LOB_SUBPARTITIONS view, 2-189 DBA_LOB_TEMPLATES view, 2-189 DBA_LOBS view, 2-189 DBA_LOCK view, 2-189 DBA_LOCKS synonym, 2-190 DBA_LOCK_INTERNAL view, 2-190 DBA_LOCKS synonym for DBA_LOCK view, 2-190 DBA_LOG_GROUP_COLUMNS view, 2-191 DBA_LOG_GROUPS view, 2-191 DBA_LOGSTDBY_EVENTS view, 2-191 DBA_LOGSTDBY_LOG view, 2-191 DBA_LOGSTDBY_NOT_UNIQUE view, 2-192 DBA_LOGSTDBY_PARAMETERS view, 2-193 DBA_LOGSTDBY_PROGRESS view, 2-194 DBA_LOGSTDBY_SKIP view, 2-195 DBA_LOGSTDBY_SKIP_TRANSACTION view, 2-195 DBA_LOGSTDBY_UNSUPPORTED view, 2-196 DBA_METHOD_PARAMS view, 2-196 DBA_METHOD_RESULTS view, 2-196 DBA_MVIEW_AGGREGATES view, 2-196 DBA_MVIEW_ANALYSIS view, 2-197 DBA_MVIEW_DETAIL_RELATIONS view, 2-197 DBA_MVIEW_JOINS view, 2-197 DBA_MVIEW_KEYS view, 2-197 DBA_MVIEW_LOG_FILTER_COLS view, 2-197 DBA_MVIEW_LOGS view, 2-198 DBA_MVIEW_REFRESH_TIMES view, 2-198 DBA_MVIEWS view, 2-198 DBA_NESTED_TABLES view, 2-198 DBA_OBJ_AUDIT_OPTS view, 2-198 DBA_OBJ_COLATTRS view, 2-199 DBA_OBJECT_SIZE view, 2-200 DBA_OBJECT_TABLES view, 2-200 DBA_OBJECTS view, 2-200 DBA_OPANCILLARY view, 2-200 DBA_OPARGUMENTS view, 2-201 DBA_OPBINDINGS view, 2-201 DBA_OPERATOR_COMMENTS view, 2-201 DBA_OPERATORS view, 2-201 DBA_OUTLINE_HINTS view, 2-202 DBA_OUTLINES view, 2-202 DBA_PART_COL_STATISTICS view, 2-202 DBA_PART_HISTOGRAMS view, 2-202 DBA_PART_INDEXES view, 2-202 DBA_PART_KEY_COLUMNS view, 2-203 DBA_PART_LOBS view, 2-203 DBA_PART_TABLES view, 2-203 DBA_PARTIAL_DROP_TABS view, 2-203 DBA_PENDING_CONV_TABLES view, 2-203 DBA_PENDING_TRANSACTIONS view, 2-203 DBA_POLICIES view, 2-204 DBA_POLICY_CONTEXTS view, 2-204 DBA_POLICY_GROUPS view, 2-204 DBA_PRIV_AUDIT_OPTS view, 2-204 DBA_PROCEDURES view, 2-205 DBA_PROFILES view, 2-205 DBA_PROPAGATION view, 2-205 DBA_PROXIES view, 2-205 DBA_PUBLISHED_COLUMNS view, 2-206 DBA_QUEUE_SCHEDULES view, 2-207 DBA_QUEUE_TABLES view, 2-208 DBA_QUEUES view, 2-208 DBA_RCHILD view, 2-209 DBA_REFRESH view, 2-209 DBA_REFRESH_CHILDREN view, 2-209 DBA_REFS view, 2-209 DBA_REGISTERED_MVIEW_GROUPS view, 2-209 DBA_REGISTERED_MVIEWS view, 2-210 DBA_REGISTRY view, 2-210 DBA_REGISTRY_HIERARCHY view, 2-211 DBA_REPAIR_TABLE view, 2-212 DBA_REPAUDIT_ATTRIBUTE view, 2-2 DBA_REPAUDIT_COLUMN view, 2-2 DBA_REPCAT view, 2-2 DBA_REPCAT_EXCEPTIONS view, 2-2 DBA_REPCAT_REFRESH_TEMPLATES view, 2-2 DBA_REPCAT_TEMPLATE_OBJECTS view, 2-2 DBA_REPCAT_TEMPLATE_PARMS view, 2-2 DBA_REPCAT_TEMPLATE_SITES view, 2-2 DBA_REPCAT_USER_AUTHORIZATIONS view, 2-2 DBA_REPCAT_USER_PARM_VALUES view, 2-2 DBA_REPCATLOG view, 2-2 DBA_REPCOLUMN view, 2-2 DBA_REPCOLUMN_GROUP view, 2-2 DBA_REPCONFLICT view, 2-2 DBA_REPDDL view, 2-2 DBA_REPEXTENSIONS view, 2-2 DBA_REPFLAVOR_COLUMNS view, 2-2 DBA_REPFLAVOR_OBJECTS view, 2-2 DBA_REPFLAVORS view, 2-2 DBA_REPGENERATED view, 2-2 DBA_REPGENOBJECTS view, 2-2 DBA_REPGROUP view, 2-2 DBA_REPGROUP_PRIVILEGES view, 2-2 DBA_REPGROUPED_COLUMN view, 2-2 DBA_REPKEY_COLUMNS view, 2-2 DBA_REPOBJECT view, 2-2 DBA_REPPARAMETER_COLUMN view, 2-2 DBA_REPPRIORITY view, 2-2 DBA_REPPRIORITY_GROUP view, 2-2 DBA_REPPROP view, 2-2 DBA_REPRESOL_STATS_CONTROL view, 2-2 DBA_REPRESOLUTION view, 2-2 DBA_REPRESOLUTION_METHOD view, 2-2 DBA_REPRESOLUTION_STATISTICS view, 2-2 DBA_REPSCHEMA view, 2-2 DBA_REPSITES view, 2-2 DBA_REPSITES_NEW view, 2-2 DBA_RESUMABLE view, 2-213 DBA_RGROUP view, 2-214 DBA_ROLE_PRIVS view, 2-215 DBA_ROLES view, 2-215 DBA_ROLLBACK_SEGS view, 2-215 DBA_RSRC_CONSUMER_GROUP_PRIVS view, 2-216 DBA_RSRC_CONSUMER_GROUPS view, 2-217 DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 2-217 DBA_RSRC_PLAN_DIRECTIVES view, 2-218 DBA_RSRC_PLANS view, 2-219 DBA_RULE_SET_RULES view, 2-220 DBA_RULE_SETS view, 2-220 DBA_RULES view, 2-220 DBA_SEGMENTS view, 2-220 DBA_SEQUENCES view, 2-221 DBA_SOURCE view, 2-222 DBA_SOURCE_TABLES view, 2-222 DBA_SQLJ_TYPE_ATTRS view, 2-222 DBA_SQLJ_TYPE_METHODS view, 2-222 DBA_SQLJ_TYPES view, 2-222 DBA_STMT_AUDIT_OPTS view, 2-222 DBA_STORED_SETTINGS view, 2-223 DBA_STREAMS_GLOBAL_RULES view, 2-223 DBA_STREAMS_SCHEMA_RULES view, 2-223 DBA_STREAMS_TABLE_RULES view, 2-224 DBA_SUBPART_COL_STATISTICS view, 2-224 DBA_SUBPART_HISTOGRAMS view, 2-224 DBA_SUBPART_KEY_COLUMNS view, 2-224 DBA_SUBPARTITION_TEMPLATES view, 2-224 DBA_SUBSCRIBED_COLUMNS view, 2-224 DBA_SUBSCRIBED_TABLES view, 2-225 DBA_SUBSCRIPTIONS view, 2-225 DBA_SYNONYMS view, 2-225 DBA_SYS_PRIVS view, 2-225 DBA_TAB_COL_STATISTICS view, 2-226 DBA_TAB_COLUMNS view, 2-226 DBA_TAB_COMMENTS view, 2-226 DBA_TAB_HISTOGRAMS view, 2-226 DBA_TAB_MODIFICATIONS view, 2-226 DBA_TAB_PARTITIONS view, 2-226 DBA_TAB_PRIVS view, 2-227 DBA_TAB_SUBPARTITIONS view, 2-227 DBA_TABLES view, 2-227 DBA_TABLESPACES view, 2-228 DBA_TEMP_FILES view, 2-229 DBA_TRANSFORMATIONS view, 2-230 DBA_TRIGGER_COLS view, 2-230 DBA_TRIGGERS view, 2-230 DBA_TS_QUOTAS view, 2-230 DBA_TYPE_ATTRS view, 2-231 DBA_TYPE_METHODS view, 2-231 DBA_TYPE_VERSIONS view, 2-231 DBA_TYPES view, 2-231 DBA_UNDO_EXTENTS view, 2-232 DBA_UNUSED_COL_TABS view, 2-232 DBA_UPDATABLE_COLUMNS view, 2-232 DBA_USERS view, 2-233 DBA_USTATS view, 2-234 DBA_VARRAYS view, 2-234 DBA_VIEWS view, 2-234 DBA_WAITERS view, 2-234 DBA_WORKSPACE_SESSIONS view, 2-3 DBA_XML_SCHEMAS view, 2-234 DBA_XML_TAB_COLS view, 2-235 DBA_XML_TABLES view, 2-235 DBA_XML_VIEW_COLS view, 2-235 DBA_XML_VIEWS view, 2-235 DBLINK_ENCRYPT_LOGIN initialization parameter, 1-46 DBMS_ALERT_INFO view, 2-235 DBMS_LOCK_ALLOCATED view, 2-236 DBMSIOTC.SQL script, 5-3 DBMSOTRC.SQL script, 5-3 DBMSPOOL.SQL script, 5-4 DBWR_IO_SLAVES initialization parameter, 1-46 DEFCALL view, 2-2 DEFCALLDEST view, 2-2 DEFDEFAULTDEST view, 2-2 DEFERRCOUNT view, 2-2 DEFERROR view, 2-2 DEFLOB view, 2-2 DEFPROPAGATOR view, 2-2 DEFSCHEDULE view, 2-2 DEFTRAN view, 2-2 DEFTRANDEST view, 2-2 DEPTREE view, 2-236 destination archiving redo log files, 1-75 overriding default, 1-75 USER_DUMP_DEST, 1-169 DG_BROKER_CONFIG_FILEn initialization parameter, 1-47 DG_BROKER_START initialization parameter, 1-48 DICT synonym for DICTIONARY, 2-236 DICT_COLUMNS view, 2-236 DICTIONARY view, 2-237 DICT synonym, 2-236 disk drives archiving destination, 1-75 DISK_ASYNCH_IO initialization parameter, 1-48 dispatcher processes maximum number, 1-92 DISPATCHERS initialization parameter, 1-49 distinguished name, 1-135 DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1-53 DML_LOCKS initialization parameter, 1-53 DRS_START initialization parameter, 1-54 dump files, 1-93 dynamic performance tables CATALOG.SQL script, 3-1 public synonyms (V$), 3-2 views (V_$), 3-2 -------------------------------------------------------------------------------- E embedded parameter files, 1-65 ENQUEUE_RESOURCES initialization parameter, 1-55 enqueues being written redo log, B-1 bind, B-1 buffer cache management, B-1 controlfile transaction, B-1 cross-instance call invocation, B-1 database mount, B-1 datafile, B-1 direct loader index creation, B-1 disabling, 1-53 distributed recovery, B-1 distributed TX, B-1 DML, B-1 ENQUEUE_RESOURCES initialization parameter, 1-55 file set, B-1 instance attribute lock, B-1 instance number, B-1 instance recovery, B-1 instance registration lock, B-1 instance state, B-1 job queue, B-1 library cache invalidation, B-1 library cache lock, B-1 library cache pin, B-1 media recovery, B-1 parallel slave synchronization, B-1 parallel slaves, B-1 password file, B-1 process startup, B-1 redo log "kick", B-1 redo thread, B-1 row cache, B-1 sequence number, B-1 SMON, B-1 sort segment, B-1 space management transaction, B-1 synchronized replication, B-1 system commit number, B-1 temporary segment, B-1 temporary table, B-1 transaction, B-1 transaction recovery, B-1 undo segment, serialization, B-1 user name, B-1 user-defined locks, B-1 enterprise roles, 1-135 ERROR_SIZE view, 2-237 errors archiving, 1-83 EVENT initialization parameter, 1-56 EXCEPTIONS view, 2-237 exclusive mode specifying instance number, 1-67 extent allocating to instance, 1-67 -------------------------------------------------------------------------------- F FAL_CLIENT initialization parameter, 1-56 FAL_SERVER initialization parameter, 1-57 FAST_START_IO_TARGET initialization parameter, 1-57 FAST_START_MTTR_TARGET initialization parameter, 1-58 FAST_START_PARALLEL_ROLLBACK initialization parameter, 1-59 FILE_LOCK view, 2-237 FILE_MAPPING initialization parameter, 1-59 FILE_PING view, 2-238 filenames case significance, 1-5 name and number, 1-60 FILESYSTEMIO_OPTIONS initialization parameter, 1-60 FILEXT$ view, 2-239 FIXED_DATE initialization parameter, 1-60 free space list locating space, 1-67 FREELIST GROUPS clause, 1-67 -------------------------------------------------------------------------------- G GC_FILES_TO_LOCKS initialization parameter, 1-60 GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1-62 GLOBAL_NAME view, 2-240 GLOBAL_NAMES initialization parameter, 1-62 GV$ views for parallel servers, 3-2 -------------------------------------------------------------------------------- H HASH_AREA_SIZE initialization parameter, 1-63 HASH_JOIN_ENABLED initialization parameter, 1-64 Heterogeneous Services agents, 1-64 HI_SHARED_MEMORY_ADDRESS initialization parameter, 1-64 hints RULE, 1-114 HS_ALL_CAPS view, 2-240 HS_ALL_DD view, 2-240 HS_ALL_INITS view, 2-241 HS_AUTOREGISTER initialization parameter, 1-64 HS_BASE_CAPS view, 2-241 HS_BASE_DD view, 2-241 HS_CLASS_CAPS view, 2-242 HS_CLASS_DD view, 2-242 HS_CLASS_INIT view, 2-243 HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-243 HS_EXTERNAL_OBJECTS view, 2-243 HS_EXTERNAL_USER_PRIVILEGES view, 2-244 HS_FDS_CLASS view, 2-244 HS_FDS_INST view, 2-244 HS_INST_CAPS view, 2-245 HS_INST_DD view, 2-245 HS_INST_INIT view, 2-246 -------------------------------------------------------------------------------- I IDEPTREE view, 2-246 IFILE initialization parameter, 1-6, 1-65 IND synonym for USER_INDEXES view, 2-247 INDEX_HISTOGRAM view, 2-247 INDEX_STATS view, 2-247 initialization parameter file common file, 1-65 embedded, 1-65 INITDW.ORA, 1-4 line continuation character (), 1-6 overview, 1-4 initialization parameters ACTIVE_INSTANCE_COUNT, 1-15 altering, 1-7 AQ_TM_PROCESSES, 1-15 ARCHIVE_LAG_TARGET, 1-16 AUDIT_FILE_DEST, 1-17 AUDIT_SYS_OPERATIONS, 1-17 AUDIT_TRAIL, 1-17 BACKGROUND_CORE_DUMP, 1-18 BACKGROUND_DUMP_DEST, 1-18 BACKUP_TAPE_IO_SLAVES, 1-19 BITMAP_MERGE_AREA_SIZE, 1-20 BLANK_TRIMMING, 1-21 BUFFER_POOL_KEEP, 1-21 BUFFER_POOL_RECYCLE, 1-22 case significance in filenames, 1-5 CIRCUITS, 1-24 CLUSTER_DATABASE, 1-24 CLUSTER_DATABASE_INSTANCES, 1-25 CLUSTER_INTERCONNECTS, 1-25 COMMIT_POINT_STRENGTH, 1-26 COMPATIBLE, 1-27 CONTROL_FILE_RECORD_KEEP_TIME, 1-28 CONTROL_FILES, 1-28 CORE_DUMP_DEST, 1-29 CPU_COUNT, 1-29 CREATE_BITMAP_AREA_SIZE, 1-30 CURSOR_SHARING, 1-31 CURSOR_SPACE_FOR_TIME, 1-31 database creation, 1-44 DB_BLOCK_BUFFERS, 1-33 DB_BLOCK_CHECKING, 1-35 DB_BLOCK_CHECKSUM, 1-35 DB_BLOCK_SIZE, 1-36 DB_CACHE_ADVICE, 1-37 DB_CACHE_SIZE, 1-38 DB_CREATE_FILE_DEST, 1-38 DB_CREATE_ONLINE_LOG_DEST_n, 1-39 DB_DOMAIN, 1-39 DB_FILE_MULTIBLOCK_READ_COUNT, 1-40 DB_FILE_NAME_CONVERT, 1-41 DB_FILES, 1-43 DB_KEEP_CACHE_SIZE, 1-44 DB_NAME, 1-44 DB_nK_CACHE_SIZE, 1-32 DB_RECYCLE_CACHE_SIZE, 1-45 DB_WRITER_PROCESSES, 1-45 DBLINK_ENCRYPT_LOGIN, 1-46 DBWR_IO_SLAVES, 1-46 derived, 1-3 DG_BROKER_CONFIG_FILEn, 1-47 DG_BROKER_START, 1-48 DISK_ASYNCH_IO, 1-48 DISPATCHERS, 1-49 display current settings, 1-11 DISTRIBUTED_LOCK_TIMEOUT, 1-53 DML_LOCKS, 1-53 DRS_START, 1-54 dynamic, 1-8 embedded initialization parameter files, 1-6 ENQUEUE_RESOURCES, 1-55 EVENT, 1-56 FAL_CLIENT, 1-56 FAL_SERVER, 1-57 FAST_START_IO_TARGET, 1-57 FAST_START_MTTR_TARGET, 1-58 FAST_START_PARALLEL_ROLLBACK, 1-59 FILE_MAPPING, 1-59 FILESYSTEMIO_OPTIONS, 1-60 FIXED_DATE, 1-60 GC_FILES_TO_LOCKS, 1-60 GLOBAL_CONTEXT_POOL_SIZE, 1-62 GLOBAL_NAMES, 1-62 HASH_AREA_SIZE, 1-63 HASH_JOIN_ENABLED, 1-64 HI_SHARED_MEMORY_ADDRESS, 1-64 HS_AUTOREGISTER, 1-64 IFILE, 1-6, 1-65 INSTANCE_GROUPS, 1-66 INSTANCE_NAME, 1-67 INSTANCE_NUMBER, 1-67 JAVA_MAX_SESSIONSPACE_SIZE, 1-68 JAVA_POOL_SIZE, 1-68 JAVA_SOFT_SESSIONSPACE_LIMIT, 1-69 JOB_QUEUE_PROCESSES, 1-69 LARGE_POOL_SIZE, 1-70 LICENSE_MAX_SESSIONS, 1-71 LICENSE_MAX_USERS, 1-72 LICENSE_SESSIONS_WARNING, 1-72 LOCAL_LISTENER, 1-73 LOCK_NAME_SPACE, 1-74 LOCK_SGA, 1-74 LOG_ARCHIVE_DEST, 1-75 LOG_ARCHIVE_DEST_n, 1-76 LOG_ARCHIVE_DEST_STATE_n, 1-78 LOG_ARCHIVE_DUPLEX_DEST, 1-79 LOG_ARCHIVE_FORMAT, 1-80 LOG_ARCHIVE_MAX_PROCESSES, 1-81 LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-82 LOG_ARCHIVE_START, 1-83 LOG_ARCHIVE_TRACE, 1-84 LOG_BUFFER, 1-85 LOG_CHECKPOINT_INTERVAL, 1-86 LOG_CHECKPOINT_TIMEOUT, 1-87 LOG_CHECKPOINTS_TO_ALERT, 1-88 LOG_FILE_NAME_CONVERT, 1-88 LOG_PARALLELISM, 1-90 LOGMNR_MAX_PERSISTENT_SESSIONS, 1-90 MAX_COMMIT_PROPAGATION_DELAY, 1-91 MAX_DISPATCHERS, 1-92 MAX_DUMP_FILE_SIZE, 1-93 MAX_ENABLED_ROLES, 1-94 MAX_ROLLBACK_SEGMENTS, 1-94 MAX_SHARED_SERVERS, 1-94 NLS_CALENDAR, 1-95 NLS_COMP, 1-96 NLS_CURRENCY, 1-96 NLS_DATE_FORMAT, 1-97 NLS_DATE_LANGUAGE, 1-98 NLS_DUAL_CURRENCY, 1-98 NLS_ISO_CURRENCY, 1-99 NLS_LANGUAGE, 1-99 NLS_LENGTH_SEMANTICS, 1-100 NLS_NCHAR_CONV_EXCP, 1-100 NLS_NUMERIC_CHARACTERS, 1-101 NLS_SORT, 1-101 NLS_TERRITORY, 1-102 NLS_TIMESTAMP_FORMAT, 1-103 NLS_TIMESTAMP_TZ_FORMAT, 1-104 O7_DICTIONARY_ACCESSIBILITY, 1-104 OBJECT_CACHE_MAX_SIZE_PERCENT, 1-105 OBJECT_CACHE_OPTIMAL_SIZE, 1-106 OLAP_PAGE_POOL_SIZE, 1-106 OPEN_CURSORS, 1-107 OPEN_LINKS, 1-107 operating system-dependent values, 1-3 OPTIMIZER_DYNAMIC_SAMPLING, 1-109 OPTIMIZER_FEATURES_ENABLE, 1-109 OPTIMIZER_INDEX_CACHING, 1-112 OPTIMIZER_INDEX_COST_ADJ, 1-113 OPTIMIZER_MAX_PERMUTATIONS, 1-113 OPTIMIZER_MODE, 1-114 ORACLE_TRACE_COLLECTION_NAME, 1-115 ORACLE_TRACE_COLLECTION_PATH, 1-116 ORACLE_TRACE_COLLECTION_SIZE, 1-116 ORACLE_TRACE_ENABLE, 1-117 ORACLE_TRACE_FACILITY_NAME, 1-117 ORACLE_TRACE_FACILITY_PATH, 1-118 OS_AUTHENT_PREFIX, 1-119 OS_ROLES, 1-120 PARALLEL_ADAPTIVE_MULTI_USER, 1-120 PARALLEL_AUTOMATIC_TUNING, 1-121 PARALLEL_EXECUTION_MESSAGE_SIZE, 1-122 PARALLEL_INSTANCE_GROUP, 1-122 PARALLEL_MAX_SERVERS, 1-123 PARALLEL_MIN_PERCENT, 1-124 PARALLEL_MIN_SERVERS, 1-125 PARALLEL_THREADS_PER_CPU, 1-126 parameter files, 1-4 PARTITION_VIEW_ENABLED, 1-126 performance tuning, 1-3 PGA_AGGREGATE_TARGET, 1-127 PLSQL_COMPILER_FLAGS, 1-128 PLSQL_NATIVE_C_COMPILER, 1-129 PLSQL_NATIVE_LIBRARY_DIR, 1-129 PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1-129 PLSQL_NATIVE_LINKER, 1-130 PLSQL_NATIVE_MAKE_FILE_NAME, 1-130 PLSQL_NATIVE_MAKE_UTILITY, 1-131 PLSQL_V2_COMPATIBILITY, 1-131 PRE_PAGE_SGA, 1-132 PROCESSES, 1-133 QUERY_REWRITE_ENABLED, 1-133 QUERY_REWRITE_INTEGRITY, 1-134 RDBMS_SERVER_DN, 1-135 READ_ONLY_OPEN_DELAYED, 1-136 RECOVERY_PARALLELISM, 1-136 REMOTE_ARCHIVE_ENABLE, 1-137 REMOTE_DEPENDENCIES_MODE, 1-138 REMOTE_LISTENER, 1-138 REMOTE_LOGIN_PASSWORDFILE, 1-139 REMOTE_OS_AUTHENT, 1-140 REMOTE_OS_ROLES, 1-140 REPLICATION_DEPENDENCY_TRACKING, 1-141 RESOURCE_LIMIT, 1-141 RESOURCE_MANAGER_PLAN, 1-142 ROLLBACK_SEGMENTS, 1-143 ROW_LOCKING, 1-144 SERIAL_REUSE, 1-145 SERVICE_NAMES, 1-146 SESSION_CACHED_CURSORS, 1-146 SESSION_MAX_OPEN_FILES, 1-147 SESSIONS, 1-148 SGA_MAX_SIZE, 1-148 SHADOW_CORE_DUMP, 1-149 SHARED_MEMORY_ADDRESS, 1-149 SHARED_POOL_RESERVED_SIZE, 1-150, 3-142 SHARED_POOL_SIZE, 1-151 SHARED_SERVER_SESSIONS, 1-151 SHARED_SERVERS, 1-152 SORT_AREA_RETAINED_SIZE, 1-152 SORT_AREA_SIZE, 1-153 specifying in initialization parameter files, 1-5 SPFILE, 1-155 SQL_TRACE, 1-156 SQL92_SECURITY, 1-157 STANDBY_ARCHIVE_DEST, 1-157 STANDBY_FILE_MANAGEMENT, 1-158 STAR_TRANSFORMATION_ENABLED, 1-159 STATISTICS_LEVEL, 1-159 TAPE_ASYNCH_IO, 1-160 THREAD, 1-160 TIMED_OS_STATISTICS, 1-161 TIMED_STATISTICS, 1-162 TRACE_ENABLED, 1-163 TRACEFILE_IDENTIFIER, 1-163 TRANSACTION_AUDITING, 1-164 TRANSACTIONS, 1-165 TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-165 UNDO_MANAGEMENT, 1-166 UNDO_RETENTION, 1-166 UNDO_SUPPRESS_ERRORS, 1-167 UNDO_TABLESPACE, 1-168 USE_INDIRECT_DATA_BUFFERS, 1-168 USER_DUMP_DEST, 1-169 UTL_FILE_DIR, 1-169 variable, 1-3 WORKAREA_SIZE_POLICY, 1-170 INITJVM.SQL script, 5-8 INIT.ORA file. See initialization parameter file IN-list iterators optimizer use of, 1-112 inserts locating free space, 1-67 INST_ID column, 3-2 INSTANCE clause of ALTER TABLE allocating extents, 1-67 INSTANCE_GROUPS initialization parameter, 1-66 INSTANCE_NAME initialization parameter, 1-67 INSTANCE_NUMBER initialization parameter, 1-67 exclusive or parallel mode, 1-67 instances checkpoint, 1-86 startup order, 1-67 I/O reading multiple blocks, 1-40 redo log files, 1-85 -------------------------------------------------------------------------------- J Java initialization parameters JAVA_MAX_SESSIONSPACE_SIZE, 1-68 JAVA_POOL_SIZE, 1-68 JAVA_SOFT_SESSIONSPACE_LIMIT, 1-69 Java scripts, 5-8 JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1-68 JAVA_POOL_SIZE initialization parameter, 1-68 JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1-69 JOB_QUEUE_PROCESSES initialization parameter, 1-69 -------------------------------------------------------------------------------- L language database default language, 1-99 LARGE_POOL_SIZE initialization parameter, 1-70 LICENSE_MAX_SESSIONS initialization parameter, 1-71 LICENSE_MAX_USERS initialization parameter, 1-72 LICENSE_SESSIONS_WARNING initialization parameter, 1-72 licenses maximum sessions, 1-71 maximum users, 1-72 warning for concurrent user sessions, 1-72 limits on the database, 4-1 linguistic sorts, 1-101 local currency, 1-96 LOCAL_LISTENER initialization parameter, 1-73 lock conversion, 3-26 LOCK_NAME_SPACE initialization parameter, 1-74 LOCK_SGA initialization parameter, 1-74 locks conversion, 3-22, 3-25, 3-29, 3-56 names, A-16 on KGL objects, 2-188 table lock, 1-144 LOG_ARCHIVE_DEST initialization parameter, 1-75 LOG_ARCHIVE_DEST_n initialization parameter, 1-76 LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1-78 LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1-79 LOG_ARCHIVE_FORMAT initialization parameter, 1-80 LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1-81 LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1-82 LOG_ARCHIVE_START initialization parameter, 1-83 LOG_ARCHIVE_TRACE initialization parameter, 1-84 LOG_BUFFER initialization parameter, 1-85 LOG_CHECKPOINT_INTERVAL initialization parameter, 1-86 LOG_CHECKPOINT_TIMEOUT initialization parameter, 1-87 LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1-88 LOG_FILE_NAME_CONVERT initialization parameter, 1-88 LOG_PARALLELISM initialization parameter, 1-90 LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1-90 lowercase significance, 1-5 -------------------------------------------------------------------------------- M manual archiving, 1-83 MAP_OBJECT table, 2-248 MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1-91 MAX_DISPATCHERS initialization parameter, 1-92 MAX_DUMP_FILE_SIZE initialization parameter, 1-93 MAX_ENABLED_ROLES initialization parameter, 1-94 MAX_ROLLBACK_SEGMENTS initialization parameter, 1-94 MAX_SHARED_SERVERS initialization parameter, 1-94 memory amount used for sorting, 1-152 virtual, 1-3 modes archiving, 1-83 monitor performance, 1-86 multiple-process systems number of processes, 1-133 -------------------------------------------------------------------------------- N nested files, 1-65 NLS_CALENDAR initialization parameter, 1-95 NLS_COMP initialization parameter, 1-96 NLS_CURRENCY initialization parameter, 1-96 defined by NLS_TERRITORY, 1-102 NLS_DATABASE_PARAMETERS view, 2-249 NLS_DATE_FORMAT initialization parameter, 1-97 defined by NLS_NUMERIC_CHARACTERS, 1-102 defined by NLS_TERRITORY, 1-102 NLS_DATE_LANGUAGE initialization parameter, 1-98 NLS_DUAL_CURRENCY initialization parameter, 1-98 NLS_INSTANCE_PARAMETERS view, 2-249 NLS_ISO_CURRENCY initialization parameter, 1-99 defined by NLS_TERRITORY, 1-102 NLS_LANGUAGE initialization parameter, 1-99 NLS_LENGTH_SEMANTICS initialization parameter, 1-100 NLS_NCHAR_CONV_EXCP initialization parameter, 1-100 NLS_NUMERIC_CHARACTERS initialization parameter, 1-101 NLS_SESSION_PARAMETERS view, 2-249 NLS_SORT initialization parameter, 1-101 NLS_TERRITORY initialization parameter, 1-102 NLS_TIMESTAMP_FORMAT initialization parameter, 1-103 NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1-104 NOARCHIVELOG mode creating a database, 1-83 numeric group separators, 1-101 -------------------------------------------------------------------------------- O O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1-104 OBJ synonym for USER_OBJECTS view, 2-250 OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1-105 OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1-106 objects data dictionary, 2-1 OLAP_PAGE_POOL_SIZE initialization parameter, 1-106 online redo log archiving, 1-83 archiving mode, 1-75 block, 1-86 file size, 1-86 number of files, 1-83 setting checkpoint interval, 1-86 OPEN_CURSORS initialization parameter, 1-107 OPEN_LINKS initialization parameter, 1-107 operating system authenticating remote clients, 1-140 authenticating users and passwords, 1-119 dependent parameters, 1-3 roles for remote clients, 1-140 optimization trading cursor space for time, 1-31 OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1-109 OPTIMIZER_FEATURES_ENABLE initialization parameter, 1-109 OPTIMIZER_INDEX_CACHING initialization parameter, 1-112 OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1-113 OPTIMIZER_MAX_PERMUTATIONS initialization parameter, 1-113 OPTIMIZER_MODE initialization parameter, 1-114 ORACLE_TRACE_COLLECTION_NAME initialization parameter, 1-115 ORACLE_TRACE_COLLECTION_PATH initialization parameter, 1-116 ORACLE_TRACE_COLLECTION_SIZE initialization parameter, 1-116 ORACLE_TRACE_ENABLE initialization parameter, 1-117 ORACLE_TRACE_FACILITY_NAME initialization parameter, 1-117 ORACLE_TRACE_FACILITY_PATH initialization parameter, 1-118 Oracle9i Real Application Clusters dynamic performance views, 3-2 initialization parameters CIRCUITS, 1-24 CLUSTER_DATABASE, 1-24 CLUSTER_DATABASE_INSTANCES, 1-25 CLUSTER_INTERCONNECTS, 1-25 DISPATCHERS, 1-49 FAST_START_PARALLEL_ROLLBACK, 1-59 PARALLEL_ADAPTIVE_MULTI_USER, 1-120 PARALLEL_AUTOMATIC_TUNING, 1-121 PARALLEL_EXECUTION_MESSAGE_SIZE, 1-122 PARALLEL_INSTANCE_GROUP, 1-122 PARALLEL_MAX_SERVERS, 1-123 PARALLEL_MIN_PERCENT, 1-124 PARALLEL_MIN_SERVERS, 1-125 PARALLEL_THREADS_PER_CPU, 1-126 ORPHAN_KEY_TABLE view. See DBA_ORPHAN_KEY_TABLE. DBA_ORPHAN_KEY_TABLE view, 2-201 OS_AUTHENT_PREFIX initialization parameter, 1-119 OS_ROLES initialization parameter, 1-120 -------------------------------------------------------------------------------- P parallel mode instance number, 1-67 parallel query maximum number of instances, 1-122 maximum number of servers, 1-123 minimum number of queries, 1-125 PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1-120 PARALLEL_AUTOMATIC_TUNING initialization parameter, 1-121 PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1-122 PARALLEL_INSTANCE_GROUP initialization parameter, 1-122 PARALLEL_MAX_SERVERS initialization parameter, 1-123 PARALLEL_MIN_PERCENT initialization parameter, 1-124 PARALLEL_MIN_SERVERS initialization parameter, 1-125 PARALLEL_THREADS_PER_CPU initialization parameter, 1-126 PARSED_PIECES view, 2-250 PARSED_SIZE view, 2-250 PARTITION_VIEW_ENABLED initialization parameter, 1-126 partitions raw, 1-75 passwords authenticating, 1-119, 1-140 REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-139 PCM lock mapping blocks to, 1-60 performance, 1-3 rule-based optimization, 1-114 shared pool, 1-64, 1-149, 1-151 PGA_AGGREGATE_TARGET initialization parameter, 1-127 pins on KGL objects, 2-188 PLAN_TABLE execution plan table, 2-250 PLSQL_COMPILER_FLAGS initialization parameter, 1-128 PLSQL_NATIVE_C_COMPILER initialization parameter, 1-129 PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1-129 PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1-129 PLSQL_NATIVE_LINKER initialization parameter, 1-130 PLSQL_NATIVE_MAKE_FILE_NAME initialization parameter, 1-130 PLSQL_NATIVE_MAKE_UTILITY initialization parameter, 1-131 PLSQL_V2_COMPATIBILITY initialization parameter, 1-131 PLUGGABLE_SET_CHECK view, 2-252 PRE_PAGE_SGA initialization parameter, 1-132 privileges remote login, 1-139 RESTRICTED_SESSION privilege, 1-71, 1-72 table-level select privileges, 1-157, 1-159 procedures shared pool, 1-64, 1-149, 1-151 processes derived parameter values, 1-165 dispatcher process maximum number, 1-92 maximum shared server processes, 1-94 number of server processes, 1-68, 1-69, 1-133, 1-151, 1-152 recovery, 1-134, 1-136 trace files, 1-169 user processes, 1-133 PROCESSES initialization parameter, 1-133 PRODUCT_COMPONENT_VERSION view, 2-253 profiles resource limits, 1-141, 1-142 PROXY_USERS view, 2-253 PSTUBTBL view, 2-254 PUBLIC clause of ALTER DATABASE thread of redo, 1-160 PUBLIC_DEPENDENCY view, 2-254 PUBLICSYN view, 2-254 -------------------------------------------------------------------------------- Q queries dictionary views, 1-60 hints, 1-114 QUERY_REWRITE_ENABLED initialization parameter, 1-133 QUERY_REWRITE_INTEGRITY initialization parameter, 1-134 QUEUE_PRIVILEGES view, 2-255 -------------------------------------------------------------------------------- R raw partition LOG_ARCHIVE_DEST initialization parameter, 1-75 RC_ARCHIVED_LOG view, 2-4 RC_BACKUP_CONTROLFILE view, 2-4 RC_BACKUP_CORRUPTION view, 2-4 RC_BACKUP_DATAFILE view, 2-4 RC_BACKUP_PIECE view, 2-4 RC_BACKUP_REDOLOG view, 2-4 RC_BACKUP_SET view, 2-4 RC_BACKUP_SPFILE view, 2-4 RC_CHECKPOINT view, 2-4 RC_CONTROLFILE_COPY view, 2-4 RC_COPY_CORRUPTION view, 2-4 RC_DATABASE view, 2-4 RC_DATABASE_BLOCK_CORRUPTION view, 2-4 RC_DATABASE_INCARNATION view, 2-4 RC_DATAFILE view, 2-4 RC_DATAFILE_COPY view, 2-4 RC_LOG_HISTORY view, 2-4 RC_OFFLINE_RANGE view, 2-4 RC_PROXY_CONTROLFILE view, 2-4 RC_PROXY_DATAFILE view, 2-4 RC_REDO_LOG view, 2-4 RC_REDO_THREAD view, 2-4 RC_RESYNC view, 2-4 RC_RMAN_CONFIGURATION view, 2-4 RC_STORED_SCRIPT view, 2-4 RC_STORED_SCRIPT_LINE view, 2-4 RC_TABLESPACE view, 2-4 RDBMS_SERVER_DN initialization parameter, 1-135 READ_ONLY_OPEN_DELAYED initialization parameter, 1-136 recovery number of required processes, 1-134, 1-136 RECOVERY_PARALLELISM initialization parameter, 1-136 redo logs buffer size, 1-85 redo thread, 1-160 remote clients authenticating, 1-140 remote logins, 1-139 REMOTE_ARCHIVE_ENABLE initialization parameter, 1-137 REMOTE_DEPENDENCIES_MODE initialization parameter, 1-138 REMOTE_LISTENER initialization parameter, 1-138 REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-139 REMOTE_OS_AUTHENT initialization parameter, 1-140 REMOTE_OS_ROLES initialization parameter, 1-140 REPAIR_TABLE view. See DBA_REPAIR_TABLE view. REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1-141 resource limits for profiles, 1-141, 1-142 RESOURCE_COST view, 2-255 RESOURCE_LIMIT initialization parameter, 1-141 RESOURCE_MANAGER_PLAN initialization parameter, 1-142 RESOURCE_MAP table, 2-255 RMJVM.SQL script, 5-8 ROLE_ROLE_PRIVS view, 2-256 ROLE_SYS_PRIVS view, 2-256 ROLE_TAB_PRIVS view, 2-256 ROLE_WM_PRIVS view, 2-3 roles, 1-120 remote clients, 1-140 rollback segments maximum size, 1-94 ROLLBACK_SEGMENTS initialization parameter, 1-143 ROW_LOCKING initialization parameter, 1-144 rule-based optimization, 1-114 -------------------------------------------------------------------------------- S scripts CATALOG.SQL, 5-2 CATBLOCK.SQL, 5-3 CATCLUST.SQL, 5-2 CATEXP7.SQL, 5-3 CATHS.SQL, 5-3 CATIO.SQL, 5-3 CATJAVA.SQL, 5-8 CATNOADT.SQL, 5-6 CATNOAUD.SQL, 5-6 CATNOHS.SQL, 5-6 CATNOPRT.SQL, 5-6 CATNOQUE.SQL, 5-6 CATNORMN.SQL, 5-6 CATNOSVM.SQL, 5-6 CATNSNMP.SQL, 5-6 CATOCTK.SQL, 5-3 CATPROC.SQL, 5-2 CATQUEUE.SQL, 5-3 CATREP.SQL, 5-3 CATRMAN.SQL, 5-3 CMPDBMIG.SQL, 5-7 D0801070.SQL, 5-7 D0900010.SQL, 5-7 data dictionary, 5-3 database migration, 5-7 DBMSIOTC.SQL, 5-3 DBMSOTRC.SQL, 5-3 DBMSPOOL.SQL, 5-4 INITJVM.SQL, 5-8 Java, 5-8 RMJVM.SQL, 5-8 SQL scripts, 5-2 U0703040.SQL, 5-7 U0800060.SQL, 5-7 U0801070.SQL, 5-7 U0900010.SQL, 5-7 USERLOCK.SQL, 5-4 UTLBSTAT.SQL, 5-4 UTLCHN1.SQL, 5-4 UTLCONST.SQL, 5-4 UTLDTREE.SQL, 5-4 UTLESTAT.SQL, 5-4 UTLEXPT1.SQL, 5-4 UTLINCMP.SQL, 5-7 UTLIP.SQL, 5-4 UTLIRP.SQL, 5-5 UTLLOCKT.SQL, 5-5 UTLPWDMG.SQL, 5-5 UTLRP.SQL, 5-5 UTLSAMPL.SQL, 5-5 UTLSCLN.SQL, 5-5 UTLTKPRF.SQL, 5-5 UTLVALID.SQL, 5-5 UTLXPLAN.SQL, 5-5 SEQ synonym for USER_SEQUENCES view, 2-256 SERIAL_REUSE initialization parameter, 1-145 server parameter file overview, 1-4 server processes number, 1-68, 1-69, 1-133, 1-151, 1-152 SERVICE_NAMES initialization parameter, 1-146 SESSION_CACHED_CURSORS initialization parameter, 1-146 SESSION_CONTEXT view, 2-257 SESSION_MAX_OPEN_FILES initialization parameter, 1-147 SESSION_PRIVS view, 2-257 SESSION_ROLES view, 2-257 SESSIONS initialization parameter, 1-148 SGA_MAX_SIZE initialization parameter, 1-148 SHADOW_CORE_DUMP initialization parameter, 1-149 shared server SESSIONS initialization parameter, 1-148 shared server dispatcher request statistics, 3-119 shared server processes maximum number, 1-94 SHARED_MEMORY_ADDRESS initialization parameter, 1-149 SHARED_POOL_RESERVED_SIZE initialization parameter, 1-150 V$SHARED_POOL_RESERVED, 3-142 SHARED_POOL_SIZE initialization parameter, 1-151 SHARED_SERVER_SESSIONS initialization parameter, 1-151 SHARED_SERVERS initialization parameter, 1-152 SHOW PARAMETERS command, 1-11 SORT_AREA_RETAINED_SIZE initialization parameter, 1-152 SORT_AREA_SIZE initialization parameter, 1-153 sorting maximum memory, 1-152 ORDER BY queries, 1-101 SOURCE_SIZE view, 2-257 SPFILE initialization parameter, 1-155 SQL scripts creating the data dictionary, 5-2 optional, 5-3 required, 5-2 SQL_TRACE initialization parameter, 1-156 SQL92_SECURITY initialization parameter, 1-157 STANDBY_ARCHIVE_DEST initialization parameter, 1-157 STANDBY_FILE_MANAGEMENT initialization parameter, 1-158 STAR_TRANSFORMATION_ENABLED initialization parameter, 1-159 starting up database name, 1-44 instance number, 1-67 startup order, 1-67 STARTUP statement database name, 1-44 statistics background checkpoints completed, C-3 background checkpoints started, C-3 branch node splits, C-3 buffer is not pinned count, C-3 buffer is pinned count, C-3 bytes received via SQL*Net from client, C-3 bytes received via SQL*Net from dblink, C-3 bytes sent via SQL*Net to client, C-3 bytes sent via SQL*Net to dblink, C-3 Cached Commit SCN referenced, C-3 calls to get snapshot scn kcmgss, C-3 calls to kcmgas, C-3 calls to kcmgcs, C-4 calls to kcmgrs, C-4 change write time, C-4 cleanouts and rollbacks - consistent read gets, C-4 cleanouts only - consistent read gets, C-4 cluster key scan block gets, C-4 cluster key scans, C-4 cold recycle reads, C-4 commit cleanout failures block lost, C-4 buffer being written, C-4 callback failure, C-4 cannot pin, C-4 hot backup in progress, C-4 write disabled, C-4 commit cleanouts, C-4 commit cleanouts successfully completed, C-5 Commit SCN cached, C-5 consistent changes, C-5 consistent gets, C-5 CPU used by this session, C-5 CPU used when call started, C-5 CR blocks created, C-5 cross instance CR read, C-6 current blocks converted for CR, C-5 cursor authentication, C-5 data blocks consistent reads - undo records applied, C-5 db block changes, C-6 db block gets, C-6 DBWR buffers scanned, C-6 DBWR checkpoint buffers written, C-6 DBWR checkpoints, 1-86, C-6 DBWR cross instance writes, C-6 DBWR free buffers found, C-6 DBWR lru scans, C-6 DBWR make free requests, C-6 DBWR revisited being-written buffer, C-7 DBWR summed scan depth, C-7 DBWR transaction table writes, C-7 DBWR undo block writes, C-7 DDL statements parallelized, C-7 deferred (CURRENT) block cleanout applications, C-7 DFO trees parallelized, C-7 dirty buffers inspected, C-7 DML statements parallelized, C-7 enqueue conversions, C-7 enqueue deadlocks, C-7 enqueue releases, C-7 enqueue requests, C-7 enqueue timeouts, C-8 enqueue waits, C-8 exchange deadlocks, C-8 execute count, C-8 free buffer inspected, C-8 free buffer requested, C-8 global cache blocks corrupt, C-8 global cache cr block log flush time, C-9 global cache cr block send time, C-9 global cache cr timeouts, C-9 global cache defers, C-9 global cache freelist waits, C-9 global cache get time, C-9 global cache gets, C-9 global cache prepare failures, C-9 global lock async converts, C-9 global lock async gets, C-9 global lock convert time, C-9 global lock get time, C-9 global lock release time, C-10 global lock releases, C-10 global lock sync converts, C-10 global lock sync gets, C-10 hot buffers moved to head of LRU, C-10 immediate (CR) block cleanout applications, C-10 immediate (CURRENT) block cleanout applications, C-10 index fast full scans (direct read), C-10 index fast full scans (full), C-10 index fast full scans (rowid ranges), C-10 instance recovery database freeze count, C-10 kcmccs called get current scn, C-10 kcmccs read scn without going to DLM, C-10 kcmggs waited for batching, C-10 leaf node splits, C-10 logons cumulative, C-10 logons current, C-10 messages received, C-10 messages sent, C-10 native hash arithmetic execute, C-11 native hash arithmetic fail, C-11 next scns gotten without going to DLM, C-11 no buffer to keep pinned count, C-11 no work - consistent read gets, C-11 opened cursors cumulative, C-11 opened cursors current, C-11 opens of replaced files, C-11 opens requiring cache replacement, C-11 operating system OS All other sleep time, C-11 OS Chars read and written, C-11 OS Data page fault sleep time, C-11 OS Input blocks, C-11 OS Involuntary context switches, C-12 OS Kernel page fault sleep time, C-12 OS Major page faults, C-12 OS Messages received, C-12 OS Messages sent, C-12 OS Minor page faults, C-12 OS Other system trap CPU time, C-12 OS Output blocks, C-12 OS Process heap time, C-12 OS Signals received, C-12 OS Swaps, C-12 OS System call CPU time, C-12 OS System calls, C-12 OS Text page fault sleep time, C-12 OS User level CPU time, C-12 OS User lock wait sleep time, C-12 OS Voluntary context switches, C-12 OS Wait-cpu (latency) time, C-12 Process stack size, C-12 OS Input blocks, C-12 Parallel operations downgraded 1 to 25 pct, C-13 Parallel operations downgraded 25 to 50 pct, C-13 Parallel operations downgraded 50 to 75 pct, C-13 Parallel operations downgraded 75 to 99 pct, C-13 Parallel operations downgraded to serial, C-13 Parallel operations not downgraded, C-13 parse count (hard), C-13 parse count (total), C-13 parse time cpu, C-13 parse time elapsed, C-13 physical reads, C-13 physical reads direct, C-13 physical writes, C-14 physical writes direct, C-14 physical writes non checkpoint, C-14 pinned buffers inspected, C-14 prefetched blocks, C-14 prefetched blocks aged out before use, C-14 process last non-idle time, C-14 PX local messages recv'd, C-14 PX local messages sent, C-14 PX remote messages recv'd, C-14 PX remote messages sent, C-14 queries parallelized, C-14 recovery array read time, C-14 recovery array reads, C-14 recovery blocks read, C-15 recursive calls, C-15 recursive cpu usage, C-15 redo blocks written, C-15 redo buffer allocation retries, C-15 redo entries, C-15 redo log space requests, C-15 redo log space wait time, C-15 redo log switch interrupts, C-15 redo ordering marks, C-16 redo size, C-16 redo sync writes, C-16 redo synch time, C-16 redo wastage, C-16 redo write time, C-16 redo writer latching time, C-16 redo writes, C-16 remote instance undo block writes, C-16 remote instance undo header writes, C-16 rollback changes - undo records applied, C-16 rollbacks only - consistent read gets, C-16 rows fetched via callback, C-16 serializable aborts, C-17 session connect time, C-17 session cursor cache count, C-17 session cursor cache hits, C-17 session logical reads, C-17 session pga memory, C-17 session pga memory max, C-17 session stored procedure space, C-17 session uga memory, C-17 session uga memory max, C-17 sorts (disk), C-17 sorts (memory), C-18 sorts (rows), C-18 SQL*Net roundtrips to/from client, C-18 SQL*Net roundtrips to/from dblink, C-18 summed dirty queue length, C-18 switch current to new buffer, C-18 table fetch by rowid, C-18 table fetch continued row, C-18 table scan blocks gotten, C-19 table scan rows gotten, C-19 table scans (cache partitions), C-19 table scans (direct read), C-19 table scans (long tables), C-19 table scans (rowid ranges), C-19 table scans (short tables), C-19 timed, 1-162 total file opens, C-19 transaction lock background get time, C-19 transaction lock background gets, C-19 transaction lock foreground requests, C-19 transaction lock foreground wait time, C-19 transaction rollbacks, C-19 transaction tables consistent read rollbacks, C-20 transaction tables consistent reads - undo records applied, C-20 Unnecessary process cleanup for SCN batching, C-20 user calls, C-20 user commits, C-20 user rollbacks, C-20 write clones created in background, C-20 write clones created in foreground, C-20 STATISTICS_LEVEL initialization parameter, 1-159 STMT_AUDIT_OPTION_MAP table, 2-258 switch redo log file, 1-86 SYN synonym for USER_SYNONYMS view, 2-258 SYNONYMS view, 2-258 SYS_OBJECTS view, 2-259 SYSCATALOG view, 2-258 SYSFILES view, 2-258 SYSSEGOBJ view, 2-258 system global area, 1-3 buffer areas, 1-85 maximum concurrent transactions, 1-165 rollback segment size, 1-94 system performance, 1-3 SYSTEM_PRIVILEGE_MAP table, 2-258 -------------------------------------------------------------------------------- T TAB view, 2-259 TABLE_PRIVILEGE_MAP table, 2-259 TABLE_PRIVILEGES view, 2-259 tables data dictionary, 2-1 DML locks, 1-53 locating free space, 1-67 row locking, 1-144 TABQUOTAS view, 2-260 TABS synonym for USER_TABLES view, 2-260 tape archiving destination, 1-75 TAPE_ASYNCH_IO initialization parameter, 1-160 territory, 1-98, 1-102 THREAD initialization parameter, 1-160 TIMED_OS_STATISTICS initialization parameter, 1-161 TIMED_STATISTICS initialization parameter, 1-162 file read/write statistics, 3-58, 3-182 TO_CHAR function, 1-97 TO_DATE function, 1-97 trace files destination, 1-169 maximum size, 1-93 TRACE_ENABLED initialization parameter, 1-163 TRACEFILE_IDENTIFIER initialization parameter, 1-163 TRANSACTION_AUDITING initialization parameter, 1-164 transactions concurrent, 1-165 data locking, 1-53 TRANSACTIONS initialization parameter, 1-165 DML locks, 1-53 TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1-165 TRUSTED_SERVERS view, 2-260 TS_PITR_CHECK view, 2-261 TS_PITR_OBJECTS TO_BE_DROPPED view, 2-262 -------------------------------------------------------------------------------- U U0703040.SQL script, 5-7 U0800060.SQL script, 5-7 U0801070.SQL script, 5-7 U0900010.SQL script, 5-7 UNDO_MANAGEMENT initialization parameter, 1-166 UNDO_RETENTION initialization parameter, 1-166 UNDO_SUPPRESS_ERRORS initialization parameter, 1-167 UNDO_TABLESPACE initialization parameter, 1-168 UNI_PLUGGABLE_SET_CHECK view, 2-262 updates locating free space, 1-67 transaction processing option, 1-144 uppercase characters, 1-5 USE_INDIRECT_DATA_BUFFERS initialization parameter, 1-168 user processes trace files, 1-169 USER_ALL_TABLES view, 2-263 USER_AQ_AGENT_PRIVS view, 2-263 USER_ARGUMENTS view, 2-263 USER_ASSOCIATIONS view, 2-264 USER_ATTRIBUTE_TRANSFORMATIONS view, 2-264 USER_AUDIT_OBJECT view, 2-264 USER_AUDIT_POLICIES view, 2-264 USER_AUDIT_SESSION view, 2-264 USER_AUDIT_STATEMENT view, 2-264 USER_AUDIT_TRAIL view, 2-265 USER_AW_PS view, 2-265 USER_AWS view, 2-265 USER_BASE_TABLE_MVIEWS view, 2-265 USER_CATALOG view, 2-266 CAT synonym, 2-153 USER_CLU_COLUMNS view, 2-266 USER_CLUSTER_HASH_EXPRESSIONS view, 2-266 USER_CLUSTERS view, 2-266 CLU synonym, 2-155 USER_COL_COMMENTS view, 2-266 USER_COL_PRIVS view, 2-266 USER_COL_PRIVS_MADE view, 2-267 USER_COL_PRIVS_RECD view, 2-267 USER_COLL_TYPES view, 2-267 USER_CONS_COLUMNS view, 2-267 USER_CONS_OBJ_COLUMNS view, 2-267 USER_CONSTRAINTS view, 2-268 USER_DB_LINKS view, 2-268 USER_DEPENDENCIES view, 2-268 USER_DIM_ATTRIBUTES view, 2-268 USER_DIM_CHILD_OF view, 2-268 USER_DIM_HIERARCHIES view, 2-268 USER_DIM_JOIN_KEY view, 2-269 USER_DIM_LEVEL_KEY view, 2-269 USER_DIM_LEVELS view, 2-269 USER_DIMENSIONS view, 2-269 USER_DUMP_DEST initialization parameter, 1-169 USER_ERRORS view, 2-269 USER_EVALUATION_CONTEXT_TABLES view, 2-269 USER_EVALUATION_CONTEXT_VARS view, 2-270 USER_EVALUATION_CONTEXTS view, 2-270 USER_EXTENTS view, 2-270 USER_EXTERNAL_LOCATIONS view, 2-270 USER_EXTERNAL_TABLES view, 2-270 USER_FREE_SPACE view, 2-271 USER_IND_COLUMNS view, 2-271 USER_IND_EXPRESSIONS view, 2-271 USER_IND_PARTITIONS view, 2-271 USER_IND_SUBPARTITIONS view, 2-271 USER_INDEXES view, 2-271 IND synonym, 2-247 USER_INDEXTYPE_COMMENTS view, 2-272 USER_INDEXTYPE_OPERATORS view, 2-272 USER_INDEXTYPES view, 2-272 USER_INTERNAL_TRIGGERS view, 2-272 USER_JAVA_ARGUMENTS view, 2-272 USER_JAVA_CLASSES view, 2-273 USER_JAVA_DERIVATIONS view, 2-273 USER_JAVA_FIELDS view, 2-273 USER_JAVA_IMPLEMENTS view, 2-273 USER_JAVA_INNERS view, 2-273 USER_JAVA_LAYOUTS view, 2-274 USER_JAVA_METHODS view, 2-274 USER_JAVA_NCOMPS view, 2-274 USER_JAVA_POLICY view, 2-274 USER_JAVA_RESOLVERS view, 2-274 USER_JAVA_THROWS view, 2-275 USER_JOBS view, 2-275 USER_JOIN_IND_COLUMNS view, 2-275 USER_LIBRARIES view, 2-275 USER_LOB_PARTITIONS view, 2-275 USER_LOB_SUBPARTITIONS view, 2-275 USER_LOB_TEMPLATES view, 2-276 USER_LOBS view, 2-276 USER_LOG_GROUP_COLUMNS view, 2-276 USER_LOG_GROUPS view, 2-276 USER_METHOD_PARAMS view, 2-276 USER_METHOD_RESULTS view, 2-276 USER_MVIEW_AGGREGATES view, 2-277 USER_MVIEW_ANALYSIS view, 2-277 USER_MVIEW_DETAIL_RELATIONS view, 2-277 USER_MVIEW_JOINS view, 2-277 USER_MVIEW_KEYS view, 2-277 USER_MVIEW_LOGS view, 2-278 USER_MVIEW_REFRESH_TIMES view, 2-278 USER_MVIEWS view, 2-278 USER_NESTED_TABLES view, 2-278 USER_OBJ_AUDIT_OPTS view, 2-278 USER_OBJ_COLATTRS view, 2-278 USER_OBJECT_SIZE view, 2-279 USER_OBJECT_TABLES view, 2-279 USER_OBJECTS view, 2-279 OBJ synonym, 2-250 USER_OPANCILLARY view, 2-279 USER_OPARGUMENTS view, 2-279 USER_OPBINDINGS view, 2-279 USER_OPERATOR_COMMENTS view, 2-279 USER_OPERATORS view, 2-280 USER_OUTLINE_HINTS view, 2-280 USER_OUTLINES view, 2-280 USER_PART_COL_STATISTICS view, 2-280 USER_PART_HISTOGRAMS view, 2-280 USER_PART_INDEXES view, 2-280 USER_PART_KEY_COLUMNS view, 2-281 USER_PART_LOBS view, 2-281 USER_PART_TABLES view, 2-281 USER_PARTIAL_DROP_TABS view, 2-281 USER_PASSWORD_LIMITS view, 2-281 USER_PENDING_CONV_TABLES view, 2-282 USER_POLICIES view, 2-282 USER_POLICY_CONTEXTS view, 2-282 USER_POLICY_GROUPS view, 2-282 USER_PROCEDURES view, 2-282 USER_PROXIES view, 2-283 USER_PUBLISHED_COLUMNS view, 2-283 USER_QUEUE_SCHEDULES view, 2-283 USER_QUEUE_TABLES view, 2-283 USER_QUEUES view, 2-284 USER_REFRESH view, 2-284 USER_REFRESH_CHILDREN view, 2-284 USER_REFS view, 2-284 USER_REGISTERED_MVIEWS view, 2-284 USER_REGISTRY view, 2-284 USER_REPAUDIT_ATTRIBUTE view, 2-2 USER_REPAUDIT_COLUMN view, 2-2 USER_REPCAT view, 2-2 USER_REPCAT_REFRESH_TEMPLATES view, 2-2 USER_REPCAT_TEMPLATE_OBJECTS view, 2-2 USER_REPCAT_TEMPLATE_PARMS view, 2-2 USER_REPCAT_TEMPLATE_SITES view, 2-2 USER_REPCAT_USER_AUTHORIZATION view, 2-2 USER_REPCAT_USER_PARM_VALUES view, 2-2 USER_REPCATLOG view, 2-2 USER_REPCOLUMN view, 2-2 USER_REPCOLUMN_GROUP view, 2-2 USER_REPCONFLICT view, 2-2 USER_REPDDL view, 2-2 USER_REPFLAVOR_COLUMNS view, 2-2 USER_REPFLAVOR_OBJECTS view, 2-2 USER_REPFLAVORS view, 2-2 USER_REPGENERATED view, 2-2 USER_REPGENOBJECTS view, 2-2 USER_REPGROUP view, 2-2 USER_REPGROUP_PRIVILEGES view, 2-2 USER_REPGROUPED_COLUMN view, 2-2 USER_REPKEY_COLUMNS view, 2-2 USER_REPOBJECT view, 2-2 USER_REPPARAMETER_COLUMN view, 2-2 USER_REPPRIORITY view, 2-2 USER_REPPRIORITY_GROUP view, 2-2 USER_REPPROP view, 2-2 USER_REPRESOL_STATS_CONTROL view, 2-2 USER_REPRESOLUTION view, 2-2 USER_REPRESOLUTION_METHOD view, 2-2 USER_REPRESOLUTION_STATISTICS view, 2-2 USER_REPSCHEMA view, 2-2 USER_REPSITES view, 2-2 USER_RESOURCE_LIMITS view, 2-285 USER_RESUMABLE view, 2-285 USER_ROLE_PRIVS view, 2-285 USER_RSRC_CONSUMER_GROUP_PRIVS view, 2-285 USER_RSRC_MANAGER_SYSTEM_PRIVS view, 2-286 USER_RULE_SET_RULES view, 2-286 USER_RULE_SETS view, 2-286 USER_RULES view, 2-286 USER_SEGMENTS view, 2-286 USER_SEQUENCES view, 2-286 SEQ synonym, 2-256 USER_SOURCE view, 2-287 USER_SOURCE_TABLES view, 2-287 USER_SQLJ_TYPE_ATTRS view, 2-287 USER_SQLJ_TYPE_METHODS view, 2-287 USER_SQLJ_TYPES view, 2-287 USER_STORED_SETTINGS view, 2-287 USER_SUBPART_COL_STATISTICS view, 2-288 USER_SUBPART_HISTOGRAMS view, 2-288 USER_SUBPART_KEY_COLUMNS view, 2-288 USER_SUBPARTITION_TEMPLATES view, 2-288 USER_SUBSCRIBED_COLUMNS view, 2-288 USER_SUBSCRIBED_TABLES view, 2-289 USER_SUBSCRIPTIONS view, 2-289 USER_SYNONYMS view, 2-289 SYN synonym, 2-258 USER_SYS_PRIVS view, 2-289 USER_TAB_COL_STATISTICS view, 2-289 USER_TAB_COLUMNS view, 2-289 COLS synonym, 2-156 USER_TAB_COMMENTS view, 2-289 USER_TAB_HISTOGRAMS view, 2-290 USER_TAB_MODIFICATIONS view, 2-290 USER_TAB_PARTITIONS view, 2-290 USER_TAB_PRIVS view, 2-290 USER_TAB_PRIVS_MADE view, 2-290 USER_TAB_PRIVS_RECD view, 2-291 USER_TAB_SUBPARTITIONS view, 2-291 USER_TABLES view, 2-291 TABS synonym, 2-260 USER_TABLESPACES view, 2-291 USER_TRANSFORMATIONS view, 2-291 USER_TRIGGER_COLS view, 2-292 USER_TRIGGERS view, 2-292 USER_TS_QUOTAS view, 2-292 USER_TYPE_ATTRS view, 2-292 USER_TYPE_METHODS view, 2-292 USER_TYPE_VERSIONS view, 2-292 USER_TYPES view, 2-293 USER_UNUSED_COL_TABS view, 2-293 USER_UPDATABLE_COLUMNS view, 2-293 USER_USERS view, 2-293 USER_USTATS view, 2-293 USER_VARRAYS view, 2-293 USER_VIEWS view, 2-294 USER_WM_LOCKED_TABLES view, 2-3 USER_WM_MODIFIED_TABLES view, 2-3 USER_WM_PRIVS view, 2-3 USER_WM_RIC_INFO view, 2-3 USER_WM_TAB_TRIGGERS view, 2-3 USER_WM_VERSIONED_TABLES view, 2-3 USER_WM_VT_ERRORS view, 2-3 USER_WORKSPACE_PRIVS view, 2-3 USER_WORKSPACE_SAVEPOINTS view, 2-3 USER_WORKSPACES view, 2-3 USER_XML_SCHEMAS view, 2-294 USER_XML_TAB_COLS view, 2-294 USER_XML_TABLES view, 2-294 USER_XML_VIEW_COLS view, 2-294 USER_XML_VIEWS view, 2-294 USERLOCK.SQL script, 5-4 users authenticating, 1-119 multiple, 1-53 UTL_FILE_DIR initialization parameter, 1-169 UTLBSTAT.SQL script, 5-4 UTLCHN1.SQL script, 5-4 UTLCONST.SQL script, 5-4 UTLDTREE.SQL script, 2-236, 5-4 utldtree.sql script, 2-246 UTLESTAT.SQL script, 5-4 UTLEXPT1.SQL script, 5-4 UTLINCMP.SQL script, 5-7 UTLIP.SQL script, 5-4 UTLIRP.SQL script, 5-5 UTLLOCKT.SQL script, 5-5 UTLPWDMG.SQL script, 5-5 UTLRP.SQL script, 5-5 UTLSAMPL.SQL script, 5-5 UTLSCLN.SQL script, 5-5 UTLTKPRF.SQL script, 5-5 UTLVALID.SQL script, 5-5 UTLXPLAN.SQL script, 5-5 -------------------------------------------------------------------------------- V V$ACCESS view, 3-4 V$ACTIVE_INSTANCES view, 3-4 V$ACTIVE_SESS_POOL_MTH view, 3-4 V$AQ view, 3-4 V$ARCHIVE view, 3-5 V$ARCHIVE_DEST view, 3-5 V$ARCHIVE_DEST_STATUS view, 3-8 V$ARCHIVE_GAP view, 3-10 V$ARCHIVE_PROCESSES view, 3-10 V$ARCHIVED_LOG view, 3-10 V$BACKUP view, 3-12 V$BACKUP_ASYNC_IO view, 3-13 V$BACKUP_CORRUPTION view, 3-14 V$BACKUP_DATAFILE view, 3-15 V$BACKUP_DEVICE view, 3-16 V$BACKUP_PIECE view, 3-17 V$BACKUP_REDOLOG view, 3-18 V$BACKUP_SET view, 3-18 V$BACKUP_SPFILE view, 3-20 V$BACKUP_SYNC_IO view, 3-20 V$BGPROCESS view, 3-21 V$BH view, 3-21 V$BUFFER_POOL view, 3-23 V$BUFFER_POOL_STATISTICS view, 3-24 V$CACHE view, 3-25 V$CACHE_LOCK view, 3-26 V$CACHE_TRANSFER view, 3-29 V$CIRCUIT view, 3-30 V$CLASS_CACHE_TRANSFER view, 3-31 V$COMPATIBILITY view, 3-31 V$COMPATSEG view, 3-32 V$CONTEXT view, 3-32 V$CONTROLFILE view, 3-32 V$CONTROLFILE_RECORD_SECTION view, 3-32 V$COPY_CORRUPTION view, 3-33 V$CR_BLOCK_SERVER view, 3-34 V$DATABASE view, 3-35 V$DATABASE_BLOCK_CORRUPTION view, 3-38 V$DATABASE_INCARNATION view, 3-39 V$DATAFILE view, 3-39 V$DATAFILE_COPY view, 3-41 V$DATAFILE_HEADER view, 3-42 V$DATAGUARD_STATUS view, 3-43 V$DB_CACHE_ADVICE view, 3-44 V$DB_OBJECT_CACHE view, 3-45 V$DB_PIPES view, 3-46 V$DBFILE view, 3-46 V$DBLINK view, 3-46 V$DELETED_OBJECT view, 3-47 V$DISPATCHER view, 3-47 V$DISPATCHER_RATE view, 3-48 V$ENABLEDPRIVS view, 3-53 V$ENQUEUE_LOCK view, 3-53 V$ENQUEUE_STAT view, 3-54 V$EVENT_NAME view, 3-55 V$EXECUTION view, 3-55 V$FALSE_PING view, 3-55 V$FAST_START_SERVERS view, 3-56 V$FAST_START_TRANSACTIONS view, 3-57 V$FILE_CACHE_TRANSFER view, 3-57 V$FILESTAT view, 3-58 V$FIXED_TABLE view, 3-59 V$FIXED_VIEW_DEFINITION view, 3-59 V$GC_ELEMENT view, 3-60 V$GC_ELEMENTS_WITH_COLLISIONS view, 3-60 V$GCSHVMASTER_INFO view, 3-61 V$GCSPFMASTER_INFO view, 3-61 V$GES_BLOCKING_ENQUEUE view, 3-61 V$GES_CONVERT_LOCAL view, 3-63 V$GES_CONVERT_REMOTE view, 3-63 V$GES_ENQUEUE view, 3-64 V$GES_LATCH view, 3-65 V$GES_RESOURCE view, 3-65 V$GES_STATISTICS view, 3-66 V$GLOBAL_BLOCKED_LOCKS view, 3-66 V$GLOBAL_TRANSACTION view, 3-66 V$HS_AGENT view, 3-67 V$HS_PARAMETER view, 3-67 V$HS_SESSION view, 3