Ora9iSQLRef.chm A ACTIVE_INSTANCE_COUNT initializa

文件名称: Ora9iSQLRef.chm

所属分类: Oracle

开发工具:

文件大小: 6mb

下载次数: 0

上传时间: 2013-04-26

提供者: hanqi*****

下载 (6mb)

不能下载？报告错误

详细说明： 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 ...展开收缩

(系统自动生成,下载前可以参看下载内容)