Oracle Database リファレンス -- 目次

対象読者

ドキュメントのアクセシビリティについて

関連ドキュメント

表記規則

サポートおよびサービス

Oracle Database 10g リリース2（10.2）の新機能

Oracle Database 10g リリース1（10.1）の新機能

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

パラメータの不正確な設定

パラメータの説明の読み方

初期化パラメータの説明

ACTIVE_INSTANCE_COUNT

BACKUP_TAPE_IO_SLAVES

BITMAP_MERGE_AREA_SIZE

BLANK_TRIMMING

CIRCUITS

CLUSTER_DATABASE

CLUSTER_DATABASE_INSTANCES

CLUSTER_INTERCONNECTS

COMMIT_POINT_STRENGTH

COMMIT_WRITE

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_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

DG_BROKER_CONFIG_FILEn

DG_BROKER_START

DISK_ASYNCH_IO

DISPATCHERS

DISTRIBUTED_LOCK_TIMEOUT

FAST_START_MTTR_TARGET

FAST_START_PARALLEL_ROLLBACK

FILE_MAPPING

FILEIO_NETWORK_ADAPTERS

GLOBAL_CONTEXT_POOL_SIZE

GLOBAL_NAMES

HASH_AREA_SIZE

HI_SHARED_MEMORY_ADDRESS

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

LOG_ARCHIVE_DEST_STATE_n

LOG_ARCHIVE_DUPLEX_DEST

LOG_ARCHIVE_FORMAT

LOG_ARCHIVE_LOCAL_FIRST

LOG_ARCHIVE_MAX_PROCESSES

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

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

OPTIMIZER_SECURE_VIEW_MERGING

OS_AUTHENT_PREFIX

OS_ROLES

PARALLEL_ADAPTIVE_MULTI_USER

PARALLEL_AUTOMATIC_TUNING

PARALLEL_EXECUTION_MESSAGE_SIZE

PARALLEL_INSTANCE_GROUP

PARALLEL_MAX_SERVERS

PARALLEL_MIN_PERCENT

PARALLEL_MIN_SERVERS

PARALLEL_THREADS_PER_CPU

PLSQL_NATIVE_LIBRARY_DIR

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT

PLSQL_OPTIMIZE_LEVEL

PLSQL_V2_COMPATIBILITY

PLSQL_WARNINGS

PRE_11G_ENABLE_CAPTURE

PRE_PAGE_SGA

PROCESSES

QUERY_REWRITE_ENABLED

QUERY_REWRITE_INTEGRITY

RDBMS_SERVER_DN

READ_ONLY_OPEN_DELAYED

RECOVERY_PARALLELISM

RECYCLEBIN

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

SESSION_CACHED_CURSORS

SESSION_MAX_OPEN_FILES

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

STANDBY_FILE_MANAGEMENT

STAR_TRANSFORMATION_ENABLED

TRANSACTIONS_PER_ROLLBACK_SEGMENT

UNDO_MANAGEMENT

UNDO_RETENTION

UNDO_TABLESPACE

USE_INDIRECT_DATA_BUFFERS

Oracle Replicationビュー

Oracle Workspace Managerビュー

ALL_APPLY_CONFLICT_COLUMNS

ALL_APPLY_DML_HANDLERS

ALL_APPLY_ENQUEUE

ALL_APPLY_ERROR

ALL_APPLY_EXECUTE

ALL_APPLY_KEY_COLUMNS

ALL_APPLY_PARAMETERS

ALL_APPLY_PROGRESS

ALL_APPLY_TABLE_COLUMNS

ALL_ARGUMENTS

ALL_ASSOCIATIONS

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_ENCRYPTED_COLUMNS

ALL_ERRORS

ALL_EVALUATION_CONTEXT_TABLES

ALL_EVALUATION_CONTEXT_VARS

ALL_EVALUATION_CONTEXTS

ALL_EXTERNAL_LOCATIONS

ALL_EXTERNAL_TABLES

ALL_FILE_GROUP_EXPORT_INFO

ALL_FILE_GROUP_FILES

ALL_FILE_GROUP_TABLES

ALL_FILE_GROUP_TABLESPACES

ALL_FILE_GROUP_VERSIONS

ALL_IND_SUBPARTITIONS

ALL_INDEXES

ALL_INDEXTYPE_ARRAYTYPES

ALL_INDEXTYPE_COMMENTS

ALL_INDEXTYPE_OPERATORS

ALL_INDEXTYPES

ALL_INTERNAL_TRIGGERS

ALL_LOB_SUBPARTITIONS

ALL_LOB_TEMPLATES

ALL_LOBS

ALL_LOG_GROUP_COLUMNS

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_JOINS

ALL_MVIEW_KEYS

ALL_MVIEW_LOGS

ALL_MVIEW_REFRESH_TIMES

ALL_MVIEWS

ALL_NESTED_TABLE_COLS

ALL_OPERATOR_COMMENTS

ALL_OPERATORS

ALL_OUTLINE_HINTS

ALL_OUTLINES

ALL_PART_COL_STATISTICS

ALL_PARTIAL_DROP_TABS

ALL_PENDING_CONV_TABLES

ALL_PLSQL_OBJECT_SETTINGS

ALL_PUBLISHED_COLUMNS

ALL_QUEUE_SUBSCRIBERS

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_CHAIN_RULES

ALL_SCHEDULER_CHAIN_STEPS

ALL_SCHEDULER_CHAINS

ALL_SCHEDULER_GLOBAL_ATTRIBUTE

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_CHAINS

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_SQLJ_TYPE_METHODS

ALL_SQLSET_REFERENCES

ALL_SQLSET_STATEMENTS

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_MODIFICATIONS

ALL_TAB_STATS_HISTORY

ALL_TAB_SUBPARTITIONS

ALL_UPDATABLE_COLUMNS

CHANGE_PROPAGATION_SETS

DBA_ADVISOR_DEF_PARAMETERS

DBA_ADVISOR_DEFINITIONS

DBA_ADVISOR_FINDINGS

DBA_ADVISOR_JOURNAL

DBA_ADVISOR_LOG

DBA_ADVISOR_OBJECT_TYPES

DBA_ADVISOR_OBJECTS

DBA_ADVISOR_PARAMETERS

DBA_ADVISOR_RATIONALE

DBA_ADVISOR_RECOMMENDATIONS

DBA_ADVISOR_SQLA_REC_SUM

DBA_ADVISOR_SQLA_WK_MAP

DBA_ADVISOR_SQLA_WK_STMTS

DBA_ADVISOR_SQLW_JOURNAL

DBA_ADVISOR_SQLW_PARAMETERS

DBA_ADVISOR_SQLW_STMTS

DBA_ADVISOR_SQLW_SUM

DBA_ADVISOR_SQLW_TABLES

DBA_ADVISOR_SQLW_TEMPLATES

DBA_ADVISOR_TASKS

DBA_ADVISOR_TEMPLATES

DBA_ADVISOR_USAGE

DBA_ALERT_HISTORY

DBA_ALL_TABLES

DBA_APPLICATION_ROLES

DBA_APPLY

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_OBJECT_DEPENDENCIES

DBA_APPLY_PARAMETERS

DBA_APPLY_PROGRESS

DBA_APPLY_SPILL_TXN

DBA_APPLY_TABLE_COLUMNS

DBA_APPLY_VALUE_DEPENDENCIES

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_AUTO_SEGADV_SUMMARY

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_CHANGE_NOTIFICATION_REGS

DBA_CLU_COLUMNS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_COMMON_AUDIT_TRAIL

DBA_CONNECT_ROLE_GRANTEES

DBA_CONS_OBJ_COLUMNS

DBA_CONSTRAINTS

DBA_CONTEXT

DBA_CPU_USAGE_STATISTICS

DBA_DATA_FILES

DBA_DATAPUMP_JOBS

DBA_DATAPUMP_SESSIONS

DBA_ENABLED_AGGREGATIONS

DBA_ENABLED_TRACES

DBA_ENCRYPTED_COLUMNS

DBA_EPG_DAD_AUTHORIZATION

DBA_ERRORS

DBA_EVALUATION_CONTEXT_TABLES

DBA_EVALUATION_CONTEXT_VARS

DBA_EVALUATION_CONTEXTS

DBA_EXTERNAL_LOCATIONS

DBA_EXTERNAL_TABLES

DBA_FEATURE_USAGE_STATISTICS

DBA_FGA_AUDIT_TRAIL

DBA_FILE_GROUP_EXPORT_INFO

DBA_FILE_GROUP_FILES

DBA_FILE_GROUP_TABLES

DBA_FILE_GROUP_TABLESPACES

DBA_FILE_GROUP_VERSIONS

DBA_FILE_GROUPS

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_BUFFERED_QUEUES

DBA_HIST_BUFFERED_SUBSCRIBERS

DBA_HIST_COMP_IOSTAT

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_INST_CACHE_TRANSFER

DBA_HIST_INSTANCE_RECOVERY

DBA_HIST_JAVA_POOL_ADVICE

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_PROCESS_MEM_SUMMARY

DBA_HIST_RESOURCE_LIMIT

DBA_HIST_ROWCACHE_SUMMARY

DBA_HIST_RULE_SET

DBA_HIST_SEG_STAT

DBA_HIST_SEG_STAT_OBJ

DBA_HIST_SERVICE_NAME

DBA_HIST_SERVICE_STAT

DBA_HIST_SERVICE_WAIT_CLASS

DBA_HIST_SESS_TIME_STATS

DBA_HIST_SESSMETRIC_HISTORY

DBA_HIST_SGA

DBA_HIST_SGA_TARGET_ADVICE

DBA_HIST_SGASTAT

DBA_HIST_SHARED_POOL_ADVICE

DBA_HIST_SNAP_ERROR

DBA_HIST_SNAPSHOT

DBA_HIST_SQL_BIND_METADATA

DBA_HIST_SQL_PLAN

DBA_HIST_SQL_SUMMARY

DBA_HIST_SQL_WORKAREA_HSTGRM

DBA_HIST_STREAMS_APPLY_SUM

DBA_HIST_STREAMS_CAPTURE

DBA_HIST_STREAMS_POOL_ADVICE

DBA_HIST_SYS_TIME_MODEL

DBA_HIST_SYSMETRIC_HISTORY

DBA_HIST_SYSMETRIC_SUMMARY

DBA_HIST_SYSSTAT

DBA_HIST_SYSTEM_EVENT

DBA_HIST_TABLESPACE_STAT

DBA_HIST_TBSPC_SPACE_USAGE

DBA_HIST_WAITCLASSMET_HISTORY

DBA_IND_SUBPARTITIONS

DBA_INDEXES

DBA_INDEXTYPE_ARRAYTYPES

DBA_INDEXTYPE_COMMENTS

DBA_INDEXTYPE_OPERATORS

DBA_INDEXTYPES

DBA_INTERNAL_TRIGGERS

DBA_LOB_SUBPARTITIONS

DBA_LOG_GROUP_COLUMNS

DBA_LOG_GROUPS

DBA_LOGMNR_LOG

DBA_LOGMNR_PURGED_LOG

DBA_LOGSTDBY_NOT_UNIQUE

DBA_LOGSTDBY_PARAMETERS

DBA_LOGSTDBY_PROGRESS

DBA_LOGSTDBY_SKIP

DBA_LOGSTDBY_SKIP_TRANSACTION

DBA_LOGSTDBY_UNSUPPORTED

DBA_MVIEW_DETAIL_RELATIONS

DBA_MVIEW_JOINS

DBA_MVIEW_KEYS

DBA_MVIEW_LOG_FILTER_COLS

DBA_MVIEW_LOGS

DBA_MVIEW_REFRESH_TIMES

DBA_MVIEWS

DBA_NESTED_TABLE_COLS

DBA_OPERATOR_COMMENTS

DBA_OPERATORS

DBA_OPTSTAT_OPERATIONS

DBA_ORPHAN_KEY_TABLE

DBA_OUTLINE_HINTS

DBA_OUTLINES

DBA_OUTSTANDING_ALERTS

DBA_PART_COL_STATISTICS

DBA_PARTIAL_DROP_TABS

DBA_PENDING_CONV_TABLES

DBA_PENDING_TRANSACTIONS

DBA_PLSQL_OBJECT_SETTINGS

DBA_PUBLISHED_COLUMNS

DBA_QUEUE_SCHEDULES

DBA_QUEUE_SUBSCRIBERS

DBA_QUEUE_TABLES

DBA_QUEUES

DBA_RCHILD

DBA_RECOVERABLE_SCRIPT

DBA_RECOVERABLE_SCRIPT_BLOCKS

DBA_RECOVERABLE_SCRIPT_ERRORS

DBA_RECOVERABLE_SCRIPT_PARAMS

DBA_RECYCLEBIN

DBA_REDEFINITION_ERRORS

DBA_REDEFINITION_OBJECTS

DBA_REFRESH

DBA_REFRESH_CHILDREN

DBA_REFS

DBA_REGISTERED_ARCHIVED_LOG

DBA_REGISTERED_MVIEW_GROUPS

DBA_REGISTERED_MVIEWS

DBA_REGISTRY

DBA_REGISTRY_HIERARCHY

DBA_REGISTRY_HISTORY

DBA_REGISTRY_LOG

DBA_REPAIR_TABLE

DBA_RESOURCE_INCARNATIONS

DBA_RESUMABLE

DBA_REWRITE_EQUIVALENCES

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_GROUP_MAPPINGS

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_MAPPING_PRIORITY

DBA_RSRC_PLAN_DIRECTIVES

DBA_SCHEDULER_CHAIN_RULES

DBA_SCHEDULER_CHAIN_STEPS

DBA_SCHEDULER_CHAINS

DBA_SCHEDULER_GLOBAL_ATTRIBUTE

DBA_SCHEDULER_JOB_ARGS

DBA_SCHEDULER_JOB_CLASSES

DBA_SCHEDULER_JOB_LOG

DBA_SCHEDULER_JOB_RUN_DETAILS

DBA_SCHEDULER_JOBS

DBA_SCHEDULER_PROGRAM_ARGS

DBA_SCHEDULER_PROGRAMS

DBA_SCHEDULER_RUNNING_CHAINS

DBA_SCHEDULER_RUNNING_JOBS

DBA_SCHEDULER_SCHEDULES

DBA_SCHEDULER_WINDOW_DETAILS

DBA_SCHEDULER_WINDOW_GROUPS

DBA_SCHEDULER_WINDOW_LOG

DBA_SCHEDULER_WINDOWS

DBA_SCHEDULER_WINGROUP_MEMBERS

DBA_SEC_RELEVANT_COLS

DBA_SQLJ_TYPE_METHODS

DBA_SQLSET_REFERENCES

DBA_SQLSET_STATEMENTS

DBA_SQLTUNE_BINDS

DBA_SQLTUNE_PLANS

DBA_SQLTUNE_RATIONALE_PLAN

DBA_SQLTUNE_STATISTICS

DBA_STMT_AUDIT_OPTS

DBA_STORED_SETTINGS

DBA_STREAMS_ADD_COLUMN

DBA_STREAMS_ADMINISTRATOR

DBA_STREAMS_DELETE_COLUMN

DBA_STREAMS_GLOBAL_RULES

DBA_STREAMS_MESSAGE_CONSUMERS

DBA_STREAMS_MESSAGE_RULES

DBA_STREAMS_NEWLY_SUPPORTED

DBA_STREAMS_RENAME_COLUMN

DBA_STREAMS_RENAME_SCHEMA

DBA_STREAMS_RENAME_TABLE

DBA_STREAMS_RULES

DBA_STREAMS_SCHEMA_RULES

DBA_STREAMS_TABLE_RULES

DBA_STREAMS_TRANSFORM_FUNCTION

DBA_STREAMS_TRANSFORMATIONS

DBA_STREAMS_UNSUPPORTED

DBA_SUBPART_COL_STATISTICS

DBA_SUBPART_HISTOGRAMS

DBA_SUBPART_KEY_COLUMNS

DBA_SUBPARTITION_TEMPLATES

DBA_SUBSCRIBED_COLUMNS

DBA_SUBSCRIBED_TABLES

DBA_SUBSCRIPTIONS

DBA_SYNONYMS

DBA_SYS_PRIVS

DBA_TAB_COL_STATISTICS

DBA_TAB_MODIFICATIONS

DBA_TAB_PARTITIONS

DBA_TAB_PRIVS

DBA_TAB_STATISTICS

DBA_TAB_STATS_HISTORY

DBA_TAB_SUBPARTITIONS

DBA_TABLES

DBA_TABLESPACE_GROUPS

DBA_UPDATABLE_COLUMNS

DBA_WORKLOAD_CAPTURES

FLASHBACK_TRANSACTION_QUERY

HS_EXTERNAL_OBJECT_PRIVILEGES

HS_EXTERNAL_OBJECTS

HS_EXTERNAL_USER_PRIVILEGES

NLS_DATABASE_PARAMETERS

NLS_INSTANCE_PARAMETERS

NLS_SESSION_PARAMETERS

OBJ

PLAN_TABLE

PLUGGABLE_SET_CHECK

PRODUCT_COMPONENT_VERSION

STMT_AUDIT_OPTION_MAP

TS_PITR_OBJECTS_TO_BE_DROPPED

UNI_PLUGGABLE_SET_CHECK

USER_ADVISOR_ACTIONS

USER_ADVISOR_FINDINGS

USER_ADVISOR_JOURNAL

USER_ADVISOR_LOG

USER_ADVISOR_OBJECTS

USER_ADVISOR_PARAMETERS

USER_ADVISOR_RATIONALE

USER_ADVISOR_RECOMMENDATIONS

USER_ADVISOR_SQLA_REC_SUM

USER_ADVISOR_SQLA_WK_MAP

USER_ADVISOR_SQLA_WK_STMTS

USER_ADVISOR_SQLW_JOURNAL

USER_ADVISOR_SQLW_PARAMETERS

USER_ADVISOR_SQLW_STMTS

USER_ADVISOR_SQLW_SUM

USER_ADVISOR_SQLW_TABLES

USER_ADVISOR_SQLW_TEMPLATES

USER_ADVISOR_TASKS

USER_ADVISOR_TEMPLATES

USER_ATTRIBUTE_TRANSFORMATIONS

USER_AUDIT_OBJECT

USER_AUDIT_POLICIES

USER_AUDIT_POLICY_COLUMNS

USER_BASE_TABLE_MVIEWS

USER_CATALOG

USER_CHANGE_NOTIFICATION_REGS

USER_CLU_COLUMNS

USER_CLUSTER_HASH_EXPRESSIONS

USER_CONS_OBJ_COLUMNS

USER_ENCRYPTED_COLUMNS

USER_EPG_DAD_AUTHORIZATION

USER_ERRORS

USER_EVALUATION_CONTEXT_TABLES

USER_EVALUATION_CONTEXT_VARS

USER_EVALUATION_CONTEXTS

USER_EXTENTS

USER_EXTERNAL_LOCATIONS

USER_EXTERNAL_TABLES

USER_FILE_GROUP_EXPORT_INFO

USER_FILE_GROUP_FILES

USER_FILE_GROUP_TABLES

USER_FILE_GROUP_TABLESPACES

USER_FILE_GROUP_VERSIONS

USER_IND_SUBPARTITIONS

USER_INDEXES

USER_INDEXTYPE_ARRAYTYPES

USER_INDEXTYPE_COMMENTS

USER_INDEXTYPE_OPERATORS

USER_INDEXTYPES

USER_INTERNAL_TRIGGERS

USER_JAVA_ARGUMENTS

USER_JAVA_CLASSES

USER_JAVA_DERIVATIONS

USER_JOIN_IND_COLUMNS

USER_LIBRARIES

USER_LOB_PARTITIONS

USER_LOB_SUBPARTITIONS

USER_LOB_TEMPLATES

USER_LOBS

USER_LOG_GROUP_COLUMNS

USER_LOG_GROUPS

USER_METHOD_PARAMS

USER_METHOD_RESULTS

USER_MVIEW_AGGREGATES

USER_MVIEW_ANALYSIS

USER_MVIEW_COMMENTS

USER_MVIEW_DETAIL_RELATIONS

USER_MVIEW_JOINS

USER_MVIEW_KEYS

USER_MVIEW_LOGS

USER_MVIEW_REFRESH_TIMES

USER_MVIEWS

USER_NESTED_TABLE_COLS

USER_OPERATOR_COMMENTS

USER_OPERATORS

USER_OUTLINE_HINTS

USER_OUTLINES

USER_PART_COL_STATISTICS

USER_PART_HISTOGRAMS

USER_PART_INDEXES

USER_PART_KEY_COLUMNS

USER_PART_LOBS

USER_PART_TABLES

USER_PARTIAL_DROP_TABS

USER_PASSWORD_LIMITS

USER_PENDING_CONV_TABLES

USER_PLSQL_OBJECT_SETTINGS

USER_PUBLISHED_COLUMNS

USER_QUEUE_SCHEDULES

USER_QUEUE_SUBSCRIBERS

USER_REFRESH_CHILDREN

USER_REFS

USER_REGISTERED_MVIEWS

USER_REGISTRY

USER_RESOURCE_LIMITS

USER_RESUMABLE

USER_REWRITE_EQUIVALENCES

USER_ROLE_PRIVS

USER_RSRC_CONSUMER_GROUP_PRIVS

USER_RSRC_MANAGER_SYSTEM_PRIVS

USER_RULE_SET_RULES

USER_RULE_SETS

USER_RULES

USER_SCHEDULER_CHAIN_RULES

USER_SCHEDULER_CHAIN_STEPS

USER_SCHEDULER_CHAINS

USER_SCHEDULER_JOB_ARGS

USER_SCHEDULER_JOB_LOG

USER_SCHEDULER_JOB_RUN_DETAILS

USER_SCHEDULER_JOBS

USER_SCHEDULER_PROGRAM_ARGS

USER_SCHEDULER_PROGRAMS

USER_SCHEDULER_RUNNING_CHAINS

USER_SCHEDULER_RUNNING_JOBS

USER_SCHEDULER_SCHEDULES

USER_SEC_RELEVANT_COLS

USER_SQLJ_TYPE_METHODS

USER_SQLSET_REFERENCES

USER_SQLSET_STATEMENTS

USER_SQLTUNE_BINDS

USER_SQLTUNE_PLANS

USER_SQLTUNE_RATIONALE_PLAN

USER_SQLTUNE_STATISTICS

USER_STORED_SETTINGS

USER_SUBPART_COL_STATISTICS

USER_SUBPART_HISTOGRAMS

USER_SUBPART_KEY_COLUMNS

USER_SUBPARTITION_TEMPLATES

USER_SUBSCRIBED_COLUMNS

USER_SUBSCRIBED_TABLES

USER_SUBSCRIPTIONS

USER_SYNONYMS

USER_SYS_PRIVS

USER_TAB_COL_STATISTICS

USER_TAB_MODIFICATIONS

USER_TAB_STATS_HISTORY

USER_TAB_SUBPARTITIONS

USER_UPDATABLE_COLUMNS

USER_WARNING_SETTINGS

V$ACTIVE_SESS_POOL_MTH

V$ACTIVE_SESSION_HISTORY

V$ARCHIVE_DEST_STATUS

V$BACKUP_ARCHIVELOG_DETAILS

V$BACKUP_ARCHIVELOG_SUMMARY

V$BACKUP_ASYNC_IO

V$BACKUP_CONTROLFILE_DETAILS

V$BACKUP_CONTROLFILE_SUMMARY

V$BACKUP_COPY_DETAILS

V$BACKUP_COPY_SUMMARY

V$BACKUP_CORRUPTION

V$BACKUP_DATAFILE

V$BACKUP_DATAFILE_DETAILS

V$BACKUP_DATAFILE_SUMMARY

V$BACKUP_DEVICE

V$BACKUP_FILES

V$BACKUP_PIECE

V$BACKUP_PIECE_DETAILS

V$BACKUP_SPFILE_DETAILS

V$BACKUP_SPFILE_SUMMARY

V$BACKUP_SYNC_IO

V$BGPROCESS

V$BH

V$BLOCK_CHANGE_TRACKING

V$BLOCKING_QUIESCE

V$BUFFER_POOL

V$BUFFER_POOL_STATISTICS

V$BUFFERED_PUBLISHERS

V$BUFFERED_QUEUES

V$BUFFERED_SUBSCRIBERS

V$CLASS_CACHE_TRANSFER

V$CLIENT_STATS

V$CLUSTER_INTERCONNECTS

V$CONFIGURED_INTERCONNECTS

V$CONTEXT

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$CR_BLOCK_SERVER

V$CURRENT_BLOCK_SERVER

V$DATABASE

V$DATABASE_BLOCK_CORRUPTION

V$DATABASE_INCARNATION

V$DB_TRANSPORTABLE_PLATFORM

V$FAST_START_TRANSACTIONS

V$FILE_CACHE_TRANSFER

V$FIXED_VIEW_DEFINITION

V$FLASH_RECOVERY_AREA_USAGE

V$FLASHBACK_DATABASE_LOG

V$FLASHBACK_DATABASE_STAT

V$GC_ELEMENT

V$GC_ELEMENTS_WITH_COLLISIONS

V$GCSHVMASTER_INFO

V$GCSPFMASTER_INFO

V$GES_BLOCKING_ENQUEUE

V$GLOBAL_BLOCKED_LOCKS

V$INDEXED_FIXED_COLUMN

V$INSTANCE

V$INSTANCE_CACHE_TRANSFER

V$INSTANCE_RECOVERY

V$JAVA_LIBRARY_CACHE_MEMORY

V$LIBRARY_CACHE_MEMORY

V$LOGMNR_DICTIONARY_LOAD

V$LOGSTDBY_TRANSACTION

V$MUTEX_SLEEP_HISTORY

V$OBSOLETE_BACKUP_FILES

V$PARALLEL_DEGREE_LIMIT_MTH

V$PARAMETER

V$PARAMETER_VALID_VALUES

V$PARAMETER2

V$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM

V$PROPAGATION_RECEIVER

V$PROPAGATION_SENDER

V$PROXY_ARCHIVEDLOG

V$PROXY_ARCHIVELOG_DETAILS

V$PROXY_ARCHIVELOG_SUMMARY

V$RECOVERY_FILE_STATUS

V$RMAN_BACKUP_JOB_DETAILS

V$RMAN_BACKUP_SUBJOB_DETAILS

V$RMAN_BACKUP_TYPE

V$RMAN_CONFIGURATION

V$RMAN_ENCRYPTION_ALGORITHMS

V$ROWCACHE_SUBORDINATE

V$RSRC_CONS_GROUP_HISTORY

V$RSRC_CONSUMER_GROUP

V$RSRC_CONSUMER_GROUP_CPU_MTH

V$RULE_SET_AGGREGATE_STATS

V$SCHEDULER_RUNNING_JOBS

V$SERVICEMETRIC_HISTORY

V$SESSION_CONNECT_INFO

V$SESSION_CURSOR_CACHE

V$SESSION_EVENT

V$SESSION_LONGOPS

V$SESSION_OBJECT_CACHE

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION_WAIT_HISTORY

V$SESSMETRIC

V$SESSTAT

V$SGA

V$SGA_CURRENT_RESIZE_OPS

V$SGA_DYNAMIC_COMPONENTS

V$SGA_DYNAMIC_FREE_MEMORY

V$SHARED_POOL_RESERVED

V$SHARED_SERVER

V$SHARED_SERVER_MONITOR

V$SQL_PLAN_STATISTICS

V$SQL_PLAN_STATISTICS_ALL

V$SQL_WORKAREA_ACTIVE

V$SQL_WORKAREA_HISTOGRAM

V$SQLTEXT_WITH_NEWLINES

V$STANDBY_LOG

V$STATISTICS_LEVEL

V$STATNAME

V$STREAMS_APPLY_COORDINATOR

V$STREAMS_APPLY_READER

V$STREAMS_APPLY_SERVER

V$STREAMS_CAPTURE

V$STREAMS_POOL_ADVICE

V$STREAMS_TRANSACTION

V$SYSTEM_CURSOR_CACHE

V$TEMP_CACHE_TRANSFER

V$TRANSACTION_ENQUEUE

V$TRANSPORTABLE_PLATFORM

V$TYPE_SIZE

V$UNDOSTAT

V$UNUSABLE_BACKUPFILE_DETAILS

V$VERSION

V$VPD_POLICY

V$WAITCLASSMETRIC

V$WAITCLASSMETRIC_HISTORY

その他のデータ・ディクショナリ構造体の作成

NOスクリプト

アップグレードおよびダウングレード・スクリプト

alter system set dispatcher

batched allocate scn lock request

BFILE check if exists

BFILE check if open

BFILE closure

BFILE get length

BFILE get name object

BFILE get path object

BFILE internal seek

BFILE open

BFILE read

broadcast mesg queue transition

broadcast mesg recovery queue transition

cleanup of aborted processes

control file parallel write

control file sequential read

control file single write

cursor: mutex S

cursor: mutex X

cursor: pin S

cursor: pin S wait on X

cursor: pin X

Data Guard: process clean up

Data Guard: process exit

Data Guard Broker: single instance

db file parallel read

db file parallel write

db file scattered read

db file sequential read

duplicate cluster key

enq: OW - initialization

enq: OW - termination

enqueue

flashback buf free by RVWR

free buffer waits

free global transaction table entry

free process state object

GCS lock open S

GCS lock open X

gcs remastering wait for drop pkey

global cache busy

global cache lock cleanup

global cache freelist

inactive session

inactive transaction branch

index block split

instance state change

io done

kcl bg acks

ksxr wait for mount shared

ktm: instance recovery

latch activity

latch free

library cache load lock

library cache lock

library cache pin

library cache shutdown

LMON global data update

lock manager wait for remote message

log buffer space

log file parallel write

log file sequential read

log file single write

log file switch (archiving needed)

log file switch (checkpoint incomplete)

log file switch (clearing log file)

log file switch (private strand flush incomplete)

log file switch completion

log file sync

log switch/archive

optimizer stats update retry

pending global transaction(s)

prewarm transfer retry

prior process spawner to be cleaned up

Streams AQ: waiting for messages in the queue

rdbms ipc message

rdbms ipc message block

rdbms ipc reply

read by other session

resmgr: become active

resmgr: cpu quantum

rolling migration: cluster quisce

SGA: allocation forcing component growth

SGA: MMAN sleep for component shrink

SGA: sga_target resize

single-task message

smon timer

SQL*Net break/reset to client

SQL*Net break/reset to dblink

SQL*Net message from client

SQL*Net message from dblink

SQL*Net message to client

SQL*Net message to dblink

SQL*Net more data from client

SQL*Net more data from dblink

SQL*Net more data to client

SQL*Net more data to dblink

switch logfile command

timer in sksawat

transaction

unbound tx

undo_retention publish retry

undo segment extension

undo segment recovery

undo segment tx slot

virtual circuit status

WMON goes to sleep

write complete waits

writes stopped by instance recovery or database suspension

統計情報の表示

統計情報の説明

目次

タイトルおよび著作権情報

はじめに

Oracle Databaseリファレンスの新機能

第I部初期化パラメータ

1 初期化パラメータ

第II部静的データ・ディクショナリ・ビュー

2 静的データ・ディクショナリ・ビュー: ALL_ALL_TABLES～ALL_MVIEWS

3 静的データ・ディクショナリ・ビュー: ALL_NESTED_TABLE_COLS～DATABASE_PROPERTIES

4 静的データ・ディクショナリ・ビュー: DBA_2PC_NEIGHBORS～
DBA_MVIEWS

5 静的データ・ディクショナリ・ビュー: DBA_NESTED_TABLE_COLS～
USER_XML_VIEWS

第III部動的パフォーマンス・ビュー

6 動的パフォーマンス（V$）・ビュー

7 動的パフォーマンス（V$）・ビュー: V$NLS_PARAMETERS～
V$XML_AUDIT_TRAIL

A データベースの制限事項

B SQLスクリプト

C Oracle待機イベント

D Oracleエンキュー名

E 統計情報の説明

索引