Oracle DatabaseReference 10g Release 1 (10.1)Part No. B10755-01

December 2003

Oracle Database Reference, 10g Release 1 (10.1) Part No. B10755-01 Copyright 2002, 2003, Oracle. All rights reserved. Primary Author: Tony Morales

Contributors: Nipun Agarwal, Rick Anderson, Mark Bauer, Ruth Baylis, Neerja Bhatt, Tudor Bosman, George Candea, Wilson Chan, Sumanta Chatterjee, Eugene Chong, Connie Dialeris Green, Harvey Eneman, Bruce Ernst, Ira Greenberg, Steve Harris, Thuvan Hoang, Lilian Hobbs, Namit Jain, Hakkan Jakobsson, Bob Jenkins, Mark Johnson, Jonathan Klein, Sushil Kumar, Tirthankar Lahiri, Bill Lee, Yunrui Li, Juan Loaiza, Rich Long, Diana Lorentz, Catherine Luu, Neil MacNaughton, Shankar Raman, Ari Mozes, Gopal Mulagund, Subramanian Muralidhar, Ravi Murthy, Karuna Muthiah, Arvind Nithrakashyap, Ronald Obermarck, Kant Patel, Christopher Racicot, Mark Ramacher, Suvendu Ray, Ann Rhee, Vivian Schupmann, Debbie Steiner, Seema Sundara, Juan Tellez, Alex Tsukerman, Kothanda Umamageswaran, Randy Urbano, Steve Vivian, Eric Voss, Tak Wang, Steve Wertheimer, Andy Witkowski, Daniel Wong, Graham Wood, Brian Wright, Aravind Yalamanchi, Qin Yu, Mohamed Ziauddin The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specied by law, is prohibited. The information contained in this document is subject to change without notice. If you nd any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose. If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specic supplemental regulations. As such, use, duplication, disclosure, modication, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065 The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs. Oracle is a registered trademark of Oracle Corporation and/or its afliates. Other names may be trademarks of their respective owners. The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fullling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.

ContentsSend Us Your Comments ................................................................................................................. xxxix Preface ................................................................................................................................................................ xliIntended Audience..................................................................................................................................... xli Documentation Accessibility .................................................................................................................... xli Structure...................................................................................................................................................... xlii Related Documents .................................................................................................................................. xliii Conventions .............................................................................................................................................. xliv

Whats New in Oracle Database Reference?............................................................................. xlixOracle Database 10g Release 1 (10.1) New Features............................................................................ xlix

Part I 1

Initialization Parameters

Initialization ParametersUses of Initialization Parameters .......................................................................................................... 1-1 Types of Initialization Parameters ................................................................................................... 1-2 Basic Initialization Parameters .............................................................................................................. 1-3 Parameter Files.......................................................................................................................................... 1-3 Server Parameter Files ....................................................................................................................... 1-3 Initialization Parameter Files............................................................................................................ 1-4 Changing Parameter Values in a Parameter File ................................................................................ 1-6 Parameters by Functional Category ................................................................................................ 1-6 Modifiable Parameters ................................................................................................................... 1-12 Displaying Current Parameter Values ......................................................................................... 1-15 Parameters You Should Not Specify in the Parameter File ...................................................... 1-16 When Parameters Are Set Incorrectly .......................................................................................... 1-16 Reading the Parameter Descriptions ................................................................................................. 1-16 Initialization Parameter Descriptions ............................................................................................... 1-17 ACTIVE_INSTANCE_COUNT .......................................................................................................... 1-17 AQ_TM_PROCESSES .......................................................................................................................... 1-18 ARCHIVE_LAG_TARGET .................................................................................................................. 1-18 ASM_DISKGROUPS ........................................................................................................................... 1-19 ASM_DISKSTRING............................................................................................................................. 1-20 ASM_POWER_LIMIT .......................................................................................................................... 1-20iii

AUDIT_FILE_DEST.............................................................................................................................. AUDIT_SYS_OPERATIONS .............................................................................................................. AUDIT_TRAIL ...................................................................................................................................... BACKGROUND_CORE_DUMP ....................................................................................................... BACKGROUND_DUMP_DEST ........................................................................................................ BACKUP_TAPE_IO_SLAVES............................................................................................................. BITMAP_MERGE_AREA_SIZE......................................................................................................... BLANK_TRIMMING........................................................................................................................... CIRCUITS............................................................................................................................................... CLUSTER_DATABASE........................................................................................................................ CLUSTER_DATABASE_INSTANCES .............................................................................................. CLUSTER_INTERCONNECTS.......................................................................................................... COMMIT_POINT_STRENGTH ........................................................................................................ COMPATIBLE ........................................................................................................................................ CONTROL_FILE_RECORD_KEEP_TIME ...................................................................................... CONTROL_FILES ................................................................................................................................. CORE_DUMP_DEST............................................................................................................................ CPU_COUNT ......................................................................................................................................... CREATE_BITMAP_AREA_SIZE........................................................................................................ CREATE_STORED_OUTLINES ........................................................................................................ CURSOR_SHARING ........................................................................................................................... CURSOR_SPACE_FOR_TIME ........................................................................................................... DB_nK_CACHE_SIZE.......................................................................................................................... DB_BLOCK_BUFFERS ........................................................................................................................ DB_BLOCK_CHECKING.................................................................................................................... DB_BLOCK_CHECKSUM .................................................................................................................. DB_BLOCK_SIZE ................................................................................................................................. DB_CACHE_ADVICE.......................................................................................................................... DB_CACHE_SIZE ................................................................................................................................. DB_CREATE_FILE_DEST ................................................................................................................... DB_CREATE_ONLINE_LOG_DEST_n ............................................................................................ DB_DOMAIN ........................................................................................................................................ DB_FILE_MULTIBLOCK_READ_COUNT ..................................................................................... DB_FILE_NAME_CONVERT............................................................................................................. DB_FILES................................................................................................................................................ DB_FLASHBACK_RETENTION_TARGET .................................................................................... DB_KEEP_CACHE_SIZE..................................................................................................................... DB_NAME .............................................................................................................................................. DB_RECOVERY_FILE_DEST............................................................................................................. DB_RECOVERY_FILE_DEST_SIZE.................................................................................................. DB_RECYCLE_CACHE_SIZE ............................................................................................................ DB_UNIQUE_NAME ........................................................................................................................... DB_WRITER_PROCESSES................................................................................................................. DBWR_IO_SLAVES.............................................................................................................................. DDL_WAIT_FOR_LOCKS .................................................................................................................. DG_BROKER_CONFIG_FILEn ......................................................................................................... DG_BROKER_START..........................................................................................................................

1-21 1-21 1-21 1-22 1-22 1-23 1-24 1-24 1-25 1-25 1-25 1-26 1-27 1-27 1-28 1-28 1-29 1-29 1-30 1-30 1-31 1-32 1-32 1-33 1-34 1-34 1-35 1-35 1-36 1-37 1-37 1-38 1-38 1-39 1-40 1-41 1-41 1-41 1-42 1-43 1-43 1-43 1-44 1-44 1-45 1-45 1-46

iv

DISK_ASYNCH_IO.............................................................................................................................. DISPATCHERS ...................................................................................................................................... DISTRIBUTED_LOCK_TIMEOUT................................................................................................... DML_LOCKS ......................................................................................................................................... ENQUEUE_RESOURCES.................................................................................................................... EVENT..................................................................................................................................................... FAL_CLIENT .......................................................................................................................................... FAL_SERVER ......................................................................................................................................... FAST_START_IO_TARGET................................................................................................................ FAST_START_MTTR_TARGET......................................................................................................... FAST_START_PARALLEL_ROLLBACK.......................................................................................... FILE_MAPPING .................................................................................................................................... FILEIO_NETWORK_ADAPTERS ..................................................................................................... FILESYSTEMIO_OPTIONS................................................................................................................ FIXED_DATE ......................................................................................................................................... GC_FILES_TO_LOCKS ....................................................................................................................... GCS_SERVER_PROCESSES............................................................................................................... GLOBAL_CONTEXT_POOL_SIZE ................................................................................................... GLOBAL_NAMES ................................................................................................................................ HASH_AREA_SIZE .............................................................................................................................. HI_SHARED_MEMORY_ADDRESS ............................................................................................... HS_AUTOREGISTER .......................................................................................................................... IFILE......................................................................................................................................................... INSTANCE_GROUPS .......................................................................................................................... INSTANCE_NAME............................................................................................................................... INSTANCE_NUMBER ......................................................................................................................... INSTANCE_TYPE ................................................................................................................................. JAVA_MAX_SESSIONSPACE_SIZE ................................................................................................. JAVA_POOL_SIZE ................................................................................................................................ JAVA_SOFT_SESSIONSPACE_LIMIT ............................................................................................. JOB_QUEUE_PROCESSES ................................................................................................................. LARGE_POOL_SIZE ............................................................................................................................ LDAP_DIRECTORY_ACCESS ........................................................................................................... LICENSE_MAX_SESSIONS ............................................................................................................... LICENSE_MAX_USERS ...................................................................................................................... LICENSE_SESSIONS_WARNING.................................................................................................... LOCAL_LISTENER .............................................................................................................................. LOCK_NAME_SPACE ......................................................................................................................... LOCK_SGA ............................................................................................................................................ LOG_ARCHIVE_CONFIG.................................................................................................................. LOG_ARCHIVE_DEST........................................................................................................................ LOG_ARCHIVE_DEST_n ................................................................................................................... LOG_ARCHIVE_DEST_STATE_n..................................................................................................... LOG_ARCHIVE_DUPLEX_DEST ..................................................................................................... LOG_ARCHIVE_FORMAT................................................................................................................. LOG_ARCHIVE_LOCAL_FIRST ...................................................................................................... LOG_ARCHIVE_MAX_PROCESSES ...............................................................................................

1-46 1-47 1-50 1-50 1-51 1-52 1-52 1-52 1-53 1-54 1-54 1-55 1-55 1-55 1-56 1-56 1-57 1-58 1-58 1-58 1-59 1-59 1-60 1-60 1-61 1-61 1-62 1-63 1-63 1-64 1-64 1-65 1-65 1-66 1-67 1-67 1-68 1-68 1-69 1-69 1-70 1-71 1-72 1-73 1-74 1-75 1-76

v

LOG_ARCHIVE_MIN_SUCCEED_DEST ....................................................................................... LOG_ARCHIVE_TRACE .................................................................................................................... LOG_BUFFER ........................................................................................................................................ LOG_CHECKPOINT_INTERVAL ..................................................................................................... LOG_CHECKPOINT_TIMEOUT ...................................................................................................... LOG_CHECKPOINTS_TO_ALERT .................................................................................................. LOG_FILE_NAME_CONVERT.......................................................................................................... LOGMNR_MAX_PERSISTENT_SESSIONS .................................................................................. MAX_COMMIT_PROPAGATION_DELAY .................................................................................... MAX_DISPATCHERS .......................................................................................................................... MAX_DUMP_FILE_SIZE .................................................................................................................... MAX_ENABLED_ROLES.................................................................................................................... MAX_SHARED_SERVERS ................................................................................................................. NLS_CALENDAR ................................................................................................................................. NLS_COMP ............................................................................................................................................ NLS_CURRENCY.................................................................................................................................. NLS_DATE_FORMAT.......................................................................................................................... NLS_DATE_LANGUAGE ................................................................................................................... NLS_DUAL_CURRENCY.................................................................................................................... NLS_ISO_CURRENCY ........................................................................................................................ NLS_LANGUAGE ................................................................................................................................ NLS_LENGTH_SEMANTICS ............................................................................................................ NLS_NCHAR_CONV_EXCP .............................................................................................................. NLS_NUMERIC_CHARACTERS...................................................................................................... NLS_SORT.............................................................................................................................................. NLS_TERRITORY................................................................................................................................. NLS_TIMESTAMP_FORMAT............................................................................................................ NLS_TIMESTAMP_TZ_FORMAT..................................................................................................... O7_DICTIONARY_ACCESSIBILITY ............................................................................................... OBJECT_CACHE_MAX_SIZE_PERCENT....................................................................................... OBJECT_CACHE_OPTIMAL_SIZE .................................................................................................. OLAP_PAGE_POOL_SIZE.................................................................................................................. OPEN_CURSORS ................................................................................................................................. OPEN_LINKS ........................................................................................................................................ OPEN_LINKS_PER_INSTANCE ....................................................................................................... OPTIMIZER_DYNAMIC_SAMPLING............................................................................................ OPTIMIZER_FEATURES_ENABLE .................................................................................................. OPTIMIZER_INDEX_CACHING...................................................................................................... OPTIMIZER_INDEX_COST_ADJ..................................................................................................... OPTIMIZER_MODE .......................................................................................................................... OS_AUTHENT_PREFIX .................................................................................................................... OS_ROLES............................................................................................................................................ PARALLEL_ADAPTIVE_MULTI_USER........................................................................................ PARALLEL_AUTOMATIC_TUNING ............................................................................................ PARALLEL_EXECUTION_MESSAGE_SIZE ................................................................................ PARALLEL_INSTANCE_GROUP ................................................................................................... PARALLEL_MAX_SERVERS............................................................................................................

1-76 1-77 1-78 1-79 1-80 1-81 1-81 1-82 1-82 1-83 1-84 1-84 1-85 1-85 1-86 1-86 1-87 1-87 1-88 1-88 1-89 1-89 1-90 1-90 1-91 1-91 1-92 1-92 1-93 1-93 1-94 1-94 1-95 1-95 1-96 1-96 1-97 1-99 1-99 1-100 1-100 1-101 1-102 1-102 1-103 1-103 1-104

vi

PARALLEL_MIN_PERCENT............................................................................................................ PARALLEL_MIN_SERVERS............................................................................................................. PARALLEL_THREADS_PER_CPU ................................................................................................. PGA_AGGREGATE_TARGET ......................................................................................................... PLSQL_CODE_TYPE.......................................................................................................................... PLSQL_COMPILER_FLAGS ............................................................................................................ PLSQL_DEBUG ................................................................................................................................... PLSQL_NATIVE_LIBRARY_DIR .................................................................................................... PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT........................................................................... PLSQL_OPTIMIZE_LEVEL .............................................................................................................. PLSQL_V2_COMPATIBILITY.......................................................................................................... PLSQL_WARNINGS .......................................................................................................................... PRE_PAGE_SGA ................................................................................................................................. PROCESSES ......................................................................................................................................... QUERY_REWRITE_ENABLED ........................................................................................................ QUERY_REWRITE_INTEGRITY..................................................................................................... RDBMS_SERVER_DN ....................................................................................................................... READ_ONLY_OPEN_DELAYED..................................................................................................... RECOVERY_PARALLELISM ........................................................................................................... REMOTE_ARCHIVE_ENABLE ....................................................................................................... REMOTE_DEPENDENCIES_MODE.............................................................................................. REMOTE_LISTENER ......................................................................................................................... REMOTE_LOGIN_PASSWORDFILE............................................................................................. REMOTE_OS_AUTHENT................................................................................................................. REMOTE_OS_ROLES........................................................................................................................ REPLICATION_DEPENDENCY_TRACKING ............................................................................. RESOURCE_LIMIT ............................................................................................................................ RESOURCE_MANAGER_PLAN ..................................................................................................... RESUMABLE_TIMEOUT.................................................................................................................. ROLLBACK_SEGMENTS ................................................................................................................. SERIAL _REUSE.................................................................................................................................. SERVICE_NAMES .............................................................................................................................. SESSION_CACHED_CURSORS ..................................................................................................... SESSION_MAX_OPEN_FILES ........................................................................................................ SESSIONS ............................................................................................................................................ SGA_MAX_SIZE ................................................................................................................................. SGA_TARGET ..................................................................................................................................... SHADOW_CORE_DUMP ................................................................................................................. SHARED_MEMORY_ADDRESS .................................................................................................... SHARED_POOL_RESERVED_SIZE ............................................................................................... SHARED_POOL_SIZE....................................................................................................................... SHARED_SERVER_SESSIONS ....................................................................................................... SHARED_SERVERS ........................................................................................................................... SKIP_UNUSABLE_INDEXES .......................................................................................................... SMTP_OUT_SERVER ........................................................................................................................ SORT_AREA_RETAINED_SIZE...................................................................................................... SORT_AREA_SIZE .............................................................................................................................

1-104 1-105 1-106 1-106 1-107 1-107 1-108 1-109 1-109 1-109 1-110 1-111 1-112 1-112 1-113 1-114 1-114 1-115 1-115 1-116 1-116 1-117 1-117 1-118 1-118 1-119 1-119 1-120 1-120 1-121 1-122 1-123 1-123 1-124 1-124 1-125 1-125 1-126 1-127 1-127 1-127 1-128 1-129 1-129 1-130 1-130 1-131

vii

SPFILE ................................................................................................................................................... SQL_TRACE......................................................................................................................................... SQL92_SECURITY .............................................................................................................................. SQLTUNE_CATEGORY..................................................................................................................... STANDBY_ARCHIVE_DEST........................................................................................................... STANDBY_FILE_MANAGEMENT................................................................................................. STAR_TRANSFORMATION_ENABLED...................................................................................... STATISTICS_LEVEL .......................................................................................................................... STREAMS_POOL_SIZE .................................................................................................................... TAPE_ASYNCH_IO ............................................................................................................................ THREAD ............................................................................................................................................... TIMED_OS_STATISTICS ................................................................................................................. TIMED_STATISTICS ......................................................................................................................... TRACE_ENABLED ............................................................................................................................. TRACEFILE_IDENTIFIER ................................................................................................................ TRANSACTIONS ............................................................................................................................... TRANSACTIONS_PER_ROLLBACK_SEGMENT...................................................................... UNDO_MANAGEMENT .................................................................................................................. UNDO_RETENTION ......................................................................................................................... UNDO_TABLESPACE........................................................................................................................ USE_INDIRECT_DATA_BUFFERS................................................................................................. USER_DUMP_DEST .......................................................................................................................... UTL_FILE_DIR .................................................................................................................................... WORKAREA_SIZE_POLICY............................................................................................................

1-132 1-132 1-133 1-133 1-134 1-134 1-135 1-135 1-137 1-137 1-137 1-138 1-139 1-139 1-140 1-141 1-141 1-142 1-142 1-143 1-143 1-144 1-144 1-145

Part II

Static Data Dictionary Views

2 Static Data Dictionary Views: ALL_ALL_TABLES to DATABASE_ PROPERTIESAbout Static Data Dictionary Views..................................................................................................... 2-1 Oracle Replication Views .................................................................................................................. 2-2 Oracle Workspace Manager Views.................................................................................................. 2-3 Recovery Catalog Views ................................................................................................................... 2-4 Static Data Dictionary View Descriptions........................................................................................... 2-4 ALL_ALL_TABLES .................................................................................................................................. 2-4 ALL_APPLY ............................................................................................................................................... 2-7 ALL_APPLY_CONFLICT_COLUMNS ................................................................................................ 2-8 ALL_APPLY_DML_HANDLERS .......................................................................................................... 2-8 ALL_APPLY_ENQUEUE ......................................................................................................................... 2-9 ALL_APPLY_ERROR............................................................................................................................... 2-9 ALL_APPLY_EXECUTE ....................................................................................................................... 2-10 ALL_APPLY_KEY_COLUMNS .......................................................................................................... 2-10 ALL_APPLY_PARAMETERS .............................................................................................................. 2-10 ALL_APPLY_PROGRESS .................................................................................................................... 2-11 ALL_APPLY_TABLE_COLUMNS...................................................................................................... 2-11 ALL_ARGUMENTS.............................................................................................................................. 2-12 ALL_ASSOCIATIONS ......................................................................................................................... 2-13viii

ALL_AUDIT_POLICIES ...................................................................................................................... ALL_AUDIT_POLICY_COLUMNS .................................................................................................. ALL_AW_PS ........................................................................................................................................... ALL_AWS................................................................................................................................................ ALL_BASE_TABLE_MVIEWS............................................................................................................ ALL_CAPTURE ..................................................................................................................................... ALL_CAPTURE_EXTRA_ATTRIBUTES.......................................................................................... ALL_CAPTURE_PARAMETERS ....................................................................................................... ALL_CAPTURE_PREPARED_DATABASE ..................................................................................... ALL_CAPTURE_PREPARED_SCHEMAS ....................................................................................... ALL_CAPTURE_PREPARED_TABLES ............................................................................................ ALL_CATALOG..................................................................................................................................... ALL_CLUSTER_HASH_EXPRESSIONS ......................................................................................... ALL_CLUSTERS.................................................................................................................................... ALL_COL_COMMENTS ..................................................................................................................... ALL_COL_PRIVS.................................................................................................................................. ALL_COL_PRIVS_MADE ................................................................................................................... ALL_COL_PRIVS_RECD .................................................................................................................... ALL_COLL_TYPES ............................................................................................................................... ALL_CONS_COLUMNS ..................................................................................................................... ALL_CONS_OBJ_COLUMNS............................................................................................................ ALL_CONSTRAINTS .......................................................................................................................... ALL_CONTEXT ..................................................................................................................................... ALL_DB_LINKS .................................................................................................................................... ALL_DEF_AUDIT_OPTS .................................................................................................................... ALL_DEPENDENCIES ........................................................................................................................ ALL_DIM_ATTRIBUTES .................................................................................................................... ALL_DIM_CHILD_OF ......................................................................................................................... ALL_DIM_HIERARCHIES ................................................................................................................. ALL_DIM_JOIN_KEY .......................................................................................................................... ALL_DIM_LEVEL_KEY ....................................................................................................................... ALL_DIM_LEVELS............................................................................................................................... ALL_DIMENSIONS ............................................................................................................................. ALL_DIRECTORIES ............................................................................................................................ ALL_ERRORS ........................................................................................................................................ ALL_EVALUATION_CONTEXT_TABLES ...................................................................................... ALL_EVALUATION_CONTEXT_VARS........................................................................................... ALL_EVALUATION_CONTEXTS ..................................................................................................... ALL_EXTERNAL_LOCATIONS ........................................................................................................ ALL_EXTERNAL_TABLES ................................................................................................................. ALL_IND_COLUMNS ......................................................................................................................... ALL_IND_EXPRESSIONS .................................................................................................................. ALL_IND_PARTITIONS ..................................................................................................................... ALL_IND_STATISTICS ....................................................................................................................... ALL_IND_SUBPARTITIONS ............................................................................................................. ALL_INDEXES....................................................................................................................................... ALL_INDEXTYPE_ARRAYTYPES ....................................................................................................

2-14 2-14 2-15 2-15 2-16 2-16 2-18 2-18 2-19 2-19 2-19 2-20 2-20 2-20 2-21 2-22 2-22 2-23 2-23 2-24 2-24 2-25 2-26 2-26 2-27 2-28 2-28 2-29 2-29 2-29 2-30 2-30 2-31 2-31 2-31 2-32 2-33 2-33 2-34 2-34 2-35 2-36 2-36 2-37 2-39 2-40 2-43

ix

ALL_INDEXTYPE_COMMENTS ...................................................................................................... ALL_INDEXTYPE_OPERATORS ...................................................................................................... ALL_INDEXTYPES ............................................................................................................................... ALL_INTERNAL_TRIGGERS............................................................................................................ ALL_JAVA_ARGUMENTS.................................................................................................................. ALL_JAVA_CLASSES........................................................................................................................... ALL_JAVA_DERIVATIONS ................................................................................................................ ALL_JAVA_FIELDS............................................................................................................................... ALL_JAVA_IMPLEMENTS ................................................................................................................. ALL_JAVA_INNERS ............................................................................................................................. ALL_JAVA_LAYOUTS.......................................................................................................................... ALL_JAVA_METHODS ....................................................................................................................... ALL_JAVA_NCOMPS........................................................................................................................... ALL_JAVA_RESOLVERS ..................................................................................................................... ALL_JAVA_THROWS .......................................................................................................................... ALL_JOBS............................................................................................................................................... ALL_JOIN_IND_COLUMNS ............................................................................................................. ALL_LIBRARIES................................................................................................................................... ALL_LOB_PARTITIONS ..................................................................................................................... ALL_LOB_SUBPARTITIONS............................................................................................................. ALL_LOB_TEMPLATES ...................................................................................................................... ALL_LOBS .............................................................................................................................................. ALL_LOG_GROUP_COLUMNS ....................................................................................................... ALL_LOG_GROUPS ............................................................................................................................ ALL_METHOD_PARAMS .................................................................................................................. ALL_METHOD_RESULTS.................................................................................................................. ALL_MVIEW_AGGREGATES ........................................................................................................... ALL_MVIEW_ANALYSIS ................................................................................................................... ALL_MVIEW_COMMENTS............................................................................................................... ALL_MVIEW_DETAIL_RELATIONS............................................................................................... ALL_MVIEW_JOINS............................................................................................................................ ALL_MVIEW_KEYS ............................................................................................................................. ALL_MVIEW_LOGS ............................................................................................................................ ALL_MVIEW_REFRESH_TIMES ...................................................................................................... ALL_MVIEWS ....................................................................................................................................... ALL_NESTED_TABLE_COLS ............................................................................................................ ALL_NESTED_TABLES....................................................................................................................... ALL_OBJ_COLATTRS ......................................................................................................................... ALL_OBJECT_TABLES ........................................................................................................................ ALL_OBJECTS....................................................................................................................................... ALL_OPANCILLARY ........................................................................................................................... ALL_OPARGUMENTS ........................................................................................................................ ALL_OPBINDINGS.............................................................................................................................. ALL_OPERATOR_COMMENTS ....................................................................................................... ALL_OPERATORS................................................................................................................................ ALL_OUTLINE_HINTS....................................................................................................................... ALL_OUTLINES....................................................................................................................................

2-43 2-44 2-44 2-45 2-45 2-46 2-47 2-47 2-48 2-49 2-49 2-50 2-51 2-52 2-52 2-53 2-54 2-54 2-54 2-55 2-56 2-57 2-58 2-58 2-59 2-59 2-60 2-61 2-62 2-62 2-63 2-63 2-64 2-65 2-65 2-68 2-70 2-70 2-71 2-73 2-74 2-74 2-75 2-75 2-76 2-76 2-77

x

ALL_PART_COL_STATISTICS .......................................................................................................... ALL_PART_HISTOGRAMS ............................................................................................................... ALL_PART_INDEXES .......................................................................................................................... ALL_PART_KEY_COLUMNS............................................................................................................. ALL_PART_LOBS ................................................................................................................................. ALL_PART_TABLES............................................................................................................................. ALL_PARTIAL_DROP_TABS............................................................................................................. ALL_PENDING_CONV_TABLES ..................................................................................................... ALL_PLSQL_OBJECT_SETTINGS ................................................................................................... ALL_POLICIES...................................................................................................................................... ALL_POLICY_CONTEXTS ................................................................................................................. ALL_POLICY_GROUPS ...................................................................................................................... ALL_PROCEDURES............................................................................................................................. ALL_PROPAGATION .......................................................................................................................... ALL_PUBLISHED_COLUMNS.......................................................................................................... ALL_QUEUE_TABLES ......................................................................................................................... ALL_QUEUES ........................................................................................................................................ ALL_REFRESH ...................................................................................................................................... ALL_REFRESH_CHILDREN .............................................................................................................. ALL_REFRESH_DEPENDENCIES.................................................................................................... ALL_REFS............................................................................................................................................... ALL_REGISTERED_MVIEWS ........................................................................................................... ALL_REGISTRY_BANNERS .............................................................................................................. ALL_REWRITE_EQUIVALENCES.................................................................................................... ALL_RULE_SET_RULES ..................................................................................................................... ALL_RULE_SETS .................................................................................................................................. ALL_RULES............................................................................................................................................ ALL_SCHEDULER_JOB_ARGS ........................................................................................................ ALL_SCHEDULER_JOB_CLASSES.................................................................................................. ALL_SCHEDULER_JOB_LOG ........................................................................................................... ALL_SCHEDULER_JOB_RUN_DETAILS ....................................................................................... ALL_SCHEDULER_JOBS.................................................................................................................... ALL_SCHEDULER_PROGRAM_ARGS.......................................................................................... ALL_SCHEDULER_PROGRAMS ................................................................................................... ALL_SCHEDULER_RUNNING_JOBS........................................................................................... ALL_SCHEDULER_SCHEDULES................................................................................................... ALL_SCHEDULER_WINDOW_DETAILS .................................................................................... ALL_SCHEDULER_WINDOW_GROUPS .................................................................................... ALL_SCHEDULER_WINDOW_LOG ............................................................................................. ALL_SCHEDULER_WINDOWS...................................................................................................... ALL_SCHEDULER_WINGROUP_MEMBERS............................................................................. ALL_SEC_RELEVANT_COLS .......................................................................................................... ALL_SEQUENCES .............................................................................................................................. ALL_SERVICES ................................................................................................................................... ALL_SOURCE...................................................................................................................................... ALL_SOURCE_TABLES .................................................................................................................... ALL_SQLJ_TYPE_ATTRS .................................................................................................................

2-77 2-78 2-79 2-80 2-81 2-82 2-83 2-83 2-84 2-85 2-86 2-86 2-87 2-87 2-88 2-88 2-89 2-90 2-91 2-91 2-92 2-92 2-93 2-93 2-93 2-94 2-94 2-95 2-96 2-96 2-97 2-97 2-99 2-100 2-101 2-101 2-102 2-102 2-103 2-103 2-104 2-104 2-105 2-105 2-106 2-106 2-107

xi

ALL_SQLJ_TYPE_METHODS ......................................................................................................... ALL_SQLJ_TYPES .............................................................................................................................. ALL_STORED_SETTINGS ............................................................................................................... ALL_STREAMS_GLOBAL_RULES ................................................................................................ ALL_STREAMS_MESSAGE_CONSUMERS................................................................................ ALL_STREAMS_MESSAGE_RULES ............................................................................................. ALL_STREAMS_NEWLY_SUPPORTED ....................................................................................... ALL_STREAMS_RULES.................................................................................................................... ALL_STREAMS_SCHEMA_RULES ............................................................................................... ALL_STREAMS_TABLE_RULES..................................................................................................... ALL_STREAMS_TRANSFORM_FUNCTION.............................................................................. ALL_STREAMS_UNSUPPORTED.................................................................................................. ALL_SUBPART_COL_STATISTICS................................................................................................ ALL_SUBPART_HISTOGRAMS ..................................................................................................... ALL_SUBPART_KEY_COLUMNS .................................................................................................. ALL_SUBPARTITION_TEMPLATES ............................................................................................. ALL_SUBSCRIBED_COLUMNS ..................................................................................................... ALL_SUBSCRIBED_TABLES ........................................................................................................... ALL_SUBSCRIPTIONS ..................................................................................................................... ALL_SUMDELTA ................................................................................................................................ ALL_SYNONYMS............................................................................................................................... ALL_TAB_COL_STATISTICS .......................................................................................................... ALL_TAB_COLS.................................................................................................................................. ALL_TAB_COLUMNS ....................................................................................................................... ALL_TAB_COMMENTS.................................................................................................................... ALL_TAB_HISTOGRAMS................................................................................................................ ALL_TAB_MODIFICATIONS.......................................................................................................... ALL_TAB_PARTITIONS ................................................................................................................... ALL_TAB_PRIVS ................................................................................................................................ ALL_TAB_PRIVS_MADE ................................................................................................................. ALL_TAB_PRIVS_RECD................................................................................................................... ALL_TAB_STATISTICS ..................................................................................................................... ALL_TAB_SUBPARTITIONS ........................................................................................................... ALL_TABLES ....................................................................................................................................... ALL_TRIGGER_COLS....................................................................................................................... ALL_TRIGGERS ................................................................................................................................. ALL_TYPE_ATTRS ............................................................................................................................. ALL_TYPE_METHODS ..................................................................................................................... ALL_TYPE_VERSIONS ..................................................................................................................... ALL_TYPES .......................................................................................................................................... ALL_UNUSED_COL_TABS .............................................................................................................. ALL_UPDATABLE_COLUMNS....................................................................................................... ALL_USERS.......................................................................................................................................... ALL_USTATS ....................................................................................................................................... ALL_VARRAYS.................................................................................................................................... ALL_VIEWS ......................................................................................................................................... ALL_WARNING_SETTINGS...........................................................................................................

2-107 2-108 2-109 2-110 2-110 2-111 2-111 2-112 2-113 2-114 2-115 2-116 2-116 2-117 2-118 2-118 2-119 2-119 2-120 2-120 2-121 2-121 2-122 2-124 2-125 2-126 2-126 2-127 2-128 2-129 2-129 2-130 2-131 2-132 2-134 2-135 2-135 2-136 2-137 2-137 2-138 2-138 2-139 2-139 2-140 2-140 2-141

xii

ALL_XML_SCHEMAS ....................................................................................................................... ALL_XML_TAB_COLS....................................................................................................................... ALL_XML_TABLES ............................................................................................................................ ALL_XML_VIEW_COLS.................................................................................................................... ALL_XML_VIEWS .............................................................................................................................. AUDIT_ACTIONS.............................................................................................................................. CATALOG............................................................................................................................................. CAT......................................................................................................................................................... CHAINED_ROWS .............................................................................................................................. CHANGE_SETS .................................................................................................................................. CHANGE_SOURCES ......................................................................................................................... CHANGE_TABLES ............................................................................................................................. CLU ........................................................................................................................................................ COL ........................................................................................................................................................ COLS...................................................................................................................................................... DATABASE_PROPERTIES ...............................................................................................................

2-142 2-142 2-143 2-143 2-144 2-144 2-145 2-145 2-145 2-145 2-146 2-147 2-147 2-147 2-147 2-147

3

Static Data Dictionary Views: DBA_2PC_NEIGHBORS to USER_XML_VIEWSDBA_2PC_NEIGHBORS ........................................................................................................................ 3-1 DBA_2PC_PENDING.............................................................................................................................. 3-1 DBA_ADVISOR_ACTIONS.................................................................................................................. 3-2 DBA_ADVISOR_COMMANDS........................................................................................................... 3-3 DBA_ADVISOR_DEFINITIONS ......................................................................................................... 3-3 DBA_ADVISOR_FINDINGS ................................................................................................................ 3-4 DBA_ADVISOR_JOURNAL ................................................................................................................. 3-4 DBA_ADVISOR_LOG ............................................................................................................................ 3-5 DBA_ADVISOR_OBJECT_TYPES....................................................................................................... 3-6 DBA_ADVISOR_OBJECTS ................................................................................................................... 3-6 DBA_ADVISOR_PARAMETERS......................................................................................................... 3-7 DBA_ADVISOR_RATIONALE ............................................................................................................ 3-8 DBA_ADVISOR_RECOMMENDATIONS ........................................................................................ 3-9 DBA_ADVISOR_SQLA_REC_SUM ................................................................................................. 3-10 DBA_ADVISOR_SQLA_WK_MAP .................................................................................................. 3-10 DBA_ADVISOR_SQLA_WK_STMTS ............................................................................................. 3-11 DBA_ADVISOR_SQLW_JOURNAL ................................................................................................ 3-12 DBA_ADVISOR_SQLW_PARAMETERS ........................................................................................ 3-12 DBA_ADVISOR_SQLW_STMTS ...................................................................................................... 3-13 DBA_ADVISOR_SQLW_SUM........................................................................................................... 3-14 DBA_ADVISOR_SQLW_TABLES..................................................................................................... 3-15 DBA_ADVISOR_SQLW_TEMPLATES............................................................................................ 3-15 DBA_ADVISOR_TASKS..................................................................................................................... 3-16 DBA_ADVISOR_TEMPLATES.......................................................................................................... 3-17 DBA_ADVISOR_USAGE.................................................................................................................... 3-17 DBA_ALERT_HISTORY...................................................................................................................... 3-18 DBA_ALL_TABLES .............................................................................................................................. 3-18 DBA_APPLICATION_ROLES............................................................................................................ 3-19 DBA_APPLY ........................................................................................................................................... 3-19

xiii

DBA_APPLY_CONFLICT_COLUMNS ............................................................................................ DBA_APPLY_DML_HANDLERS ...................................................................................................... DBA_APPLY_ENQUEUE..................................................................................................................... DBA_APPLY_ERROR........................................................................................................................... DBA_APPLY_EXECUTE ...................................................................................................................... DBA_APPLY_INSTANTIATED_GLOBAL ...................................................................................... DBA_APPLY_INSTANTIATED_OBJECTS...................................................................................... DBA_APPLY_INSTANTIATED_SCHEMAS................................................................................... DBA_APPLY_KEY_COLUMNS ......................................................................................................... DBA_APPLY_PARAMETERS............................................................................................................. DBA_APPLY_PROGRESS................................................................................................................... DBA_APPLY_TABLE_COLUMNS..................................................................................................... DBA_AQ_AGENT_PRIVS .................................................................................................................. DBA_AQ_AGENTS .............................................................................................................................. DBA_ASSOCIATIONS ........................................................................................................................ DBA_ATTRIBUTE_TRANSFORMATIONS ................................................................................... DBA_AUDIT_EXISTS.......................................................................................................................... DBA_AUDIT_OBJECT ........................................................................................................................ DBA_AUDIT_POLICIES ..................................................................................................................... DBA_AUDIT_POLICY_COLUMNS ................................................................................................. DBA_AUDIT_SESSION ...................................................................................................................... DBA_AUDIT_STATEMENT ............................................................................................................... DBA_AUDIT_TRAIL ........................................................................................................................... DBA_AW_PS .......................................................................................................................................... DBA_AWS............................................................................................................................................... DBA_BASE_TABLE_MVIEWS........................................................................................................... DBA_BLOCKERS.................................................................................................................................. DBA_CAPTURE .................................................................................................................................... DBA_CAPTURE_EXTRA_ATTRIBUTES......................................................................................... DBA_CAPTURE_PARAMETERS ...................................................................................................... DBA_CAPTURE_PREPARED_DATABASE .................................................................................... DBA_CAPTURE_PREPARED_SCHEMAS...................................................................................... DBA_CAPTURE_PREPARED_TABLES ........................................................................................... DBA_CATALOG.................................................................................................................................... DBA_CLU_COLUMNS........................................................................................................................ DBA_CLUSTER_HASH_EXPRESSIONS ........................................................................................ DBA_CLUSTERS .................................................................................................................................. DBA_COL_COMMENTS .................................................................................................................... DBA_COL_PRIVS................................................................................................................................. DBA_COLL_TYPES .............................................................................................................................. DBA_COMMON_AUDIT_TRAIL .................................................................................................... DBA_CONS_OBJ_COLUMNS........................................................................................................... DBA_CONSTRAINTS ......................................................................................................................... DBA_CONTEXT.................................................................................................................................... DBA_DATA_FILES ............................................................................................................................... DBA_DATAPUMP_JOBS .................................................................................................................... DBA_DATAPUMP_SESSIONS..........................................................................................................

3-19 3-19 3-19 3-19 3-19 3-20 3-20 3-20 3-20 3-21 3-21 3-21 3-21 3-21 3-22 3-22 3-22 3-23 3-25 3-25 3-25 3-26 3-27 3-29 3-29 3-30 3-30 3-30 3-30 3-30 3-30 3-30 3-31 3-31 3-31 3-31 3-31 3-31 3-31 3-32 3-32 3-34 3-34 3-34 3-34 3-34 3-35

xiv

DBA_DB_LINKS................................................................................................................................... DBA_DDL_LOCKS .............................................................................................................................. DBA_DEPENDENCIES ....................................................................................................................... DBA_DIM_ATTRIBUTES ................................................................................................................... DBA_DIM_CHILD_OF........................................................................................................................ DBA_DIM_HIERARCHIES ................................................................................................................ DBA_DIM_JOIN_KEY ......................................................................................................................... DBA_DIM_LEVEL_KEY...................................................................................................................... DBA_DIM_LEVELS.............................................................................................................................. DBA_DIMENSIONS ............................................................................................................................ DBA_DIRECTORIES ........................................................................................................................... DBA_DML_LOCKS.............................................................................................................................. DBA_DMT_FREE_SPACE................................................................................................................... DBA_DMT_USED_EXTENTS............................................................................................................ DBA_ENABLED_AGGREGATIONS ............................................................................................... DBA_ENABLED_TRACES.................................................................................................................. DBA_ERRORS ....................................................................................................................................... DBA_EVALUATION_CONTEXT_TABLES ..................................................................................... DBA_EVALUATION_CONTEXT_VARS ......................................................................................... DBA_EVALUATION_CONTEXTS .................................................................................................... DBA_EXP_FILES ................................................................................................................................... DBA_EXP_OBJECTS ............................................................................................................................ DBA_EXP_VERSION ........................................................................................................................... DBA_EXTENTS ..................................................................................................................................... DBA_EXTERNAL_LOCATIONS ....................................................................................................... DBA_EXTERNAL_TABLES ................................................................................................................ DBA_FEATURE_USAGE_STATISTICS ........................................................................................... DBA_FGA_AUDIT_TRAIL................................................................................................................. DBA_FREE_SPACE............................................................................................................................... DBA_FREE_SPACE_COALESCED ................................................................................................... DBA_HIGH_WATER_MARK_STATISTICS ................................................................................... DBA_HIST_ACTIVE_SESS_HISTORY............................................................................................ DBA_HIST_BASELINE ....................................................................................................................... DBA_HIST_BG_EVENT_SUMMARY.............................................................................................. DBA_HIST_BUFFER_POOL_STAT................................................................................................... DBA_HIST_CR_BLOCK_SERVER.................................................................................................... DBA_HIST_CURRENT_BLOCK_SERVER ..................................................................................... DBA_HIST_DATABASE_INSTANCE .............................................................................................. DBA_HIST_DATAFILE........................................................................................................................ DBA_HIST_DB_CACHE_ADVICE................................................................................................... DBA_HIST_DLM_MISC ..................................................................................................................... DBA_HIST_ENQUEUE_STAT ........................................................................................................... DBA_HIST_EVENT_NAME ............................................................................................................... DBA_HIST_FILEMETRIC_HISTORY .............................................................................................. DBA_HIST_FILESTATXS.................................................................................................................... DBA_HIST_INSTANCE_RECOVERY .............................................................................................. DBA_HIST_JAVA_POOL_ADVICE ..................................................................................................

3-35 3-35 3-36 3-36 3-36 3-36 3-36 3-37 3-37 3-37 3-37 3-37 3-38 3-38 3-38 3-38 3-39 3-39 3-39 3-39 3-39 3-40 3-40 3-40 3-41 3-41 3-41 3-43 3-44 3-45 3-45 3-46 3-47 3-47 3-47 3-48 3-49 3-50 3-50 3-50 3-51 3-51 3-52 3-52 3-52 3-53 3-54

xv

DBA_HIST_LATCH.............................................................................................................................. DBA_HIST_LATCH_CHILDREN ..................................................................................................... DBA_HIST_LATCH_MISSES_SUMMARY .................................................................................... DBA_HIST_LATCH_NAME............................................................................................................... DBA_HIST_LATCH_PARENT ........................................................................................................... DBA_HIST_LIBRARYCACHE ........................................................................................................... DBA_HIST_LOG................................................................................................................................... DBA_HIST_METRIC_NAME ............................................................................................................ DBA_HIST_MTTR_TARGET_ADVICE .......................................................................................... DBA_HIST_OPTIMIZER_ENV ......................................................................................................... DBA_HIST_OSSTAT............................................................................................................................ DBA_HIST_OSSTAT_NAME ............................................................................................................. DBA_HIST_PARAMETER .................................................................................................................. DBA_HIST_PARAMETER_NAME ................................................................................................... DBA_HIST_PGA_TARGET_ADVICE.............................................................................................. DBA_HIST_PGASTAT......................................................................................................................... DBA_HIST_RESOURCE_LIMIT ....................................................................................................... DBA_HIST_ROLLSTAT....................................................................................................................... DBA_HIST_ROWCACHE_SUMMARY........................................................................................... DBA_HIST_SEG_STAT ....................................................................................................................... DBA_HIST_SEG_STAT_OBJ.............................................................................................................. DBA_HIST_SERVICE_NAME ........................................................................................................... DBA_HIST_SERVICE_STAT .............................................................................................................. DBA_HIST_SERVICE_WAIT_CLASS .............................................................................................. DBA_HIST_SESSMETRIC_HISTORY............................................................................................. DBA_HIST_SGA................................................................................................................................... DBA_HIST_SGASTAT......................................................................................................................... DBA_HIST_SHARED_POOL_ADVICE ..............