Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

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