What's New in Oracle Database Reference?

This section describes new features of Oracle Database 11g release 1 (11.1) and release 2 (11.2) and provides pointers to additional information. For information on features that were new in earlier releases of the Oracle Database, refer to the documentation for the earlier release.

The following sections describe the new features in Oracle Database Reference:

Oracle Database 11g Release 2 (11.2.0.4) New Features
Oracle Database 11g Release 2 (11.2.0.3) New Features
Oracle Database 11g Release 2 (11.2.0.2) New Features
Oracle Database 11g Release 2 (11.2.0.1) New Features
Oracle Database 11g Release 1 (11.1) New Features

Oracle Database 11g Release 2 (11.2.0.4) New Features

The following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.4):

DNFS_BATCH_SIZE
ENABLE_GOLDENGATE_REPLICATION

See Also:

Part I, "Initialization Parameters" for more information about this initialization parameter

The following static data dictionary views are new to Oracle Database 11g Release 2 (11.2.0.4):

ALL_ Views	DBA_ Views	USER_ Views
`ALL_GG_INBOUND_PROGRESS`^Foot 1
`ALL_GOLDENGATE_INBOUND`^Footref 1
	`DBA_GG_INBOUND_PROGRESS`^Footref 1
	`DBA_GOLDENGATE_INBOUND`^Footref 1
	`DBA_GOLDENGATE_SUPPORT_MODE`^Footref 1
	`DBA_WORKLOAD_REPLAY_SCHEDULES`^Footref 1
	`DBA_WORKLOAD_SCHEDULE_CAPTURES`^Footref 1
	`DBA_WORKLOAD_SCHEDULE_ORDERING`^Footref 1
	`REDACTION_COLUMNS`^Footref 1
	`REDACTION_POLICIES`^Footref 1
	`REDACTION_VALUES_FOR_TYPE_FULL`^Footref 1

^Footnote 1This view was backported to Oracle Database 11g Release 2 (11.2.0.4) from Oracle Database Release 12c Release 1 (12.1)

See Also:

Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to Oracle Database 11g Release 2 (11.2.0.4):

GV$ Views	V$ Views
`GV$CLONEDFILE`^Foot 1	`V$CLONEDFILE`^Footref 1
`GV$DEAD_CLEANUP`^Footref 1	`V$DEAD_CLEANUP`^Footref 1
`GV$FS_OBSERVER_HISTOGRAM`	`V$FS_OBSERVER_HISTOGRAM`
`GV$GG_APPLY_COORDINATOR`^Footref 1	`V$GG_APPLY_COORDINATOR`^Footref 1
`GV$GG_APPLY_READER`^Footref 1	`V$GG_APPLY_READER`^Footref 1
`GV$GG_APPLY_RECEIVER`^Footref 1	`V$GG_APPLY_RECEIVER`^Footref 1
`GV$GG_APPLY_SERVER`^Footref 1	`V$GG_APPLY_SERVER`^Footref 1
`GV$RO_USER_ACCOUNT`^Footref 1	`V$RO_USER_ACCOUNT`^Footref 1
`GV$XSTREAM_APPLY_COORDINATOR`^Footref 1	`V$XSTREAM_APPLY_COORDINATOR`^Footref 1
`GV$XSTREAM_APPLY_READER`^Footref 1	`V$XSTREAM_APPLY_READER`^Footref 1
`GV$XSTREAM_APPLY_RECEIVER`^Footref 1	`V$XSTREAM_APPLY_RECEIVER`^Footref 1
`GV$XSTREAM_APPLY_SERVER`^Footref 1	`V$XSTREAM_APPLY_SERVER`^Footref 1

^Footnote 1This view was backported to Oracle Database 11g Release 2 (11.2.0.4) from Oracle Database Release 12c Release 1 (12.1)

See Also:

Part III, "Dynamic Performance Views" for more information about these dynamic performance views

Oracle Database 11g Release 2 (11.2.0.3) New Features

The following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.3):

AWR_SNAPSHOT_TIME_OFFSET
CLONEDB

See Also:

Part I, "Initialization Parameters" for more information about these initialization parameters

Oracle Database 11g Release 2 (11.2.0.2) New Features

The following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.2):

CURSOR_BIND_CAPTURE_DESTINATION
DB_FLASH_CACHE_FILE
DB_FLASH_CACHE_SIZE
DB_UNRECOVERABLE_SCN_TRACKING
USE_LARGE_PAGES

See Also:

Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to Oracle Database 11g Release 2 (11.2.0.2):

ALL_ Views	DBA_ Views	USER_ Views
`ALL_APPLY_ERROR_MESSAGES`	`DBA_APPLY_ERROR_MESSAGES`
	`DBA_HIST_PERSISTENT_QMN_CACHE`
	`DBA_XSTREAM_ADMINISTRATOR`
	`DBA_XSTREAM_OUT_SUPPORT_MODE`

See Also:

Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to Oracle Database 11g Release 2 (11.2.0.2):

GV$ Views	V$ Views
`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`

See Also:

Part III, "Dynamic Performance Views" for more information about these dynamic performance views

Oracle Database 11g Release 2 (11.2.0.1) New Features

The following initialization parameters are new to Oracle Database 11g Release 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

See Also:

Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to Oracle Database 11g Release 2 (11.2.0.1):

ALL_ Views	DBA_ Views	USER_ Views
`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`

The following additional static data dictionary views are new to Oracle Database 11g Release 2 (11.2.0.1):

DBFS_CONTENT
DBFS_CONTENT_PROPERTIES

See Also:

Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to Oracle Database 11g Release 2 (11.2.0.1):

GV$ Views	V$ Views
`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`

See Also:

Part III, "Dynamic Performance Views" for more information about these dynamic performance views

Oracle Database 11g Release 1 (11.1) New Features

The following initialization parameters are new to Oracle Database 11g Release 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

See Also:

Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to Oracle Database 11g Release 1 (11.1)::

ALL_ Views	DBA_ Views	USER_ Views
	`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`

See Also:

Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to Oracle Database 11g Release 1 (11.1)::

GV$ Views	V$ Views
`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`

See Also:

Part III, "Dynamic Performance Views" for more information about these dynamic performance views