| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
This section describes new features of Oracle Database 11g release 1 (11.1) 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 release 11.2:
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 release 11.2:
| 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_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 release 11.2:
DBFS_CONTENTDBFS_CONTENT_PROPERTIES
See Also:
Part II, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe following dynamic performance views are new to release 11.2:
| 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 viewsThe following initialization parameters are new to release 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 release 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 viewsThe following dynamic performance views are new to release 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$CLIENT_RESULT_CACHE_STATS |
V$CLIENT_RESULT_CACHE_STATS |
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_HISTOGRAM |
V$FS_FAILOVER_HISTOGRAM |
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$SSCR_SESSIONS |
V$SSCR_SESSIONS |
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 |
V$XS_SESSION |
|
V$XS_SESSION_ATTRIBUTE |
|
V$XS_SESSION_ROLE |
See Also:
Part III, "Dynamic Performance Views" for more information about these dynamic performance views