ここでは、Oracle Database 11gリリース1(11.1)とリリース2(11.2)の新機能について説明し、追加情報の参照先を示します。以前のリリースのOracle Databaseにおける新機能の詳細は、該当するリリースのマニュアルを参照してください。
次の項で、Oracle Databaseリファレンスでの新機能について説明します。
Oracle Database 11gリリース2(11.2.0.4)では、次の初期化パラメータが追加されています。
DNFS_BATCH_SIZEENABLE_GOLDENGATE_REPLICATION
Oracle Database 11gリリース2(11.2.0.4)では、次の静的データ・ディクショナリ・ビューが追加されています。
| ALL_ビュー | DBA_ビュー | USER_ビュー | 
|---|---|---|
| ALL_GG_INBOUND_PROGRESS脚注 1 | ||
| ALL_GOLDENGATE_INBOUND脚注 1 | ||
| DBA_GG_INBOUND_PROGRESS脚注 1 | ||
| DBA_GOLDENGATE_INBOUND脚注 1 | ||
| DBA_GOLDENGATE_SUPPORT_MODE脚注 1 | ||
| DBA_WORKLOAD_REPLAY_SCHEDULES脚注 1 | ||
| DBA_WORKLOAD_SCHEDULE_CAPTURES脚注 1 | ||
| DBA_WORKLOAD_SCHEDULE_ORDERING脚注 1 | ||
| REDACTION_COLUMNS脚注 1 | ||
| REDACTION_POLICIES脚注 1 | ||
| REDACTION_VALUES_FOR_TYPE_FULL脚注 1 | 
脚注 1 このビューは、Oracle Databaseリリース12cリリース1 (12.1)からOracle Database 11gリリース2 (11.2.0.4)にバックポートされました。
Oracle Database 11gリリース2(11.2.0.4)では、次の動的パフォーマンス・ビューが追加されています。
| GV$ビュー | V$ビュー | 
|---|---|
| GV$CLONEDFILE脚注 1 | V$CLONEDFILE脚注 1 | 
| GV$DEAD_CLEANUP脚注 1 | V$DEAD_CLEANUP脚注 1 | 
| GV$FS_OBSERVER_HISTOGRAM | V$FS_OBSERVER_HISTOGRAM | 
| GV$GG_APPLY_COORDINATOR脚注 1 | V$GG_APPLY_COORDINATOR脚注 1 | 
| GV$GG_APPLY_READER脚注 1 | V$GG_APPLY_READER脚注 1 | 
| GV$GG_APPLY_RECEIVER脚注 1 | V$GG_APPLY_RECEIVER脚注 1 | 
| GV$GG_APPLY_SERVER脚注 1 | V$GG_APPLY_SERVER脚注 1 | 
| GV$RO_USER_ACCOUNT脚注 1 | V$RO_USER_ACCOUNT脚注 1 | 
| GV$XSTREAM_APPLY_COORDINATOR脚注 1 | V$XSTREAM_APPLY_COORDINATOR脚注 1 | 
| GV$XSTREAM_APPLY_READER脚注 1 | V$XSTREAM_APPLY_READER脚注 1 | 
| GV$XSTREAM_APPLY_RECEIVER脚注 1 | V$XSTREAM_APPLY_RECEIVER脚注 1 | 
| GV$XSTREAM_APPLY_SERVER脚注 1 | V$XSTREAM_APPLY_SERVER脚注 1 | 
脚注 1 このビューは、Oracle Databaseリリース12cリリース1 (12.1)からOracle Database 11gリリース2 (11.2.0.4)にバックポートされました。
Oracle Database 11gリリース2(11.2.0.3)では、次の初期化パラメータが追加されています。
AWR_SNAPSHOT_TIME_OFFSETCLONEDB
Oracle Database 11gリリース2(11.2.0.2)では、次の初期化パラメータが追加されています。
CURSOR_BIND_CAPTURE_DESTINATIONDB_FLASH_CACHE_FILEDB_FLASH_CACHE_SIZEDB_UNRECOVERABLE_SCN_TRACKINGUSE_LARGE_PAGES
Oracle Database 11gリリース2(11.2.0.2)では、次の静的データ・ディクショナリ・ビューが追加されています。
| ALL_ビュー | DBA_ビュー | USER_ビュー | 
|---|---|---|
| ALL_APPLY_ERROR_MESSAGES | DBA_APPLY_ERROR_MESSAGES | |
| DBA_HIST_PERSISTENT_QMN_CACHE | ||
| DBA_XSTREAM_ADMINISTRATOR | ||
| DBA_XSTREAM_OUT_SUPPORT_MODE | 
Oracle Database 11gリリース2(11.2.0.2)では、次の動的パフォーマンス・ビューが追加されています。
| GV$ビュー | V$ビュー | 
|---|---|
| GV$ASM_ACFS_ENCRYPTION_INFO | V$ASM_ACFS_ENCRYPTION_INFO | 
| GV$ASM_ACFS_SECURITY_INFO | V$ASM_ACFS_SECURITY_INFO | 
| GV$XSTREAM_CAPTURE | V$XSTREAM_CAPTURE | 
| GV$XSTREAM_MESSAGE_TRACKING | V$XSTREAM_MESSAGE_TRACKING | 
| GV$XSTREAM_OUTBOUND_SERVER | V$XSTREAM_OUTBOUND_SERVER | 
| GV$XSTREAM_TRANSACTION | V$XSTREAM_TRANSACTION | 
Oracle Database 11gリリース2(11.2.0.1)では、次の初期化パラメータが追加されています。
DEFERRED_SEGMENT_CREATIONDST_UPGRADE_INSERT_CONVLISTENER_NETWORKSPARALLEL_DEGREE_LIMITPARALLEL_DEGREE_POLICYPARALLEL_FORCE_LOCALPARALLEL_MIN_TIME_THRESHOLDPARALLEL_SERVERS_TARGET
Oracle Database 11gリリース2(11.2.0.1)では、次の静的データ・ディクショナリ・ビューが追加されています。
| ALL_ビュー | DBA_ビュー | USER_ビュー | 
|---|---|---|
| ALL_APPLY_CHANGE_HANDLERS | DBA_APPLY_CHANGE_HANDLERS | |
| DBA_HIST_DISPATCHER | ||
| DBA_HIST_DYN_REMASTER_STATS | ||
| DBA_HIST_IOSTAT_DETAIL | ||
| DBA_HIST_PLAN_OPERATION_NAME | ||
| DBA_HIST_PLAN_OPTION_NAME | ||
| DBA_HIST_SHARED_SERVER_SUMMARY | ||
| DBA_HIST_SQLCOMMAND_NAME | ||
| DBA_HIST_TOPLEVELCALL_NAME | ||
| DBA_PARALLEL_EXECUTE_CHUNKS | USER_PARALLEL_EXECUTE_CHUNKS | |
| DBA_PARALLEL_EXECUTE_TASKS | USER_PARALLEL_EXECUTE_TASKS | |
| ALL_QUEUE_SCHEDULES | ||
| DBA_RECOVERABLE_SCRIPT_HIST | ||
| ALL_SCHEDULER_DB_DESTS | DBA_SCHEDULER_DB_DESTS | USER_SCHEDULER_DB_DESTS | 
| ALL_SCHEDULER_DESTS | DBA_SCHEDULER_DESTS | USER_SCHEDULER_DESTS | 
| ALL_SCHEDULER_EXTERNAL_DESTS | DBA_SCHEDULER_EXTERNAL_DESTS | |
| ALL_SCHEDULER_FILE_WATCHERS | DBA_SCHEDULER_FILE_WATCHERS | USER_SCHEDULER_FILE_WATCHERS | 
| ALL_SCHEDULER_GROUP_MEMBERS | DBA_SCHEDULER_GROUP_MEMBERS | USER_SCHEDULER_GROUP_MEMBERS | 
| ALL_SCHEDULER_GROUPS | DBA_SCHEDULER_GROUPS | USER_SCHEDULER_GROUPS | 
| ALL_SCHEDULER_JOB_DESTS | DBA_SCHEDULER_JOB_DESTS | USER_SCHEDULER_JOB_DESTS | 
| ALL_SCHEDULER_NOTIFICATIONS | DBA_SCHEDULER_NOTIFICATIONS | USER_SCHEDULER_NOTIFICATIONS | 
| DBA_STREAMS_KEEP_COLUMNS | ||
| DBA_STREAMS_SPLIT_MERGE | ||
| DBA_STREAMS_SPLIT_MERGE_HIST | ||
| ALL_STREAMS_STMT_HANDLERS | DBA_STREAMS_STMT_HANDLERS | |
| ALL_STREAMS_STMTS | DBA_STREAMS_STMTS | |
| ALL_TSTZ_TAB_COLS | DBA_TSTZ_TAB_COLS | USER_TSTZ_TAB_COLS | 
| ALL_TSTZ_TABLES | DBA_TSTZ_TABLES | USER_TSTZ_TABLES | 
| DBA_WALLET_ACLS | 
Oracle Database 11gリリース2(11.2.0.1)では、他に次の静的データ・ディクショナリ・ビューも追加されています。
DBFS_CONTENTDBFS_CONTENT_PROPERTIES
Oracle Database 11gリリース2(11.2.0.1)では、次の動的パフォーマンス・ビューが追加されています。
| GV$ビュー | V$ビュー | 
|---|---|
| GV$ASM_ACFSSNAPSHOTS | V$ASM_ACFSSNAPSHOTS | 
| GV$ASM_ACFSVOLUMES | V$ASM_ACFSVOLUMES | 
| GV$ASM_FILESYSTEM | V$ASM_FILESYSTEM | 
| GV$ASM_USER | V$ASM_USER | 
| GV$ASM_USERGROUP | V$ASM_USERGROUP | 
| GV$ASM_USERGROUP_MEMBER | V$ASM_USERGROUP_MEMBER | 
| GV$ASM_VOLUME | V$ASM_VOLUME | 
| GV$ASM_VOLUME_STAT | V$ASM_VOLUME_STAT | 
| GV$CPOOL_CONN_INFO | V$CPOOL_CONN_INFO | 
| GV$DATAGUARD_STATS | |
| GV$EMON | V$EMON | 
| GV$IOSTAT_FUNCTION_DETAIL | V$IOSTAT_FUNCTION_DETAIL | 
| GV$LIBCACHE_LOCKS | V$LIBCACHE_LOCKS | 
| GV$PERSISTENT_QMN_CACHE | V$PERSISTENT_QMN_CACHE | 
| GV$QMON_COORDINATOR_STATS | V$QMON_COORDINATOR_STATS | 
| GV$QMON_SERVER_STATS | V$QMON_SERVER_STATS | 
| GV$QMON_TASK_STATS | V$QMON_TASK_STATS | 
| GV$QMON_TASKS | V$QMON_TASKS | 
| GV$SQLCOMMAND | V$SQLCOMMAND | 
| V$STANDBY_EVENT_HISTOGRAM | |
| GV$STREAMS_POOL_STATISTICS | V$STREAMS_POOL_STATISTICS | 
| GV$TOPLEVELCALL | V$TOPLEVELCALL | 
Oracle Database 11gリリース1(11.1)では、次の初期化パラメータが追加されています。
ASM_PREFERRED_READ_FAILURE_GROUPSCLIENT_RESULT_CACHE_LAGCLIENT_RESULT_CACHE_SIZECOMMIT_LOGGINGCOMMIT_WAITCONTROL_MANAGEMENT_PACK_ACCESSDB_LOST_WRITE_PROTECTDB_SECUREFILEDB_ULTRA_SAFEDDL_LOCK_TIMEOUTDIAGNOSTIC_DESTGLOBAL_TXN_PROCESSESJAVA_JIT_ENABLEDLDAP_DIRECTORY_SYSAUTHMEMORY_MAX_TARGETMEMORY_TARGETOPTIMIZER_CAPTURE_SQL_PLAN_BASELINESOPTIMIZER_USE_INVISIBLE_INDEXESOPTIMIZER_USE_PENDING_STATISTICSOPTIMIZER_USE_SQL_PLAN_BASELINESPARALLEL_IO_CAP_ENABLEDPLSCOPE_SETTINGSREDO_TRANSPORT_USERRESOURCE_MANAGER_CPU_ALLOCATIONRESULT_CACHE_MAX_RESULTRESULT_CACHE_MAX_SIZERESULT_CACHE_MODERESULT_CACHE_REMOTE_EXPIRATIONSEC_CASE_SENSITIVE_LOGONSEC_MAX_FAILED_LOGIN_ATTEMPTSSEC_PROTOCOL_ERROR_FURTHER_ACTIONSEC_PROTOCOL_ERROR_TRACE_ACTIONSEC_RETURN_SERVER_RELEASE_BANNERXML_DB_EVENTS
Oracle Database 11gリリース1(11.1)では、次の静的データ・ディクショナリ・ビューが追加されています。
| ALL_ビュー | DBA_ビュー | USER_ビュー | 
|---|---|---|
| DBA_ADDM_FDG_BREAKDOWN | USER_ADDM_FDG_BREAKDOWN | |
| DBA_ADDM_FINDINGS | USER_ADDM_FINDINGS | |
| DBA_ADDM_INSTANCES | USER_ADDM_INSTANCES | |
| DBA_ADDM_SYSTEM_DIRECTIVES | ||
| DBA_ADDM_TASK_DIRECTIVES | USER_ADDM_TASK_DIRECTIVES | |
| DBA_ADDM_TASKS | USER_ADDM_TASKS | |
| DBA_ADVISOR_DIR_DEFINITIONS | ||
| DBA_ADVISOR_DIR_INSTANCES | ||
| DBA_ADVISOR_DIR_TASK_INST | USER_ADVISOR_DIR_TASK_INST | |
| DBA_ADVISOR_EXEC_PARAMETERS | USER_ADVISOR_EXEC_PARAMETERS | |
| DBA_ADVISOR_EXECUTION_TYPES | ||
| DBA_ADVISOR_EXECUTIONS | USER_ADVISOR_EXECUTIONS | |
| DBA_ADVISOR_FDG_BREAKDOWN | USER_ADVISOR_FDG_BREAKDOWN | |
| DBA_ADVISOR_FINDING_NAMES | ||
| DBA_ADVISOR_SQLA_COLVOL | USER_ADVISOR_SQLA_COLVOL | |
| DBA_ADVISOR_SQLA_TABLES | USER_ADVISOR_SQLA_TABLES | |
| DBA_ADVISOR_SQLA_TABVOL | USER_ADVISOR_SQLA_TABVOL | |
| DBA_ADVISOR_SQLA_WK_SUM | USER_ADVISOR_SQLA_WK_SUM | |
| DBA_ADVISOR_SQLPLANS | USER_ADVISOR_SQLPLANS | |
| DBA_ADVISOR_SQLSTATS | USER_ADVISOR_SQLSTATS | |
| DBA_ARGUMENTS | ||
| ALL_ASSEMBLIES | DBA_ASSEMBLIES | USER_ASSEMBLIES | 
| DBA_AUTOTASK_CLIENT | ||
| DBA_AUTOTASK_CLIENT_HISTORY | ||
| DBA_AUTOTASK_CLIENT_JOB | ||
| DBA_AUTOTASK_OPERATION | ||
| DBA_AUTOTASK_SCHEDULE | ||
| DBA_AUTOTASK_TASK | ||
| DBA_AUTOTASK_WINDOW_CLIENTS | ||
| DBA_AUTOTASK_WINDOW_HISTORY | ||
| ALL_CHANGE_PROPAGATION_SETS | ||
| ALL_CHANGE_PROPAGATIONS | ||
| ALL_CHANGE_SETS | ||
| ALL_CHANGE_SOURCES | ||
| ALL_CHANGE_TABLES | ||
| ALL_COL_PENDING_STATS | DBA_COL_PENDING_STATS | USER_COL_PENDING_STATS | 
| DBA_COMPARISON | USER_COMPARISON | |
| DBA_COMPARISON_COLUMNS | USER_COMPARISON_COLUMNS | |
| DBA_COMPARISON_ROW_DIF | USER_COMPARISON_ROW_DIF | |
| DBA_COMPARISON_SCAN | USER_COMPARISON_SCAN | |
| DBA_COMPARISON_SCAN_SUMMARY | USER_COMPARISON_SCAN_SUMMARY | |
| DBA_COMPARISON_SCAN_VALUES | USER_COMPARISON_SCAN_VALUES | |
| DBA_CPOOL_INFO | ||
| DBA_CQ_NOTIFICATION_QUERIES | USER_CQ_NOTIFICATION_QUERIES | |
| ALL_CUBE_ATTR_VISIBILITY | DBA_CUBE_ATTR_VISIBILITY | USER_CUBE_ATTR_VISIBILITY | 
| ALL_CUBE_ATTRIBUTES | DBA_CUBE_ATTRIBUTES | USER_CUBE_ATTRIBUTES | 
| ALL_CUBE_BUILD_PROCESSES | DBA_CUBE_BUILD_PROCESSES | USER_CUBE_BUILD_PROCESSES | 
| ALL_CUBE_CALCULATED_MEMBERS | DBA_CUBE_CALCULATED_MEMBERS | USER_CUBE_CALCULATED_MEMBERS | 
| ALL_CUBE_DIM_LEVELS | DBA_CUBE_DIM_LEVELS | USER_CUBE_DIM_LEVELS | 
| ALL_CUBE_DIM_MODELS | DBA_CUBE_DIM_MODELS | USER_CUBE_DIM_MODELS | 
| ALL_CUBE_DIM_VIEW_COLUMNS | DBA_CUBE_DIM_VIEW_COLUMNS | USER_CUBE_DIM_VIEW_COLUMNS | 
| ALL_CUBE_DIM_VIEWS | DBA_CUBE_DIM_VIEWS | USER_CUBE_DIM_VIEWS | 
| ALL_CUBE_DIMENSIONALITY | DBA_CUBE_DIMENSIONALITY | USER_CUBE_DIMENSIONALITY | 
| ALL_CUBE_DIMENSIONS | DBA_CUBE_DIMENSIONS | USER_CUBE_DIMENSIONS | 
| ALL_CUBE_HIER_LEVELS | DBA_CUBE_HIER_LEVELS | USER_CUBE_HIER_LEVELS | 
| ALL_CUBE_HIER_VIEW_COLUMNS | DBA_CUBE_HIER_VIEW_COLUMNS | USER_CUBE_HIER_VIEW_COLUMNS | 
| ALL_CUBE_HIER_VIEWS | DBA_CUBE_HIER_VIEWS | USER_CUBE_HIER_VIEWS | 
| ALL_CUBE_HIERARCHIES | DBA_CUBE_HIERARCHIES | USER_CUBE_HIERARCHIES | 
| ALL_CUBE_MEASURES | DBA_CUBE_MEASURES | USER_CUBE_MEASURES | 
| ALL_CUBE_VIEW_COLUMNS | DBA_CUBE_VIEW_COLUMNS | USER_CUBE_VIEW_COLUMNS | 
| ALL_CUBE_VIEWS | DBA_CUBE_VIEWS | USER_CUBE_VIEWS | 
| ALL_CUBES | DBA_CUBES | USER_CUBES | 
| DBA_EPG_DAD_AUTHORIZATION | USER_EPG_DAD_AUTHORIZATION | |
| DBA_FLASHBACK_ARCHIVE | USER_FLASHBACK_ARCHIVE | |
| DBA_FLASHBACK_ARCHIVE_TABLES | USER_FLASHBACK_ARCHIVE_TABLES | |
| DBA_FLASHBACK_ARCHIVE_TS | ||
| DBA_FLASHBACK_TXN_REPORT | USER_FLASHBACK_TXN_REPORT | |
| DBA_FLASHBACK_TXN_STATE | USER_FLASHBACK_TXN_STATE | |
| DBA_HIST_BASELINE_DETAILS | ||
| DBA_HIST_BASELINE_METADATA | ||
| DBA_HIST_BASELINE_TEMPLATE | ||
| DBA_HIST_CLUSTER_INTERCON | ||
| DBA_HIST_COLORED_SQL | ||
| DBA_HIST_EVENT_HISTOGRAM | ||
| DBA_HIST_IC_CLIENT_STATS | ||
| DBA_HIST_IC_DEVICE_STATS | ||
| DBA_HIST_INTERCONNECT_PINGS | ||
| DBA_HIST_IOSTAT_FILETYPE | ||
| DBA_HIST_IOSTAT_FILETYPE_NAME | ||
| DBA_HIST_IOSTAT_FUNCTION | ||
| DBA_HIST_IOSTAT_FUNCTION_NAME | ||
| DBA_HIST_MEM_DYNAMIC_COMP | ||
| DBA_HIST_MEMORY_RESIZE_OPS | ||
| DBA_HIST_MEMORY_TARGET_ADVICE | ||
| DBA_HIST_MUTEX_SLEEP | ||
| DBA_HIST_PERSISTENT_QUEUES | ||
| DBA_HIST_PERSISTENT_SUBS | ||
| DBA_HIST_RSRC_CONSUMER_GROUP | ||
| DBA_HIST_RSRC_PLAN | ||
| ALL_IDENTIFIERS | DBA_IDENTIFIERS | USER_IDENTIFIERS | 
| ALL_IND_PENDING_STATS | DBA_IND_PENDING_STATS | USER_IND_PENDING_STATS | 
| DBA_INVALID_OBJECTS | ||
| ALL_JAVA_COMPILER_OPTIONS | DBA_JAVA_COMPILER_OPTIONS | USER_JAVA_COMPILER_OPTIONS | 
| DBA_LOGSTDBY_UNSUPPORTED_TABLE | ||
| ALL_MEASURE_FOLDER_CONTENTS | DBA_MEASURE_FOLDER_CONTENTS | USER_MEASURE_FOLDER_CONTENTS | 
| ALL_MEASURE_FOLDERS | DBA_MEASURE_FOLDERS | USER_MEASURE_FOLDERS | 
| ALL_MINING_MODEL_ATTRIBUTES | DBA_MINING_MODEL_ATTRIBUTES | USER_MINING_MODEL_ATTRIBUTES | 
| ALL_MINING_MODEL_SETTINGS | DBA_MINING_MODEL_SETTINGS | USER_MINING_MODEL_SETTINGS | 
| ALL_MINING_MODELS | DBA_MINING_MODELS | USER_MINING_MODELS | 
| ALL_MVIEW_DETAIL_PARTITION | DBA_MVIEW_DETAIL_PARTITION | USER_MVIEW_DETAIL_PARTITION | 
| ALL_MVIEW_DETAIL_SUBPARTITION | DBA_MVIEW_DETAIL_SUBPARTITION | USER_MVIEW_DETAIL_SUBPARTITION | 
| DBA_NETWORK_ACL_PRIVILEGES | USER_NETWORK_ACL_PRIVILEGES | |
| DBA_NETWORK_ACLS | ||
| DBA_OLDIMAGE_COLUMNS | USER_OLDIMAGE_COLUMNS | |
| DBA_REGISTRY_DATABASE | ||
| DBA_REGISTRY_DEPENDENCIES | ||
| DBA_REGISTRY_PROGRESS | ||
| DBA_RSRC_CAPABILITY | ||
| DBA_RSRC_CATEGORIES | ||
| DBA_RSRC_INSTANCE_CAPABILITY | ||
| DBA_RSRC_IO_CALIBRATE | ||
| DBA_RSRC_STORAGE_POOL_MAPPING | ||
| ALL_SCHEDULER_CREDENTIALS | DBA_SCHEDULER_CREDENTIALS | USER_SCHEDULER_CREDENTIALS | 
| DBA_SCHEDULER_JOB_ROLES | ||
| ALL_SCHEDULER_REMOTE_DATABASES | DBA_SCHEDULER_REMOTE_DATABASES | |
| ALL_SCHEDULER_REMOTE_JOBSTATE | DBA_SCHEDULER_REMOTE_JOBSTATE | USER_SCHEDULER_REMOTE_JOBSTATE | 
| DBA_SQL_MANAGEMENT_CONFIG | ||
| DBA_SQL_PATCHES | ||
| DBA_SQL_PLAN_BASELINES | ||
| ALL_STAT_EXTENSIONS | DBA_STAT_EXTENSIONS | USER_STAT_EXTENSIONS | 
| ALL_STREAMS_COLUMNS | DBA_STREAMS_COLUMNS | |
| DBA_STREAMS_TP_COMPONENT | ||
| DBA_STREAMS_TP_COMPONENT_LINK | ||
| DBA_STREAMS_TP_COMPONENT_STAT | ||
| DBA_STREAMS_TP_DATABASE | ||
| DBA_STREAMS_TP_PATH_BOTTLENECK | ||
| DBA_STREAMS_TP_PATH_STAT | ||
| DBA_SUBSCR_REGISTRATIONS | USER_SUBSCR_REGISTRATIONS | |
| ALL_SYNC_CAPTURE | DBA_SYNC_CAPTURE | |
| ALL_SYNC_CAPTURE_PREPARED_TABS | DBA_SYNC_CAPTURE_PREPARED_TABS | |
| ALL_SYNC_CAPTURE_TABLES | DBA_SYNC_CAPTURE_TABLES | |
| ALL_TAB_HISTGRM_PENDING_STATS | DBA_TAB_HISTGRM_PENDING_STATS | USER_TAB_HISTGRM_PENDING_STATS | 
| ALL_TAB_PENDING_STATS | DBA_TAB_PENDING_STATS | USER_TAB_PENDING_STATS | 
| ALL_TAB_STAT_PREFS | DBA_TAB_STAT_PREFS | USER_TAB_STAT_PREFS | 
| DBA_TEMP_FREE_SPACE | ||
| ALL_TRIGGER_ORDERING | DBA_TRIGGER_ORDERING | USER_TRIGGER_ORDERING | 
| DBA_USERS_WITH_DEFPWD | ||
| DBA_WORKLOAD_CAPTURES | ||
| DBA_WORKLOAD_CONNECTION_MAP | ||
| DBA_WORKLOAD_FILTERS | ||
| DBA_WORKLOAD_REPLAY_DIVERGENCE | ||
| DBA_WORKLOAD_REPLAYS | 
Oracle Database 11gリリース1(11.1)では、次の動的パフォーマンス・ビューが追加されています。
| GV$ビュー | V$ビュー | 
|---|---|
| GV$ASM_ATTRIBUTE | V$ASM_ATTRIBUTE | 
| GV$ASM_DISK_IOSTAT | V$ASM_DISK_IOSTAT | 
| GV$CALLTAG | V$CALLTAG | 
| GV$CORRUPT_XID_LIST | V$CORRUPT_XID_LIST | 
| GV$CPOOL_CC_INFO | V$CPOOL_CC_INFO | 
| GV$CPOOL_CC_STATS | V$CPOOL_CC_STATS | 
| GV$CPOOL_STATS | V$CPOOL_STATS | 
| GV$DETACHED_SESSION | V$DETACHED_SESSION | 
| GV$DIAG_INFO | V$DIAG_INFO | 
| GV$DNFS_CHANNELS | V$DNFS_CHANNELS | 
| GV$DNFS_FILES | V$DNFS_FILES | 
| GV$DNFS_SERVERS | V$DNFS_SERVERS | 
| GV$DNFS_STATS | V$DNFS_STATS | 
| GV$DYNAMIC_REMASTER_STATS | V$DYNAMIC_REMASTER_STATS | 
| GV$ENCRYPTED_TABLESPACES | V$ENCRYPTED_TABLESPACES | 
| GV$ENCRYPTION_WALLET | V$ENCRYPTION_WALLET | 
| V$FLASHBACK_TXN_GRAPH | |
| V$FLASHBACK_TXN_MODS | |
| GV$FOREIGN_ARCHIVED_LOG | V$FOREIGN_ARCHIVED_LOG | 
| GV$FS_FAILOVER_STATS | V$FS_FAILOVER_STATS | 
| GV$HM_CHECK | V$HM_CHECK | 
| GV$HM_CHECK_PARAM | V$HM_CHECK_PARAM | 
| GV$HM_FINDING | V$HM_FINDING | 
| GV$HM_INFO | V$HM_INFO | 
| GV$HM_RECOMMENDATION | V$HM_RECOMMENDATION | 
| GV$HM_RUN | V$HM_RUN | 
| GV$INCMETER_CONFIG | V$INCMETER_CONFIG | 
| GV$INCMETER_INFO | V$INCMETER_INFO | 
| GV$INCMETER_SUMMARY | V$INCMETER_SUMMARY | 
| GV$IOFUNCMETRIC | V$IOFUNCMETRIC | 
| GV$IOFUNCMETRIC_HISTORY | V$IOFUNCMETRIC_HISTORY | 
| GV$IOSTAT_CONSUMER_GROUP | V$IOSTAT_CONSUMER_GROUP | 
| GV$IOSTAT_FILE | V$IOSTAT_FILE | 
| GV$IOSTAT_FUNCTION | V$IOSTAT_FUNCTION | 
| GV$IOSTAT_NETWORK | V$IOSTAT_NETWORK | 
| GV$IO_CALIBRATION_STATUS | V$IO_CALIBRATION_STATUS | 
| GV$IR_FAILURE | V$IR_FAILURE | 
| GV$IR_FAILURE_SET | V$IR_FAILURE_SET | 
| GV$IR_MANUAL_CHECKLIST | V$IR_MANUAL_CHECKLIST | 
| GV$IR_REPAIR | V$IR_REPAIR | 
| GV$LOBSTAT | V$LOBSTAT | 
| GV$MEMORY_CURRENT_RESIZE_OPS | V$MEMORY_CURRENT_RESIZE_OPS | 
| GV$MEMORY_DYNAMIC_COMPONENTS | V$MEMORY_DYNAMIC_COMPONENTS | 
| GV$MEMORY_RESIZE_OPS | V$MEMORY_RESIZE_OPS | 
| GV$MEMORY_TARGET_ADVICE | V$MEMORY_TARGET_ADVICE | 
| GV$NFS_CLIENTS | V$NFS_CLIENTS | 
| GV$NFS_LOCKS | V$NFS_LOCKS | 
| GV$NFS_OPEN_FILES | V$NFS_OPEN_FILES | 
| V$OBJECT_PRIVILEGE | |
| GV$PERSISTENT_PUBLISHERS | V$PERSISTENT_PUBLISHERS | 
| GV$PERSISTENT_QUEUES | V$PERSISTENT_QUEUES | 
| GV$PERSISTENT_SUBSCRIBERS | V$PERSISTENT_SUBSCRIBERS | 
| GV$PROCESS_GROUP | V$PROCESS_GROUP | 
| GV$PX_INSTANCE_GROUP | V$PX_INSTANCE_GROUP | 
| GV$REDO_DEST_RESP_HISTOGRAM | V$REDO_DEST_RESP_HISTOGRAM | 
| GV$RESULT_CACHE_DEPENDENCY | V$RESULT_CACHE_DEPENDENCY | 
| GV$RESULT_CACHE_MEMORY | V$RESULT_CACHE_MEMORY | 
| GV$RESULT_CACHE_OBJECTS | V$RESULT_CACHE_OBJECTS | 
| GV$RESULT_CACHE_STATISTICS | V$RESULT_CACHE_STATISTICS | 
| GV$RMAN_COMPRESSION_ALGORITHM | V$RMAN_COMPRESSION_ALGORITHM | 
| V$RMAN_ENCRYPTION_ALGORITHMS | |
| GV$RSRCMGRMETRIC | V$RSRCMGRMETRIC | 
| GV$RSRCMGRMETRIC_HISTORY | V$RSRCMGRMETRIC_HISTORY | 
| GV$SECUREFILE_TIMER | V$SECUREFILE_TIMER | 
| V$SESSION_FIX_CONTROL | |
| GV$SQL_CS_HISTOGRAM | V$SQL_CS_HISTOGRAM | 
| GV$SQL_CS_SELECTIVITY | V$SQL_CS_SELECTIVITY | 
| GV$SQL_CS_STATISTICS | V$SQL_CS_STATISTICS | 
| GV$SQL_FEATURE | V$SQL_FEATURE | 
| GV$SQL_FEATURE_DEPENDENCY | V$SQL_FEATURE_DEPENDENCY | 
| GV$SQL_FEATURE_HIERARCHY | V$SQL_FEATURE_HIERARCHY | 
| GV$SQL_HINT | V$SQL_HINT | 
| GV$SQL_MONITOR | V$SQL_MONITOR | 
| GV$SQL_PLAN_MONITOR | V$SQL_PLAN_MONITOR | 
| GV$SQLFN_ARG_METADATA | V$SQLFN_ARG_METADATA | 
| GV$SQLFN_METADATA | V$SQLFN_METADATA | 
| GV$STREAMS_MESSAGE_TRACKING | V$STREAMS_MESSAGE_TRACKING | 
| GV$SUBSCR_REGISTRATION_STATS | V$SUBSCR_REGISTRATION_STATS | 
| V$SYSTEM_FIX_CONTROL | |
| V$WAIT_CHAINS | |
| GV$WORKLOAD_REPLAY_THREAD | V$WORKLOAD_REPLAY_THREAD |