Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1）部品番号:...

Oracle9i

データベース・リファレンス

リリース 1（9.0.1）

2001 年 10 月

部品番号 : J04114-01

Oracle9i データベース・リファレンス , リリース 1（9.0.1）

部品番号 : J04114-01

原本名 : Oracle9i Database Reference, Release1 (9.0.1)

原本部品番号 : A90190-02

原本著者 : Tony Morales、Diana Lorentz

原本協力者 : Nipun Agarwal、Angela Amor、Rick Anderson、Lance Ashdown、Mark Bauer、Ruth Baylis、Neerja Bhatt、George Candea、Wilson Chan、Sumanta Chatterjee、Eugene Chong、Michele Cyran、Mary Ann Davidson、Connie Dialeris、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、Nina Lewis、Juan Loaiza、Neil MacNaughton、Shankar Raman、Rita Moran、Ari Mozes、Subramanian Muralidhar、Ravi Murthy、Karuna Muthiah、Arvind Nithrakashyap、Ronald Obermarck、Cetin Ozbutun、Christopher Racicot、Mark Ramacher、Suvendu Ray、Ann Rhee、Harlan Sexton、Helen Slattery、Ekrem Soylemez、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

Copyright © 1996, 2001, Oracle Corporation. All rights reserved.

Printed in Japan.

制限付権利の説明

プログラム（ソフトウェアおよびドキュメントを含む）の使用、複製または開示は、オラクル社との契約に記された制約条件に従うものとします。著作権、特許権およびその他の知的財産権に関する法律により保護されています。

当プログラムのリバース・エンジニアリング等は禁止されております。

このドキュメントの情報は、予告なしに変更されることがあります。オラクル社は本ドキュメントの無謬性を保証しません。

* オラクル社とは、Oracle Corporation（米国オラクル）または日本オラクル株式会社（日本オラクル）を指します。

危険な用途への使用について

オラクル社製品は、原子力、航空産業、大量輸送、医療あるいはその他の危険が伴うアプリケーションを用途として開発されておりません。オラクル社製品を上述のようなアプリケーションに使用することについての安全確保は、顧客各位の責任と費用により行ってください。万一かかる用途での使用によりクレームや損害が発生いたしましても、日本オラクル株式会社と開発元である Oracle Corporation（米国オラクル）およびその関連会社は一切責任を負いかねます。当プログラムを米国国防総省の米国政府機関に提供する際には、『Restricted Rights』と共に提供してください。この場合次の Notice が適用されます。

Restricted Rights Notice

Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

このドキュメントに記載されているその他の会社名および製品名は、あくまでその製品および会社を識別する目的にのみ使用されており、それぞれの所有者の商標または登録商標です。

目次目次目次目次

はじめにはじめにはじめにはじめに ..................................................................................................................................................................... xxxiii

対象読者 ............................................................................................................................................................... xxxiv構成 ....................................................................................................................................................................... xxxiv関連ドキュメント ................................................................................................................................................ xxxv表記規則 ................................................................................................................................................................ xxxv

1 初期化パラメータ初期化パラメータ初期化パラメータ初期化パラメータ

初期化パラメータ・ファイル初期化パラメータ・ファイル初期化パラメータ・ファイル初期化パラメータ・ファイル ............................................................................................................................... 1-2パラメータ・ファイル内の値の指定パラメータ・ファイル内の値の指定パラメータ・ファイル内の値の指定パラメータ・ファイル内の値の指定 ................................................................................................................... 1-3

パラメータ・ファイルを管理するルール ................................................................................................... 1-3

パラメータ値での特殊文字の使用 ............................................................................................................... 1-5

パラメータ値の変更 ....................................................................................................................................... 1-6

パラメータの使用方法 ................................................................................................................................. 1-10

パラメータのタイプ ..................................................................................................................................... 1-10

パラメータ・ファイルで指定できないパラメータ ................................................................................. 1-12

パラメータの不正確な設定 ......................................................................................................................... 1-12パラメータの説明の読み方パラメータの説明の読み方パラメータの説明の読み方パラメータの説明の読み方 ................................................................................................................................. 1-13パラメータの説明パラメータの説明パラメータの説明パラメータの説明 ................................................................................................................................................. 1-14ACTIVE_INSTANCE_COUNT ........................................................................................................................ 1-14AQ_TM_PROCESSES ........................................................................................................................................ 1-15ARCHIVE_LAG_TARGET ............................................................................................................................... 1-15AUDIT_FILE_DEST ........................................................................................................................................... 1-16AUDIT_TRAIL .................................................................................................................................................... 1-16BACKGROUND_CORE_DUMP ..................................................................................................................... 1-17BACKGROUND_DUMP_DEST ...................................................................................................................... 1-18

i

BACKUP_TAPE_IO_SLAVES .......................................................................................................................... 1-19BITMAP_MERGE_AREA_SIZE ....................................................................................................................... 1-20BLANK_TRIMMING ......................................................................................................................................... 1-20BUFFER_POOL_KEEP ....................................................................................................................................... 1-21BUFFER_POOL_RECYCLE ............................................................................................................................... 1-22CIRCUITS ............................................................................................................................................................. 1-23CLUSTER_DATABASE ..................................................................................................................................... 1-23CLUSTER_DATABASE_INSTANCES ........................................................................................................... 1-24CLUSTER_INTERCONNECTS ........................................................................................................................ 1-24COMMIT_POINT_STRENGTH ...................................................................................................................... 1-25COMPATIBLE ..................................................................................................................................................... 1-26CONTROL_FILE_RECORD_KEEP_TIME .................................................................................................... 1-27CONTROL_FILES ............................................................................................................................................... 1-28CORE_DUMP_DEST ......................................................................................................................................... 1-28CPU_COUNT ....................................................................................................................................................... 1-29CREATE_BITMAP_AREA_SIZE ..................................................................................................................... 1-29CURSOR_SHARING ......................................................................................................................................... 1-30CURSOR_SPACE_FOR_TIME ......................................................................................................................... 1-31DB_nK_CACHE_SIZE ........................................................................................................................................ 1-32DB_BLOCK_BUFFERS ...................................................................................................................................... 1-33DB_BLOCK_CHECKING ................................................................................................................................. 1-34DB_BLOCK_CHECKSUM ................................................................................................................................ 1-35DB_BLOCK_SIZE ............................................................................................................................................... 1-35DB_CACHE_ADVICE ........................................................................................................................................ 1-36DB_CACHE_SIZE ............................................................................................................................................... 1-37DB_CREATE_FILE_DEST ................................................................................................................................. 1-38DB_CREATE_ONLINE_LOG_DEST_n .......................................................................................................... 1-38DB_DOMAIN ...................................................................................................................................................... 1-39DB_FILE_MULTIBLOCK_READ_COUNT ................................................................................................... 1-40DB_FILE_NAME_CONVERT ........................................................................................................................... 1-41DB_FILES .............................................................................................................................................................. 1-42DB_KEEP_CACHE_SIZE ................................................................................................................................... 1-43DB_NAME ............................................................................................................................................................ 1-43DB_RECYCLE_CACHE_SIZE .......................................................................................................................... 1-44DB_WRITER_PROCESSES ............................................................................................................................... 1-44DBLINK_ENCRYPT_LOGIN ........................................................................................................................... 1-45DBWR_IO_SLAVES ........................................................................................................................................... 1-45DISK_ASYNCH_IO ............................................................................................................................................ 1-46

ii

DISPATCHERS ................................................................................................................................................... 1-47DISTRIBUTED_TRANSACTIONS ................................................................................................................ 1-50DML_LOCKS ....................................................................................................................................................... 1-51DRS_START ........................................................................................................................................................ 1-52ENQUEUE_RESOURCES .................................................................................................................................. 1-52EVENT ................................................................................................................................................................... 1-53FAL_CLIENT ........................................................................................................................................................ 1-53FAL_SERVER ....................................................................................................................................................... 1-54FAST_START_IO_TARGET ............................................................................................................................. 1-54FAST_START_MTTR_TARGET ..................................................................................................................... 1-56FAST_START_PARALLEL_ROLLBACK ...................................................................................................... 1-56FIXED_DATE ....................................................................................................................................................... 1-57GC_FILES_TO_LOCKS ..................................................................................................................................... 1-57GLOBAL_CONTEXT_POOL_SIZE ................................................................................................................. 1-59GLOBAL_NAMES .............................................................................................................................................. 1-59HASH_AREA_SIZE ............................................................................................................................................ 1-60HASH_JOIN_ENABLED ................................................................................................................................... 1-60HI_SHARED_MEMORY_ADDRESS ............................................................................................................. 1-61HS_AUTOREGISTER ........................................................................................................................................ 1-61IFILE ....................................................................................................................................................................... 1-62INSTANCE_GROUPS ....................................................................................................................................... 1-63INSTANCE_NAME ............................................................................................................................................ 1-64INSTANCE_NUMBER ....................................................................................................................................... 1-64JAVA_MAX_SESSIONSPACE_SIZE .............................................................................................................. 1-65JAVA_POOL_SIZE ............................................................................................................................................. 1-66JAVA_SOFT_SESSIONSPACE_LIMIT .......................................................................................................... 1-66JOB_QUEUE_PROCESSES ............................................................................................................................... 1-67LARGE_POOL_SIZE .......................................................................................................................................... 1-68LICENSE_MAX_SESSIONS ............................................................................................................................. 1-69LICENSE_MAX_USERS .................................................................................................................................... 1-69LICENSE_SESSIONS_WARNING ................................................................................................................. 1-70LOCAL_LISTENER ............................................................................................................................................ 1-71LOCK_NAME_SPACE ....................................................................................................................................... 1-71LOCK_SGA .......................................................................................................................................................... 1-72LOG_ARCHIVE_DEST ..................................................................................................................................... 1-72LOG_ARCHIVE_DEST_n ................................................................................................................................. 1-74LOG_ARCHIVE_DEST_STATE_n .................................................................................................................. 1-76LOG_ARCHIVE_DUPLEX_DEST ................................................................................................................... 1-77

iii

LOG_ARCHIVE_FORMAT .............................................................................................................................. 1-78LOG_ARCHIVE_MAX_PROCESSES ............................................................................................................. 1-79LOG_ARCHIVE_MIN_SUCCEED_DEST ..................................................................................................... 1-79LOG_ARCHIVE_START ................................................................................................................................... 1-80LOG_ARCHIVE_TRACE .................................................................................................................................. 1-81LOG_BUFFER ...................................................................................................................................................... 1-82LOG_CHECKPOINT_INTERVAL .................................................................................................................. 1-83LOG_CHECKPOINT_TIMEOUT .................................................................................................................... 1-84LOG_CHECKPOINTS_TO_ALERT ................................................................................................................ 1-85LOG_FILE_NAME_CONVERT ....................................................................................................................... 1-85LOGMNR_MAX_PERSISTENT_SESSIONS ................................................................................................ 1-86MAX_COMMIT_PROPAGATION_DELAY ................................................................................................. 1-87MAX_DISPATCHERS ....................................................................................................................................... 1-88MAX_DUMP_FILE_SIZE .................................................................................................................................. 1-89MAX_ENABLED_ROLES .................................................................................................................................. 1-89MAX_ROLLBACK_SEGMENTS ..................................................................................................................... 1-90MAX_SHARED_SERVERS ............................................................................................................................... 1-90MTS_CIRCUITS .................................................................................................................................................. 1-91MTS_DISPATCHERS ........................................................................................................................................ 1-92MTS_MAX_DISPATCHERS ............................................................................................................................ 1-95MTS_MAX_SERVERS ....................................................................................................................................... 1-96MTS_SERVERS ................................................................................................................................................... 1-97MTS_SESSIONS ................................................................................................................................................. 1-97NLS_CALENDAR ............................................................................................................................................... 1-98NLS_COMP .......................................................................................................................................................... 1-99NLS_CURRENCY ............................................................................................................................................... 1-99NLS_DATE_FORMAT ..................................................................................................................................... 1-100NLS_DATE_LANGUAGE ............................................................................................................................... 1-100NLS_DUAL_CURRENCY ............................................................................................................................... 1-101NLS_ISO_CURRENCY .................................................................................................................................... 1-101NLS_LANGUAGE ............................................................................................................................................ 1-102NLS_LENGTH_SEMANTICS ........................................................................................................................ 1-103NLS_NCHAR_CONV_EXCP .......................................................................................................................... 1-103NLS_NUMERIC_CHARACTERS .................................................................................................................. 1-104NLS_SORT ......................................................................................................................................................... 1-104NLS_TERRITORY ............................................................................................................................................. 1-105NLS_TIMESTAMP_FORMAT ....................................................................................................................... 1-106NLS_TIMESTAMP_TZ_FORMAT ................................................................................................................ 1-107

iv

O7_DICTIONARY_ACCESSIBILITY ........................................................................................................... 1-107OBJECT_CACHE_MAX_SIZE_PERCENT ................................................................................................... 1-108OBJECT_CACHE_OPTIMAL_SIZE .............................................................................................................. 1-109OPEN_CURSORS ............................................................................................................................................. 1-109OPEN_LINKS .................................................................................................................................................... 1-110OPEN_LINKS_PER_INSTANCE ................................................................................................................... 1-111OPTIMIZER_FEATURES_ENABLE ............................................................................................................. 1-111OPTIMIZER_INDEX_CACHING ................................................................................................................. 1-113OPTIMIZER_INDEX_COST_ADJ ................................................................................................................. 1-113OPTIMIZER_MAX_PERMUTATIONS ....................................................................................................... 1-114OPTIMIZER_MODE ........................................................................................................................................ 1-115ORACLE_TRACE_COLLECTION_NAME ................................................................................................. 1-116ORACLE_TRACE_COLLECTION_PATH ................................................................................................... 1-117ORACLE_TRACE_COLLECTION_SIZE ..................................................................................................... 1-117ORACLE_TRACE_ENABLE ........................................................................................................................... 1-118ORACLE_TRACE_FACILITY_NAME .......................................................................................................... 1-118ORACLE_TRACE_FACILITY_PATH ........................................................................................................... 1-119OS_AUTHENT_PREFIX .................................................................................................................................. 1-120OS_ROLES ......................................................................................................................................................... 1-121PARALLEL_ADAPTIVE_MULTI_USER ..................................................................................................... 1-122PARALLEL_AUTOMATIC_TUNING .......................................................................................................... 1-122PARALLEL_BROADCAST_ENABLED ....................................................................................................... 1-123PARALLEL_EXECUTION_MESSAGE_SIZE .............................................................................................. 1-124PARALLEL_INSTANCE_GROUP ................................................................................................................. 1-124PARALLEL_MAX_SERVERS ......................................................................................................................... 1-125PARALLEL_MIN_PERCENT ......................................................................................................................... 1-126PARALLEL_MIN_SERVERS .......................................................................................................................... 1-127PARALLEL_THREADS_PER_CPU ............................................................................................................... 1-127PARTITION_VIEW_ENABLED .................................................................................................................... 1-128PGA_AGGREGATE_TARGET ...................................................................................................................... 1-129PLSQL_COMPILER_FLAGS .......................................................................................................................... 1-129PLSQL_NATIVE_C_COMPILER ................................................................................................................... 1-130PLSQL_NATIVE_LIBRARY_DIR ................................................................................................................. 1-131PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT ........................................................................................ 1-131PLSQL_NATIVE_LINKER .............................................................................................................................. 1-132PLSQL_NATIVE_MAKE_FILE_NAME ....................................................................................................... 1-132PLSQL_NATIVE_MAKE_UTILITY .............................................................................................................. 1-133PLSQL_V2_COMPATIBILITY ....................................................................................................................... 1-133

v

PRE_PAGE_SGA ............................................................................................................................................... 1-134PROCESSES ....................................................................................................................................................... 1-135QUERY_REWRITE_ENABLED ...................................................................................................................... 1-136QUERY_REWRITE_INTEGRITY .................................................................................................................. 1-136RDBMS_SERVER_DN ..................................................................................................................................... 1-137READ_ONLY_OPEN_DELAYED .................................................................................................................. 1-138RECOVERY_PARALLELISM ......................................................................................................................... 1-138REMOTE_ARCHIVE_ENABLE ..................................................................................................................... 1-139REMOTE_DEPENDENCIES_MODE ........................................................................................................... 1-139REMOTE_LISTENER ....................................................................................................................................... 1-140REMOTE_LOGIN_PASSWORDFILE .......................................................................................................... 1-141REMOTE_OS_AUTHENT ............................................................................................................................... 1-142REMOTE_OS_ROLES ...................................................................................................................................... 1-142REPLICATION_DEPENDENCY_TRACKING ........................................................................................... 1-143RESOURCE_LIMIT .......................................................................................................................................... 1-143RESOURCE_MANAGER_PLAN ................................................................................................................... 1-144ROLLBACK_SEGMENTS ............................................................................................................................... 1-145ROW_LOCKING ............................................................................................................................................... 1-146SERIAL_REUSE ................................................................................................................................................. 1-147SERVICE_NAMES ............................................................................................................................................ 1-148SESSION_CACHED_CURSORS ................................................................................................................... 1-149SESSION_MAX_OPEN_FILES ...................................................................................................................... 1-149SESSIONS .......................................................................................................................................................... 1-150SGA_MAX_SIZE ............................................................................................................................................... 1-151SHADOW_CORE_DUMP ............................................................................................................................... 1-151SHARED_MEMORY_ADDRESS .................................................................................................................. 1-152SHARED_POOL_RESERVED_SIZE ............................................................................................................. 1-152SHARED_POOL_SIZE ..................................................................................................................................... 1-153SHARED_SERVER_SESSIONS ..................................................................................................................... 1-154SHARED_SERVERS ......................................................................................................................................... 1-154SORT_AREA_RETAINED_SIZE ................................................................................................................... 1-155SORT_AREA_SIZE ........................................................................................................................................... 1-156SPFILE ................................................................................................................................................................. 1-157SQL92_SECURITY ............................................................................................................................................ 1-158SQL_TRACE ....................................................................................................................................................... 1-158STANDBY_ARCHIVE_DEST ........................................................................................................................ 1-159STANDBY_FILE_MANAGEMENT .............................................................................................................. 1-160STANDBY_PRESERVES_NAMES ................................................................................................................ 1-160

vi

STAR_TRANSFORMATION_ENABLED ................................................................................................... 1-161TAPE_ASYNCH_IO ......................................................................................................................................... 1-162THREAD ............................................................................................................................................................. 1-162TIMED_OS_STATISTICS ............................................................................................................................... 1-163TIMED_STATISTICS ...................................................................................................................................... 1-164TRACE_ENABLED ........................................................................................................................................... 1-165TRACEFILE_IDENTIFIER .............................................................................................................................. 1-166TRANSACTION_AUDITING ....................................................................................................................... 1-167TRANSACTIONS ............................................................................................................................................. 1-167TRANSACTIONS_PER_ROLLBACK_SEGMENT .................................................................................... 1-168UNDO_MANAGEMENT ................................................................................................................................ 1-169UNDO_RETENTION ....................................................................................................................................... 1-169UNDO_SUPPRESS_ERRORS ........................................................................................................................ 1-170UNDO_TABLESPACE ..................................................................................................................................... 1-170USE_INDIRECT_DATA_BUFFERS .............................................................................................................. 1-171USER_DUMP_DEST ........................................................................................................................................ 1-171UTL_FILE_DIR .................................................................................................................................................. 1-172WORKAREA_SIZE_POLICY ......................................................................................................................... 1-173

2 静的データ・ディクショナリ・ビュー静的データ・ディクショナリ・ビュー静的データ・ディクショナリ・ビュー静的データ・ディクショナリ・ビュー

ALL_ALL_TABLES ............................................................................................................................................... 2-4ALL_ARGUMENTS ............................................................................................................................................. 2-6ALL_ASSOCIATIONS ......................................................................................................................................... 2-8ALL_BASE_TABLE_MVIEWS ........................................................................................................................... 2-9ALL_CATALOG .................................................................................................................................................. 2-10ALL_CLUSTER_HASH_EXPRESSIONS ....................................................................................................... 2-10ALL_CLUSTERS ................................................................................................................................................. 2-11ALL_COL_COMMENTS ................................................................................................................................... 2-12ALL_COL_PRIVS ................................................................................................................................................ 2-13ALL_COL_PRIVS_MADE ................................................................................................................................. 2-13ALL_COL_PRIVS_RECD .................................................................................................................................. 2-14ALL_COLL_TYPES ............................................................................................................................................. 2-15ALL_CONS_COLUMNS ................................................................................................................................... 2-16ALL_CONSTRAINTS ........................................................................................................................................ 2-16ALL_CONTEXT ................................................................................................................................................... 2-18ALL_DB_LINKS .................................................................................................................................................. 2-18ALL_DEF_AUDIT_OPTS .................................................................................................................................. 2-19ALL_DEPENDENCIES ...................................................................................................................................... 2-20

vii

ALL_DIM_ATTRIBUTES .................................................................................................................................. 2-21ALL_DIM_CHILD_OF ....................................................................................................................................... 2-21ALL_DIM_HIERARCHIES ............................................................................................................................... 2-22ALL_DIM_JOIN_KEY ........................................................................................................................................ 2-22ALL_DIM_LEVEL_KEY ..................................................................................................................................... 2-23ALL_DIM_LEVELS ............................................................................................................................................. 2-23ALL_DIMENSIONS ........................................................................................................................................... 2-24ALL_DIRECTORIES .......................................................................................................................................... 2-24ALL_ERRORS ...................................................................................................................................................... 2-25ALL_EXTERNAL_TABLES ............................................................................................................................... 2-25ALL_HISTOGRAMS .......................................................................................................................................... 2-26ALL_IND_COLUMNS ....................................................................................................................................... 2-26ALL_IND_EXPRESSIONS ................................................................................................................................ 2-27ALL_IND_PARTITIONS ................................................................................................................................... 2-28ALL_IND_SUBPARTITIONS .......................................................................................................................... 2-30ALL_INDEXES ..................................................................................................................................................... 2-32ALL_INDEXTYPE_COMMENTS .................................................................................................................... 2-35ALL_INDEXTYPE_OPERATORS .................................................................................................................... 2-36ALL_INDEXTYPES ............................................................................................................................................. 2-36ALL_INTERNAL_TRIGGERS ......................................................................................................................... 2-37ALL_JOBS ............................................................................................................................................................. 2-38ALL_JOIN_IND_COLUMNS ........................................................................................................................... 2-39ALL_LIBRARIES ................................................................................................................................................. 2-40ALL_LOB_PARTITIONS .................................................................................................................................. 2-40ALL_LOB_SUBPARTITIONS .......................................................................................................................... 2-42ALL_LOBS ............................................................................................................................................................ 2-43ALL_LOG_GROUP_COLUMNS ..................................................................................................................... 2-45ALL_LOG_GROUPS .......................................................................................................................................... 2-45ALL_METHOD_PARAMS ................................................................................................................................ 2-46ALL_METHOD_RESULTS ............................................................................................................................... 2-47ALL_MVIEW_AGGREGATES ......................................................................................................................... 2-47ALL_MVIEW_ANALYSIS ................................................................................................................................. 2-48ALL_MVIEW_DETAIL_RELATIONS ............................................................................................................ 2-50ALL_MVIEW_JOINS ......................................................................................................................................... 2-51ALL_MVIEW_KEYS ........................................................................................................................................... 2-52ALL_MVIEW_REFRESH_TIMES .................................................................................................................... 2-53ALL_MVIEWS ..................................................................................................................................................... 2-53ALL_NESTED_TABLES .................................................................................................................................... 2-57

viii

ALL_OBJECT_TABLES ..................................................................................................................................... 2-57ALL_OBJECTS ..................................................................................................................................................... 2-60ALL_OPANCILLARY ......................................................................................................................................... 2-61ALL_OPARGUMENTS ...................................................................................................................................... 2-61ALL_OPBINDINGS ........................................................................................................................................... 2-62ALL_OPERATOR_COMMENTS ..................................................................................................................... 2-62ALL_OPERATORS ............................................................................................................................................. 2-63ALL_OUTLINE_HINTS ..................................................................................................................................... 2-63ALL_OUTLINES ................................................................................................................................................. 2-64ALL_PART_COL_STATISTICS ....................................................................................................................... 2-65ALL_PART_HISTOGRAMS ............................................................................................................................. 2-66ALL_PART_INDEXES ....................................................................................................................................... 2-66ALL_PART_KEY_COLUMNS .......................................................................................................................... 2-68ALL_PART_LOBS ............................................................................................................................................... 2-69ALL_PART_TABLES .......................................................................................................................................... 2-70ALL_PARTIAL_DROP_TABS .......................................................................................................................... 2-72ALL_POLICIES .................................................................................................................................................... 2-72ALL_PROCEDURES ........................................................................................................................................... 2-73ALL_PUBLISHED_COLUMNS ....................................................................................................................... 2-74ALL_QUEUE_TABLES ....................................................................................................................................... 2-75ALL_QUEUES ...................................................................................................................................................... 2-76ALL_REFRESH .................................................................................................................................................... 2-77ALL_REFRESH_CHILDREN ............................................................................................................................ 2-78ALL_REFRESH_DEPENDENCIES .................................................................................................................. 2-79ALL_REFS ............................................................................................................................................................. 2-79ALL_REGISTERED_MVIEWS ......................................................................................................................... 2-80ALL_REGISTERED_SNAPSHOTS ................................................................................................................. 2-81ALL_SEQUENCES .............................................................................................................................................. 2-82ALL_SNAPSHOT_LOGS .................................................................................................................................. 2-82ALL_SNAPSHOT_REFRESH_TIMES ............................................................................................................ 2-83ALL_SOURCE ...................................................................................................................................................... 2-83ALL_SOURCE_TABLES .................................................................................................................................... 2-84ALL_SQLJ_TYPE_ATTRS ................................................................................................................................. 2-84ALL_SQLJ_TYPE_METHODS ......................................................................................................................... 2-85ALL_SQLJ_TYPES .............................................................................................................................................. 2-86ALL_STORED_SETTINGS ............................................................................................................................... 2-87ALL_SUBPART_COL_STATISTICS .............................................................................................................. 2-88ALL_SUBPART_HISTOGRAMS .................................................................................................................... 2-89

ix

ALL_SUBPART_KEY_COLUMNS .................................................................................................................. 2-89ALL_SUBSCRIBED_COLUMNS ..................................................................................................................... 2-90ALL_SUBSCRIBED_TABLES ........................................................................................................................... 2-91ALL_SUBSCRIPTIONS ..................................................................................................................................... 2-91ALL_SUMDELTA ............................................................................................................................................... 2-92ALL_SYNONYMS ............................................................................................................................................... 2-93ALL_TAB_COL_STATISTICS ......................................................................................................................... 2-93ALL_TAB_COLUMNS ....................................................................................................................................... 2-94ALL_TAB_COMMENTS ................................................................................................................................... 2-96ALL_TAB_HISTOGRAMS ............................................................................................................................... 2-97ALL_TAB_MODIFICATIONS ......................................................................................................................... 2-97ALL_TAB_PARTITIONS .................................................................................................................................. 2-98ALL_TAB_PRIVS .............................................................................................................................................. 2-100ALL_TAB_PRIVS_MADE ............................................................................................................................... 2-101ALL_TAB_PRIVS_RECD ................................................................................................................................ 2-101ALL_TAB_SUBPARTITIONS ........................................................................................................................ 2-102ALL_TABLES ..................................................................................................................................................... 2-103ALL_TRIGGER_COLS ..................................................................................................................................... 2-106ALL_TRIGGERS ............................................................................................................................................... 2-107ALL_TYPE_ATTRS ........................................................................................................................................... 2-108ALL_TYPE_METHODS ................................................................................................................................... 2-109ALL_TYPES ........................................................................................................................................................ 2-110ALL_UNUSED_COL_TABS ........................................................................................................................... 2-111ALL_UPDATABLE_COLUMNS .................................................................................................................... 2-111ALL_USERS ....................................................................................................................................................... 2-112ALL_USTATS .................................................................................................................................................... 2-112ALL_VARRAYS ................................................................................................................................................. 2-113ALL_VIEWS ....................................................................................................................................................... 2-114AUDIT_ACTIONS ............................................................................................................................................ 2-114CATALOG .......................................................................................................................................................... 2-115CAT ...................................................................................................................................................................... 2-115CHAINED_ROWS ............................................................................................................................................ 2-115CHANGE_SOURCES ....................................................................................................................................... 2-115CHANGE_SETS ................................................................................................................................................ 2-116CHANGE_TABLES ........................................................................................................................................... 2-117CLU ...................................................................................................................................................................... 2-117CODE_PIECES ................................................................................................................................................... 2-117CODE_SIZE ........................................................................................................................................................ 2-117

x

COL ...................................................................................................................................................................... 2-118COLS .................................................................................................................................................................... 2-118COLUMN_PRIVILEGES ................................................................................................................................. 2-118DATABASE_PROPERTIES ............................................................................................................................ 2-118DBA_2PC_NEIGHBORS ................................................................................................................................. 2-118DBA_2PC_PENDING ....................................................................................................................................... 2-119DBA_ALL_TABLES .......................................................................................................................................... 2-119DBA_APPLICATION_ROLES ....................................................................................................................... 2-120DBA_ASSOCIATIONS ................................................................................................................................... 2-120DBA_AUDIT_EXISTS ...................................................................................................................................... 2-120DBA_AUDIT_OBJECT .................................................................................................................................... 2-121DBA_AUDIT_SESSION .................................................................................................................................. 2-122DBA_AUDIT_STATEMENT .......................................................................................................................... 2-123DBA_AUDIT_TRAIL ....................................................................................................................................... 2-125DBA_BLOCKERS ............................................................................................................................................. 2-126DBA_BASE_TABLE_MVIEWS ...................................................................................................................... 2-127DBA_CATALOG ............................................................................................................................................... 2-127DBA_CLU_COLUMNS .................................................................................................................................... 2-127DBA_CLUSTER_HASH_EXPRESSIONS .................................................................................................... 2-127DBA_CLUSTERS .............................................................................................................................................. 2-127DBA_COL_COMMENTS ................................................................................................................................ 2-128DBA_COL_PRIVS ............................................................................................................................................. 2-128DBA_COLL_TYPES .......................................................................................................................................... 2-128DBA_CONS_COLUMNS ................................................................................................................................ 2-128DBA_CONSTRAINTS ..................................................................................................................................... 2-128DBA_CONTEXT ................................................................................................................................................ 2-128DBA_DATA_FILES .......................................................................................................................................... 2-128DBA_DB_LINKS ............................................................................................................................................... 2-129DBA_DDL_LOCKS .......................................................................................................................................... 2-129DBA_DEPENDENCIES ................................................................................................................................... 2-130DBA_DIM_ATTRIBUTES ............................................................................................................................... 2-130DBA_DIM_CHILD_OF .................................................................................................................................... 2-130DBA_DIM_HIERARCHIES ............................................................................................................................ 2-130DBA_DIM_JOIN_KEY ..................................................................................................................................... 2-130DBA_DIM_LEVEL_KEY .................................................................................................................................. 2-130DBA_DIM_LEVELS ......................................................................................................................................... 2-130DBA_DIMENSIONS ........................................................................................................................................ 2-131DBA_DIRECTORIES ....................................................................................................................................... 2-131

xi

DBA_DML_LOCKS .......................................................................................................................................... 2-131DBA_ERRORS ................................................................................................................................................... 2-132DBA_EXP_FILES ............................................................................................................................................... 2-132DBA_EXP_OBJECTS ........................................................................................................................................ 2-132DBA_EXP_VERSION ....................................................................................................................................... 2-132DBA_EXTENTS ................................................................................................................................................. 2-133DBA_EXTERNAL_TABLES ............................................................................................................................ 2-133DBA_FREE_SPACE .......................................................................................................................................... 2-134DBA_FREE_SPACE_COALESCED ............................................................................................................... 2-134DBA_HISTOGRAMS ....................................................................................................................................... 2-135DBA_IND_COLUMNS .................................................................................................................................... 2-135DBA_IND_EXPRESSIONS ............................................................................................................................. 2-135DBA_IND_PARTITIONS ............................................................................................................................... 2-135DBA_IND_SUBPARTITIONS ....................................................................................................................... 2-135DBA_INDEXES ................................................................................................................................................. 2-135DBA_INDEXTYPE_COMMENTS ................................................................................................................. 2-136DBA_INDEXTYPE_OPERATORS ................................................................................................................. 2-136DBA_INDEXTYPES .......................................................................................................................................... 2-136DBA_INTERNAL_TRIGGERS ...................................................................................................................... 2-136DBA_JOBS .......................................................................................................................................................... 2-136DBA_JOBS_RUNNING ................................................................................................................................... 2-136DBA_JOIN_IND_COLUMNS ........................................................................................................................ 2-137DBA_KGLLOCK ............................................................................................................................................... 2-137DBA_LIBRARIES .............................................................................................................................................. 2-137DBA_LOB_PARTITIONS ............................................................................................................................... 2-137DBA_LOB_SUBPARTITIONS ....................................................................................................................... 2-138DBA_LOBS ......................................................................................................................................................... 2-138DBA_LOCK_INTERNAL ................................................................................................................................ 2-138DBA_LOCKS ..................................................................................................................................................... 2-138DBA_LOG_GROUP_COLUMNS .................................................................................................................. 2-139DBA_LOG_GROUPS ....................................................................................................................................... 2-139DBA_METHOD_PARAMS ............................................................................................................................. 2-139DBA_METHOD_RESULTS ............................................................................................................................ 2-139DBA_MVIEW_AGGREGATES ..................................................................................................................... 2-139DBA_MVIEW_ANALYSIS ............................................................................................................................. 2-140DBA_MVIEW_DETAIL_RELATIONS ......................................................................................................... 2-140DBA_MVIEW_JOINS ...................................................................................................................................... 2-140DBA_MVIEW_KEYS ........................................................................................................................................ 2-140

xii

DBA_MVIEW_LOG_FILTER_COLS ............................................................................................................ 2-141DBA_MVIEW_REFRESH_TIMES ................................................................................................................. 2-141DBA_MVIEWS .................................................................................................................................................. 2-141DBA_NESTED_TABLES ................................................................................................................................. 2-141DBA_OBJ_AUDIT_OPTS ............................................................................................................................... 2-141DBA_OBJECT_SIZE ......................................................................................................................................... 2-142DBA_OBJECT_TABLES .................................................................................................................................. 2-143DBA_OBJECTS .................................................................................................................................................. 2-143DBA_OPANCILLARY ..................................................................................................................................... 2-143DBA_OPARGUMENTS ................................................................................................................................... 2-143DBA_OPBINDINGS ........................................................................................................................................ 2-143DBA_OPERATOR_COMMENTS ................................................................................................................. 2-144DBA_OPERATORS .......................................................................................................................................... 2-144DBA_ORPHAN_KEY_TABLE ........................................................................................................................ 2-144DBA_OUTLINE_HINTS ................................................................................................................................. 2-144DBA_OUTLINES .............................................................................................................................................. 2-145DBA_PART_COL_STATISTICS ................................................................................................................... 2-145DBA_PART_HISTOGRAMS ......................................................................................................................... 2-145DBA_PART_INDEXES .................................................................................................................................... 2-145DBA_PART_KEY_COLUMNS ....................................................................................................................... 2-145DBA_PART_LOBS ............................................................................................................................................ 2-145DBA_PART_TABLES ....................................................................................................................................... 2-145DBA_PARTIAL_DROP_TABS ....................................................................................................................... 2-146DBA_PENDING_TRANSACTIONS ............................................................................................................ 2-146DBA_POLICIES ................................................................................................................................................. 2-146DBA_PRIV_AUDIT_OPTS ............................................................................................................................. 2-146DBA_PROCEDURES ....................................................................................................................................... 2-147DBA_PROFILES ................................................................................................................................................ 2-147DBA_PROXIES .................................................................................................................................................. 2-147DBA_PUBLISHED_COLUMNS .................................................................................................................... 2-148DBA_QUEUE_SCHEDULES .......................................................................................................................... 2-148DBA_QUEUE_TABLES ................................................................................................................................... 2-150DBA_QUEUES ................................................................................................................................................... 2-150DBA_RCHILD ................................................................................................................................................... 2-150DBA_REFRESH ................................................................................................................................................. 2-150DBA_REFRESH_CHILDREN ......................................................................................................................... 2-150DBA_REFS .......................................................................................................................................................... 2-151DBA_REGISTERED_MVIEW_GROUPS ..................................................................................................... 2-151

xiii

DBA_REGISTERED_MVIEWS ...................................................................................................................... 2-151DBA_REGISTERED_SNAPSHOT_GROUPS ............................................................................................. 2-151DBA_REGISTERED_SNAPSHOTS .............................................................................................................. 2-152DBA_REPAIR_TABLE ..................................................................................................................................... 2-152DBA_RESUMABLE .......................................................................................................................................... 2-153DBA_RGROUP .................................................................................................................................................. 2-154DBA_ROLE_PRIVS .......................................................................................................................................... 2-155DBA_ROLES ...................................................................................................................................................... 2-155DBA_ROLLBACK_SEGS ................................................................................................................................ 2-155DBA_RSRC_CONSUMER_GROUP_PRIVS ............................................................................................... 2-156DBA_RSRC_CONSUMER_GROUPS ........................................................................................................... 2-157DBA_RSRC_MANAGER_SYSTEM_PRIVS ............................................................................................... 2-157DBA_RSRC_PLAN_DIRECTIVES ................................................................................................................ 2-158DBA_RSRC_PLANS ......................................................................................................................................... 2-159DBA_SEGMENTS ............................................................................................................................................. 2-160DBA_SEQUENCES ........................................................................................................................................... 2-161DBA_SNAPSHOT_LOG_FILTER_COLS .................................................................................................... 2-161DBA_SNAPSHOT_LOGS ............................................................................................................................... 2-161DBA_SNAPSHOT_REFRESH_TIMES ......................................................................................................... 2-161DBA_SNAPSHOTS .......................................................................................................................................... 2-161DBA_SOURCE ................................................................................................................................................... 2-161DBA_SOURCE_TABLES ................................................................................................................................. 2-161DBA_SQLJ_TYPE_ATTRS .............................................................................................................................. 2-162DBA_SQLJ_TYPE_METHODS ...................................................................................................................... 2-162DBA_SQLJ_TYPES ........................................................................................................................................... 2-162DBA_STMT_AUDIT_OPTS ........................................................................................................................... 2-162DBA_STORED_SETTINGS ............................................................................................................................ 2-162DBA_SUBPART_COL_STATISTICS ........................................................................................................... 2-163DBA_SUBPART_HISTOGRAMS ................................................................................................................. 2-163DBA_SUBPART_KEY_COLUMNS ............................................................................................................... 2-163DBA_SUBSCRIBED_COLUMNS .................................................................................................................. 2-163DBA_SUBSCRIBED_TABLES ....................................................................................................................... 2-163DBA_SUBSCRIPTIONS .................................................................................................................................. 2-163DBA_SYNONYMS ........................................................................................................................................... 2-164DBA_SYS_PRIVS .............................................................................................................................................. 2-164DBA_TAB_COL_STATISTICS ...................................................................................................................... 2-164DBA_TAB_COLUMNS .................................................................................................................................... 2-164DBA_TAB_COMMENTS ................................................................................................................................ 2-164

xiv

DBA_TAB_HISTOGRAMS ............................................................................................................................ 2-165DBA_TAB_MODIFICATIONS ...................................................................................................................... 2-165DBA_TAB_PARTITIONS ............................................................................................................................... 2-165DBA_TAB_PRIVS ............................................................................................................................................. 2-165DBA_TAB_SUBPARTITIONS ....................................................................................................................... 2-165DBA_TABLES .................................................................................................................................................... 2-166DBA_TABLESPACES ....................................................................................................................................... 2-166DBA_TEMP_FILES ........................................................................................................................................... 2-167DBA_TRANSFORMATIONS ........................................................................................................................ 2-167DBA_TRIGGER_COLS ................................................................................................................................... 2-168DBA_TRIGGERS .............................................................................................................................................. 2-168DBA_TS_QUOTAS ........................................................................................................................................... 2-169DBA_TYPE_ATTRS .......................................................................................................................................... 2-169DBA_TYPE_METHODS .................................................................................................................................. 2-169DBA_TYPES ....................................................................................................................................................... 2-169DBA_UNDO_EXTENTS .................................................................................................................................. 2-170DBA_UNUSED_COL_TABS .......................................................................................................................... 2-170DBA_UPDATABLE_COLUMNS ................................................................................................................... 2-170DBA_USERS ...................................................................................................................................................... 2-171DBA_USTATS ................................................................................................................................................... 2-171DBA_VARRAYS ............................................................................................................................................... 2-171DBA_VIEWS ...................................................................................................................................................... 2-172DBA_WAITERS ................................................................................................................................................. 2-172DBMS_ALERT_INFO ...................................................................................................................................... 2-172DBMS_LOCK_ALLOCATED ......................................................................................................................... 2-173DEPTREE ............................................................................................................................................................ 2-173DICT ...........................................................

Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1）部品番号:...

Documents

Transcript of Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1）部品番号:...

Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1） 部品番号:...

Documents

Transcript of Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1） 部品番号:...

Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1）部品番号:...

Transcript of Oracle9i...Oracle9i データベース・リファレンス, リリース1（9.0.1）部品番号:...