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:
The following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.4):
DNFS_BATCH_SIZEENABLE_GOLDENGATE_REPLICATION
See Also:
Part I, "Initialization Parameters" for more information about this initialization parameterThe 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_PROGRESSFoot 1 |
||
ALL_GOLDENGATE_INBOUNDFootref 1 |
||
DBA_GG_INBOUND_PROGRESSFootref 1 |
||
DBA_GOLDENGATE_INBOUNDFootref 1 |
||
DBA_GOLDENGATE_SUPPORT_MODEFootref 1 |
||
DBA_WORKLOAD_REPLAY_SCHEDULESFootref 1 |
||
DBA_WORKLOAD_SCHEDULE_CAPTURESFootref 1 |
||
DBA_WORKLOAD_SCHEDULE_ORDERINGFootref 1 |
||
REDACTION_COLUMNSFootref 1 |
||
REDACTION_POLICIESFootref 1 |
||
REDACTION_VALUES_FOR_TYPE_FULLFootref 1 |
Footnote 1 This 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 I, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe following dynamic performance views are new to Oracle Database 11g Release 2 (11.2.0.4):
| GV$ Views | V$ Views |
|---|---|
GV$CLONEDFILEFoot 1 |
V$CLONEDFILEFootref 1 |
GV$DEAD_CLEANUPFootref 1 |
V$DEAD_CLEANUPFootref 1 |
GV$FS_OBSERVER_HISTOGRAM |
V$FS_OBSERVER_HISTOGRAM |
GV$GG_APPLY_COORDINATORFootref 1 |
V$GG_APPLY_COORDINATORFootref 1 |
GV$GG_APPLY_READERFootref 1 |
V$GG_APPLY_READERFootref 1 |
GV$GG_APPLY_RECEIVERFootref 1 |
V$GG_APPLY_RECEIVERFootref 1 |
GV$GG_APPLY_SERVERFootref 1 |
V$GG_APPLY_SERVERFootref 1 |
GV$RO_USER_ACCOUNTFootref 1 |
V$RO_USER_ACCOUNTFootref 1 |
GV$XSTREAM_APPLY_COORDINATORFootref 1 |
V$XSTREAM_APPLY_COORDINATORFootref 1 |
GV$XSTREAM_APPLY_READERFootref 1 |
V$XSTREAM_APPLY_READERFootref 1 |
GV$XSTREAM_APPLY_RECEIVERFootref 1 |
V$XSTREAM_APPLY_RECEIVERFootref 1 |
GV$XSTREAM_APPLY_SERVERFootref 1 |
V$XSTREAM_APPLY_SERVERFootref 1 |
Footnote 1 This 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 I, "Dynamic Performance Views" for more information about these dynamic performance viewsThe following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.3):
AWR_SNAPSHOT_TIME_OFFSETCLONEDB
See Also:
Part I, "Initialization Parameters" for more information about these initialization parametersThe following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.2):
CURSOR_BIND_CAPTURE_DESTINATIONDB_FLASH_CACHE_FILEDB_FLASH_CACHE_SIZEDB_UNRECOVERABLE_SCN_TRACKINGUSE_LARGE_PAGES
See Also:
Part I, "Initialization Parameters" for more information about these initialization parametersThe 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 I, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe 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 I, "Dynamic Performance Views" for more information about these dynamic performance viewsThe following initialization parameters are new to Oracle Database 11g Release 2 (11.2.0.1):
DEFERRED_SEGMENT_CREATIONDST_UPGRADE_INSERT_CONVLISTENER_NETWORKSPARALLEL_DEGREE_LIMITPARALLEL_DEGREE_POLICYPARALLEL_FORCE_LOCALPARALLEL_MIN_TIME_THRESHOLDPARALLEL_SERVERS_TARGET
See Also:
Part I, "Initialization Parameters" for more information about these initialization parametersThe 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_CONTENTDBFS_CONTENT_PROPERTIES
See Also:
Part I, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe 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 I, "Dynamic Performance Views" for more information about these dynamic performance viewsThe following initialization parameters are new to Oracle Database 11g Release 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
See Also:
Part I, "Initialization Parameters" for more information about these initialization parametersThe 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 I, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe 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 I, "Dynamic Performance Views" for more information about these dynamic performance views