ここでは、Oracle Database 11gリリース1(11.1)とリリース2(11.2)の新機能について説明し、追加情報の参照先を示します。以前のリリースのOracle Databaseにおける新機能の詳細は、該当するリリースのマニュアルを参照してください。
次の項で、Oracle Databaseリファレンスでの新機能について説明します。
Oracle Database 11gリリース2(11.2.0.4)では、次の初期化パラメータが追加されています。
DNFS_BATCH_SIZE
ENABLE_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_OFFSET
CLONEDB
Oracle Database 11gリリース2(11.2.0.2)では、次の初期化パラメータが追加されています。
CURSOR_BIND_CAPTURE_DESTINATION
DB_FLASH_CACHE_FILE
DB_FLASH_CACHE_SIZE
DB_UNRECOVERABLE_SCN_TRACKING
USE_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_CREATION
DST_UPGRADE_INSERT_CONV
LISTENER_NETWORKS
PARALLEL_DEGREE_LIMIT
PARALLEL_DEGREE_POLICY
PARALLEL_FORCE_LOCAL
PARALLEL_MIN_TIME_THRESHOLD
PARALLEL_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_CONTENT
DBFS_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_GROUPS
CLIENT_RESULT_CACHE_LAG
CLIENT_RESULT_CACHE_SIZE
COMMIT_LOGGING
COMMIT_WAIT
CONTROL_MANAGEMENT_PACK_ACCESS
DB_LOST_WRITE_PROTECT
DB_SECUREFILE
DB_ULTRA_SAFE
DDL_LOCK_TIMEOUT
DIAGNOSTIC_DEST
GLOBAL_TXN_PROCESSES
JAVA_JIT_ENABLED
LDAP_DIRECTORY_SYSAUTH
MEMORY_MAX_TARGET
MEMORY_TARGET
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
OPTIMIZER_USE_INVISIBLE_INDEXES
OPTIMIZER_USE_PENDING_STATISTICS
OPTIMIZER_USE_SQL_PLAN_BASELINES
PARALLEL_IO_CAP_ENABLED
PLSCOPE_SETTINGS
REDO_TRANSPORT_USER
RESOURCE_MANAGER_CPU_ALLOCATION
RESULT_CACHE_MAX_RESULT
RESULT_CACHE_MAX_SIZE
RESULT_CACHE_MODE
RESULT_CACHE_REMOTE_EXPIRATION
SEC_CASE_SENSITIVE_LOGON
SEC_MAX_FAILED_LOGIN_ATTEMPTS
SEC_PROTOCOL_ERROR_FURTHER_ACTION
SEC_PROTOCOL_ERROR_TRACE_ACTION
SEC_RETURN_SERVER_RELEASE_BANNER
XML_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 |