This preface lists changes in Oracle Database Reference:
This section lists changes in Oracle Database Reference for Oracle Database 12c Release 2 (12.2.0.1).
This section describes new features in Oracle Database 12c Release 2 (12.2.0.1).
The following initialization parameters are new in Oracle Database 12c Release 2 (12.2.0.1):
ALLOW_GLOBAL_DBLINKS
ALLOW_GROUP_ACCESS_TO_SGA
APPROX_FOR_AGGREGATION
APPROX_FOR_COUNT_DISTINCT
APPROX_FOR_PERCENTILE
ASM_IO_PROCESSES
AUTOTASK_MAX_ACTIVE_PDBS
AWR_PDB_AUTOFLUSH_ENABLED
CLONEDB_DIR
CONTAINERS_PARALLEL_DEGREE
CURSOR_INVALIDATION
DATA_GUARD_SYNC_LATENCY
DATA_TRANSFER_CACHE_SIZE
DB_PERFORMANCE_PROFILE
DEFAULT_SHARING
ENABLE_AUTOMATIC_MAINTENANCE_PDB
ENABLE_DNFS_DISPATCHER
ENABLED_PDBS_ON_STANDBY
ENCRYPT_NEW_TABLESPACES
EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION
INMEMORY_ADG_ENABLED
INMEMORY_EXPRESSIONS_USAGE
INMEMORY_VIRTUAL_COLUMNS
INSTANCE_ABORT_DELAY_TIME
INSTANCE_MODE
LONG_MODULE_ACTION
MAX_DATAPUMP_JOBS_PER_PDB
MAX_IDLE_TIME
MAX_IOPS
MAX_MBPS
MAX_PDBS
OFS_THREADS
OPTIMIZER_ADAPTIVE_PLANS
OPTIMIZER_ADAPTIVE_STATISTICS
OUTBOUND_DBLINK_PROTOCOLS
PDB_LOCKDOWN
PDB_OS_CREDENTIAL
REMOTE_RECOVERY_FILE_DEST
RESOURCE_MANAGE_GOLDENGATE
SGA_MIN_SIZE
SHRD_DUPL_TABLE_REFRESH_RATE
STANDBY_DB_PRESERVE_STATES
UNIFORM_LOG_TIMESTAMP_FORMAT
See Also:
Initialization Parameters for more information about these initialization parameters
ALL_ANALYTIC_VIEW_ATTR_CLASS, DBA_ANALYTIC_VIEW_ATTR_CLASS, and USER_ANALYTIC_VIEW_ATTR_CLASS
ALL_ANALYTIC_VIEW_BASE_MEAS, DBA_ANALYTIC_VIEW_BASE_MEAS, and USER_ANALYTIC_VIEW_BASE_MEAS
ALL_ANALYTIC_VIEW_CALC_MEAS, DBA_ANALYTIC_VIEW_CALC_MEAS, and USER_ANALYTIC_VIEW_CALC_MEAS
ALL_ANALYTIC_VIEW_CLASS, DBA_ANALYTIC_VIEW_CLASS, and USER_ANALYTIC_VIEW_CLASS
ALL_ANALYTIC_VIEW_COLUMNS, DBA_ANALYTIC_VIEW_COLUMNS, and USER_ANALYTIC_VIEW_COLUMNS
ALL_ANALYTIC_VIEW_DIM_CLASS, DBA_ANALYTIC_VIEW_DIM_CLASS, and USER_ANALYTIC_VIEW_DIM_CLASS
ALL_ANALYTIC_VIEW_DIMENSIONS, DBA_ANALYTIC_VIEW_DIMENSIONS, and USER_ANALYTIC_VIEW_DIMENSIONS
ALL_ANALYTIC_VIEW_HIER_CLASS, DBA_ANALYTIC_VIEW_HIER_CLASS, and USER_ANALYTIC_VIEW_HIER_CLASS
ALL_ANALYTIC_VIEW_HIERS, DBA_ANALYTIC_VIEW_HIERS, and USER_ANALYTIC_VIEW_HIERS
ALL_ANALYTIC_VIEW_KEYS, DBA_ANALYTIC_VIEW_KEYS, and USER_ANALYTIC_VIEW_KEYS
ALL_ANALYTIC_VIEW_LEVEL_CLASS, DBA_ANALYTIC_VIEW_LEVEL_CLASS, and USER_ANALYTIC_VIEW_LEVEL_CLASS
ALL_ANALYTIC_VIEW_LEVELS, DBA_ANALYTIC_VIEW_LEVELS, and USER_ANALYTIC_VIEW_LEVELS
ALL_ANALYTIC_VIEW_LVLGRPS, DBA_ANALYTIC_VIEW_LVLGRPS, and USER_ANALYTIC_VIEW_LVLGRPS
ALL_ANALYTIC_VIEW_MEAS_CLASS, DBA_ANALYTIC_VIEW_MEAS_CLASS, and USER_ANALYTIC_VIEW_MEAS_CLASS
ALL_ANALYTIC_VIEWS, DBA_ANALYTIC_VIEWS, and USER_ANALYTIC_VIEWS
ALL_ATTRIBUTE_DIM_ATTR_CLASS, DBA_ATTRIBUTE_DIM_ATTR_CLASS, and USER_ATTRIBUTE_DIM_ATTR_CLASS
ALL_ATTRIBUTE_DIM_ATTRS, DBA_ATTRIBUTE_DIM_ATTRS, and USER_ATTRIBUTE_DIM_ATTRS
ALL_ATTRIBUTE_DIM_CLASS, DBA_ATTRIBUTE_DIM_CLASS, and USER_ATTRIBUTE_DIM_CLASS
ALL_ATTRIBUTE_DIM_JOIN_PATHS, DBA_ATTRIBUTE_DIM_JOIN_PATHS, and USER_ATTRIBUTE_DIM_JOIN_PATHS
ALL_ATTRIBUTE_DIM_KEYS, DBA_ATTRIBUTE_DIM_KEYS, and USER_ATTRIBUTE_DIM_KEYS
ALL_ATTRIBUTE_DIM_LEVEL_ATTRS, DBA_ATTRIBUTE_DIM_LEVEL_ATTRS, and USER_ATTRIBUTE_DIM_LEVEL_ATTRS
ALL_ATTRIBUTE_DIM_LEVELS, DBA_ATTRIBUTE_DIM_LEVELS, and USER_ATTRIBUTE_DIM_LEVELS
ALL_ATTRIBUTE_DIM_LVL_CLASS, DBA_ATTRIBUTE_DIM_LVL_CLASS, and USER_ATTRIBUTE_DIM_LVL_CLASS
ALL_ATTRIBUTE_DIM_ORDER_ATTRS, DBA_ATTRIBUTE_DIM_ORDER_ATTRS, and USER_ATTRIBUTE_DIM_ORDER_ATTRS
ALL_ATTRIBUTE_DIM_TABLES, DBA_ATTRIBUTE_DIM_TABLES, and USER_ATTRIBUTE_DIM_TABLES
ALL_ATTRIBUTE_DIMENSIONS, DBA_ATTRIBUTE_DIMENSIONS, and USER_ATTRIBUTE_DIMENSIONS
ALL_EXPRESSION_STATISTICS, DBA_EXPRESSION_STATISTICS, and USER_EXPRESSION_STATISTICS
ALL_HIER_CLASS, DBA_HIER_CLASS, and USER_HIER_CLASS
ALL_HIER_COLUMNS, DBA_HIER_COLUMNS, and USER_HIER_COLUMNS
ALL_HIER_HIER_ATTR_CLASS, DBA_HIER_HIER_ATTR_CLASS, and USER_HIER_HIER_ATTR_CLASS
ALL_HIER_HIER_ATTRIBUTES, DBA_HIER_HIER_ATTRIBUTES, and USER_HIER_HIER_ATTRIBUTES
ALL_HIER_JOIN_PATHS, DBA_HIER_JOIN_PATHS, and USER_HIER_JOIN_PATHS
ALL_HIER_LEVEL_ID_ATTRS, DBA_HIER_LEVEL_ID_ATTRS, and USER_HIER_LEVEL_ID_ATTRS
ALL_HIER_LEVELS, DBA_HIER_LEVELS, and USER_HIER_LEVELS
ALL_HIERARCHIES, DBA_HIERARCHIES, and USER_HIERARCHIES
ALL_HIVE_COLUMNS, DBA_HIVE_COLUMNS, and USER_HIVE_COLUMNS
ALL_HIVE_DATABASES, DBA_HIVE_DATABASES, and USER_HIVE_DATABASES
ALL_HIVE_PART_KEY_COLUMNS, DBA_HIVE_PART_KEY_COLUMNS, and USER_HIVE_PART_KEY_COLUMNS
ALL_HIVE_TAB_PARTITIONS, DBA_HIVE_TAB_PARTITIONS, and USER_HIVE_TAB_PARTITIONS
ALL_HIVE_TABLES, DBA_HIVE_TABLES, and USER_HIVE_TABLES
ALL_JSON_DATAGUIDES, DBA_JSON_DATAGUIDES, and USER_JSON_DATAGUIDES
ALL_MINING_MODEL_PARTITIONS, DBA_MINING_MODEL_PARTITIONS, and USER_MINING_MODEL_PARTITIONS
ALL_MINING_MODEL_VIEWS, DBA_MINING_MODEL_VIEWS, and USER_MINING_MODEL_VIEWS
ALL_MINING_MODEL_XFORMS, DBA_MINING_MODEL_XFORMS, and USER_MINING_MODEL_XFORMS
ALL_REPLICATION_PROCESS_EVENTS and DBA_REPLICATION_PROCESS_EVENTS
ALL_SCHEDULER_INCOMPAT_MEMBER, DBA_SCHEDULER_INCOMPAT_MEMBER, and USER_SCHEDULER_INCOMPAT_MEMBER
ALL_SCHEDULER_INCOMPATS, DBA_SCHEDULER_INCOMPATS, and USER_SCHEDULER_INCOMPATS
ALL_SCHEDULER_RESOURCES, DBA_SCHEDULER_RESOURCES, and USER_SCHEDULER_RESOURCES
ALL_SCHEDULER_RSC_CONSTRAINTS, DBA_SCHEDULER_RSC_CONSTRAINTS, and USER_SCHEDULER_RSC_CONSTRAINTS
ALL_STATEMENTS, DBA_STATEMENTS, and USER_STATEMENTS
ALL_XTERNAL_LOC_PARTITIONS, DBA_XTERNAL_LOC_PARTITIONS, and USER_XTERNAL_LOC_PARTITIONS
ALL_XTERNAL_LOC_SUBPARTITIONS, DBA_XTERNAL_LOC_SUBPARTITIONS, and USER_XTERNAL_LOC_SUBPARTITIONS
ALL_XTERNAL_PART_TABLES, DBA_XTERNAL_PART_TABLES, and USER_XTERNAL_PART_TABLES
ALL_XTERNAL_TAB_PARTITIONS, DBA_XTERNAL_TAB_PARTITIONS, and USER_XTERNAL_TAB_PARTITIONS
ALL_XTERNAL_TAB_SUBPARTITIONS, DBA_XTERNAL_TAB_SUBPARTITIONS, and USER_XTERNAL_TAB_SUBPARTITIONS
DBA_APP_ERRORS
DBA_APP_PATCHES
DBA_APP_PDB_STATUS
DBA_APP_STATEMENTS
DBA_APP_VERSIONS
DBA_APPLICATIONS
DBA_CHECKED_ROLES
DBA_CHECKED_ROLES_PATH
DBA_EXTERNAL_SCN_ACTIVITY
DBA_GG_PROC_OBJECT_EXCLUSION
DBA_GG_PROCEDURE_ANNOTATION
DBA_GG_SUPPORTED_PACKAGES
DBA_GG_SUPPORTED_PROCEDURES
DBA_GOLDENGATE_NOT_UNIQUE
DBA_HANG_MANAGER_PARAMETERS
DBA_HIST_CHANNEL_WAITS
DBA_HIST_CON_SYS_TIME_MODEL
DBA_HIST_CON_SYSMETRIC_HIST
DBA_HIST_CON_SYSMETRIC_SUMM
DBA_HIST_CON_SYSSTAT
DBA_HIST_CON_SYSTEM_EVENT
DBA_HIST_RECOVERY_PROGRESS
DBA_HIST_RSRC_METRIC
DBA_HIST_RSRC_PDB_METRIC
DBA_HIST_WR_SETTINGS
DBA_IM_EXPRESSIONS and USER_IM_EXPRESSIONS
DBA_INDEX_USAGE
DBA_JOINGROUPS and USER_JOINGROUPS
DBA_LOCKDOWN_PROFILES
DBA_MVREF_CHANGE_STATS and USER_MVREF_CHANGE_STATS
DBA_MVREF_RUN_STATS and USER_MVREF_RUN_STATS
DBA_MVREF_STATS and USER_MVREF_STATS
DBA_MVREF_STATS_PARAMS and USER_MVREF_STATS_PARAMS
DBA_MVREF_STATS_SYS_DEFAULTS and USER_MVREF_STATS_SYS_DEFAULTS
DBA_MVREF_STMT_STATS and USER_MVREF_STMT_STATS
DBA_REGISTRY_SCHEMAS
DBA_UMF_LINK
DBA_UMF_REGISTRATION
DBA_UMF_SERVICE
DBA_UMF_TOPOLOGY
DBA_UNUSED_GRANTS
DBA_WORKLOAD_GROUP_ASSIGNMENTS
DBA_WORKLOAD_REPLAY_CLIENTS
DBA_WORKLOAD_SQL_MAP
DBA_WORKLOAD_TRACKED_COMMITS
DBA_XS_ENABLED_AUDIT_POLICIES
DBMS_METADATA_PARSE_ITEMS
DBMS_METADATA_TRANSFORM_PARAMS
DBMS_METADATA_TRANSFORMS
REDACTION_EXPRESSIONS
See Also:
Static Data Dictionary Views for more information about these static data dictionary views
GV$AQ_MESSAGE_CACHE_ADVICE and V$AQ_MESSAGE_CACHE_ADVICE
GV$AQ_MESSAGE_CACHE_STAT and V$AQ_MESSAGE_CACHE_STAT
GV$AQ_REMOTE_DEQUEUE_AFFINITY and V$AQ_REMOTE_DEQUEUE_AFFINITY
GV$AQ_SHARDED_SUBSCRIBER_STAT and V$AQ_SHARDED_SUBSCRIBER_STAT
GV$ASM_FILEGROUP and V$ASM_FILEGROUP
GV$ASM_FILEGROUP_FILE and V$ASM_FILEGROUP_FILE
GV$ASM_FILEGROUP_PROPERTY and V$ASM_FILEGROUP_PROPERTY
GV$ASM_QUOTAGROUP and V$ASM_QUOTAGROUP
GV$CHUNK_METRIC and V$CHUNK_METRIC
GV$CLEANUP_PROCESS and V$CLEANUP_PROCESS
GV$CODE_CLAUSE and V$CODE_CLAUSE
GV$CON_EVENT_HISTOGRAM_MICRO and V$CON_EVENT_HISTOGRAM_MICRO
GV$CON_SYSMETRIC and V$CON_SYSMETRIC
GV$CON_SYSMETRIC_HISTORY and V$CON_SYSMETRIC_HISTORY
GV$CON_SYSMETRIC_SUMMARY and V$CON_SYSMETRIC_SUMMARY
GV$DATABASE_KEY_INFO and V$DATABASE_KEY_INFO
GV$DIAG_APP_TRACE_FILE and V$DIAG_APP_TRACE_FILE
GV$DIAG_OPT_TRACE_RECORDS and V$DIAG_OPT_TRACE_RECORDS
V$DIAG_SESS_OPT_TRACE_RECORDS
V$DIAG_SESS_SQL_TRACE_RECORDS
GV$DIAG_SQL_TRACE_RECORDS and V$DIAG_SQL_TRACE_RECORDS
GV$DIAG_TRACE_FILE and V$DIAG_TRACE_FILE
GV$DIAG_TRACE_FILE_CONTENTS and V$DIAG_TRACE_FILE_CONTENTS
GV$EXP_STATS and V$EXP_STATS
GV$FS_FAILOVER_OBSERVERS and V$FS_FAILOVER_OBSERVERS
GV$GCR_ACTIONS and V$GCR_ACTIONS
GV$GCR_LOG and V$GCR_LOG
GV$GCR_METRICS and V$GCR_METRICS
GV$GCR_STATUS and V$GCR_STATUS
GV$GOLDENGATE_PROCEDURE_STATS and V$GOLDENGATE_PROCEDURE_STATS
GV$INDEX_USAGE_INFO and V$INDEX_USAGE_INFO
GV$INMEMORY_FASTSTART_AREA and V$INMEMORY_FASTSTART_AREA
GV$IOS_CLIENT and V$IOS_CLIENT
GV$IP_ACL and V$IP_ACL
GV$OFS_STATS and V$OFS_STATS
GV$OFSMOUNT and V$OFSMOUNT
GV$ONLINE_REDEF and V$ONLINE_REDEF
GV$PASSWORDFILE_INFO and V$PASSWORDFILE_INFO
GV$PLSQL_DEBUGGABLE_SESSIONS and V$PLSQL_DEBUGGABLE_SESSIONS
GV$PROCESS_POOL and V$PROCESS_POOL
GV$PROXY_PDB_TARGETS and V$PROXY_PDB_TARGETS
GV$QUARANTINE and V$QUARANTINE
GV$RECOVERY_SLAVE and V$RECOVERY_SLAVE
GV$RSRC_PDB and V$RSRC_PDB
GV$RSRC_PDB_HISTORY and V$RSRC_PDB_HISTORY
GV$RSRCPDBMETRIC and V$RSRCPDBMETRIC
GV$RSRCPDBMETRIC_HISTORY and V$RSRCPDBMETRIC_HISTORY
GV$SERVICE_REGION_METRIC and V$SERVICE_REGION_METRIC
V$STATS_ADVISOR_RULES
GV$ZONEMAP_USAGE_STATS and V$ZONEMAP_USAGE_STATS
See Also:
Dynamic Performance Views for more information about these dynamic performance views
The following features are deprecated in Oracle Database 12c Release 2 (12.2.0.1), and may be desupported in a future release:
The ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter
See "ASM_PREFERRED_READ_FAILURE_GROUPS" for information about alternatives.
The O7_DICTIONARY_ACCESSIBILITY initialization parameter
The PARALLEL_ADAPTIVE_MULTI_USER initialization parameter
See "PARALLEL_ADAPTIVE_MULTI_USER" for information about alternatives.
The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter
The UTL_FILE_DIR initialization parameter
See "UTL_FILE_DIR" for information about alternatives.
The V$MANAGED_STANDBY view
See "V$MANAGED_STANDBY" for information about alternatives.
The following features are desupported in Oracle Database 12c Release 2 (12.2.0.1):
The GLOBAL_CONTEXT_POOL_SIZE initialization parameter
The MAX_ENABLED_ROLES initialization parameter
The OPTIMIZER_ADAPTIVE_FEATURES initialization parameter
The PARALLEL_AUTOMATIC_TUNING initialization parameter
The PARALLEL_IO_CAP_ENABLED initialization parameter
The PARALLEL_SERVER initialization parameter
The PARALLEL_SERVER_INSTANCES initialization parameter
The USE_INDIRECT_DATA_BUFFERS initialization parameter
The DBA_REGISTERED_MVIEW_GROUPS view
The V$REPLPROP view
The V$REPLQUEUE view
The following are changes in Oracle Database Reference for Oracle Database 12c Release 1 (12.1.0.2).
The following initialization parameters are new in Oracle Database 12c Release 1 (12.1.0.2):
COMMON_USER_PREFIXDB_BIG_TABLE_CACHE_PERCENT_TARGETDBFIPS_140ENABLE_GOLDENGATE_REPLICATIONFoot 1INMEMORY_CLAUSE_DEFAULTINMEMORY_FORCEINMEMORY_MAX_POPULATE_SERVERSINMEMORY_QUERYINMEMORY_SIZEINMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENTOPTIMIZER_INMEMORY_AWARESee Also:
Initialization Parameters for more information about these initialization parameters
The following static data dictionary views are new in this release:
ALL_CLUSTERING_DIMENSIONS, DBA_CLUSTERING_DIMENSIONS, and USER_CLUSTERING_DIMENSIONS
ALL_CLUSTERING_JOINS, DBA_CLUSTERING_JOINS, and USER_CLUSTERING_JOINS
ALL_CLUSTERING_KEYS, DBA_CLUSTERING_KEYS, and USER_CLUSTERING_KEYS
ALL_CLUSTERING_TABLES, DBA_CLUSTERING_TABLES, and USER_CLUSTERING_TABLES
ALL_JSON_COLUMNS, DBA_JSON_COLUMNS, and USER_JSON_COLUMNS
ALL_ZONEMAP_MEASURES, DBA_ZONEMAP_MEASURES, and USER_ZONEMAP_MEASURES
ALL_ZONEMAPS, DBA_ZONEMAPS, and USER_ZONEMAPS
DBA_HIST_IM_SEG_STAT
DBA_HIST_IM_SEG_STAT_OBJ
DBA_PDB_SAVED_STATES
DBA_ROLLING_UNSUPPORTED
See Also:
Static Data Dictionary Views for more information about these static data dictionary views
The following dynamic performance views are new in this release:
GV$BT_SCAN_CACHE and V$BT_SCAN_CACHE
GV$BT_SCAN_OBJ_TEMP and V$BT_SCAN_OBJ_TEMP
GV$EMX_USAGE_STATS and V$EMX_USAGE_STATS
GV$EVENT_HISTOGRAM_MICRO and V$EVENT_HISTOGRAM_MICRO
GV$FS_OBSERVER_HISTOGRAM and V$FS_OBSERVER_HISTOGRAM
These views were introduced in Oracle Database 11g Release 2 (11.2.0.4), but are available for the first time in Oracle Database 12c with Oracle Database 12c Release 1 (12.1.0.2).
GV$IM_COLUMN_LEVEL and V$IM_COLUMN_LEVEL
GV$IM_SEGMENTS and V$IM_SEGMENTS
GV$IM_USER_SEGMENTS and V$IM_USER_SEGMENTS
GV$INMEMORY_AREA and V$INMEMORY_AREA
GV$KEY_VECTOR and V$KEY_VECTOR
See Also:
Dynamic Performance Views for more information about these dynamic performance views
The following features are deprecated in Oracle Database 12c Release 1 (12.1.0.2), and may be desupported in a future release:
The RDBMS_SERVER_DN initialization parameter
See "RDBMS_SERVER_DN" for information about alternatives.
The following are changes in Oracle Database Reference for Oracle Database 12c Release 1 (12.1.0.1).
The following initialization parameters are new in Oracle Database 12c Release 1 (12.1.0.1):
CONNECTION_BROKERSDNFS_BATCH_SIZEENABLE_PLUGGABLE_DATABASEHEAT_MAPMAX_STRING_SIZEOPTIMIZER_ADAPTIVE_FEATURESOPTIMIZER_ADAPTIVE_REPORTING_ONLYPDB_FILE_NAME_CONVERTPGA_AGGREGATE_LIMITPROCESSOR_GROUP_NAMENONCDB_COMPATIBLESPATIAL_VECTOR_ACCELERATIONTEMP_UNDO_ENABLEDTHREADED_EXECUTIONUNIFIED_AUDIT_SGA_QUEUE_SIZEUSE_DEDICATED_BROKERSee Also:
Initialization Parameters for more information about these initialization parameters
The following static data dictionary views are new in this release:
ALL_APPLY_INSTANTIATED_GLOBAL and DBA_APPLY_INSTANTIATED_GLOBAL
ALL_APPLY_INSTANTIATED_OBJECTS and DBA_APPLY_INSTANTIATED_OBJECTS
ALL_APPLY_INSTANTIATED_SCHEMAS and DBA_APPLY_INSTANTIATED_SCHEMAS
ALL_ATTRIBUTE_TRANSFORMATIONS, DBA_ATTRIBUTE_TRANSFORMATIONS, and USER_ATTRIBUTE_TRANSFORMATIONS
ALL_CODE_ROLE_PRIVS, DBA_CODE_ROLE_PRIVS, and USER_CODE_ROLE_PRIVS
ALL_CREDENTIALS, DBA_CREDENTIALS, and USER_CREDENTIALS
ALL_CUBE_NAMED_BUILD_SPECS, DBA_CUBE_NAMED_BUILD_SPECS, and USER_CUBE_NAMED_BUILD_SPECS
ALL_CUBE_SUB_PARTITION_LEVELS, DBA_CUBE_SUB_PARTITION_LEVELS, and USER_CUBE_SUB_PARTITION_LEVELS
ALL_ERROR_TRANSLATIONS, DBA_ERROR_TRANSLATIONS, and USER_ERROR_TRANSLATIONS
ALL_GG_INBOUND_PROGRESS and DBA_GG_INBOUND_PROGRESS
ALL_GOLDENGATE_INBOUND and DBA_GOLDENGATE_INBOUND
ALL_GOLDENGATE_PRIVILEGES, DBA_GOLDENGATE_PRIVILEGES, and USER_GOLDENGATE_PRIVILEGES
ALL_GOLDENGATE_RULES and DBA_GOLDENGATE_RULES
ALL_HEAT_MAP_SEG_HISTOGRAM, DBA_HEAT_MAP_SEG_HISTOGRAM, and USER_HEAT_MAP_SEG_HISTOGRAM
ALL_HEAT_MAP_SEGMENT, DBA_HEAT_MAP_SEGMENT, and USER_HEAT_MAP_SEGMENT
ALL_MEASURE_FOLDER_SUBFOLDERS, DBA_MEASURE_FOLDER_SUBFOLDERS, and USER_MEASURE_FOLDER_SUBFOLDERS
ALL_METADATA_PROPERTIES, DBA_METADATA_PROPERTIES, and USER_METADATA_PROPERTIES
ALL_PLSQL_COLL_TYPES, DBA_PLSQL_COLL_TYPES, and USER_PLSQL_COLL_TYPES
ALL_PLSQL_TYPE_ATTRS, DBA_PLSQL_TYPE_ATTRS, and USER_PLSQL_TYPE_ATTRS
ALL_PLSQL_TYPES, DBA_PLSQL_TYPES, and USER_PLSQL_TYPES
ALL_POLICY_ATTRIBUTES, DBA_POLICY_ATTRIBUTES, and USER_POLICY_ATTRIBUTES
ALL_SQL_TRANSLATION_PROFILES, DBA_SQL_TRANSLATION_PROFILES, and USER_SQL_TRANSLATION_PROFILES
ALL_SQL_TRANSLATIONS, DBA_SQL_TRANSLATIONS, and USER_SQL_TRANSLATIONS
ALL_TAB_IDENTITY_COLS, DBA_TAB_IDENTITY_COLS, and USER_TAB_IDENTITY_COLS
ALL_TRANSFORMATIONS, DBA_TRANSFORMATIONS, and USER_TRANSFORMATIONS
ALL_XML_NESTED_TABLES, DBA_XML_NESTED_TABLES, and USER_XML_NESTED_TABLES
ALL_XML_OUT_OF_LINE_TABLES, DBA_XML_OUT_OF_LINE_TABLES, and USER_XML_OUT_OF_LINE_TABLES
ALL_XML_SCHEMA_ATTRIBUTES, DBA_XML_SCHEMA_ATTRIBUTES, and USER_XML_SCHEMA_ATTRIBUTES
ALL_XML_SCHEMA_COMPLEX_TYPES, DBA_XML_SCHEMA_COMPLEX_TYPES, and USER_XML_SCHEMA_COMPLEX_TYPES
ALL_XML_SCHEMA_ELEMENTS, DBA_XML_SCHEMA_ELEMENTS, and USER_XML_SCHEMA_ELEMENTS
ALL_XML_SCHEMA_NAMESPACES, DBA_XML_SCHEMA_NAMESPACES, and USER_XML_SCHEMA_NAMESPACES
ALL_XML_SCHEMA_SIMPLE_TYPES, DBA_XML_SCHEMA_SIMPLE_TYPES, and USER_XML_SCHEMA_SIMPLE_TYPES
ALL_XML_SCHEMA_SUBSTGRP_HEAD, DBA_XML_SCHEMA_SUBSTGRP_HEAD, and USER_XML_SCHEMA_SUBSTGRP_HEAD
ALL_XML_SCHEMA_SUBSTGRP_MBRS, DBA_XML_SCHEMA_SUBSTGRP_MBRS, and USER_XML_SCHEMA_SUBSTGRP_MBRS
ALL_XSTREAM_ADMINISTRATOR and DBA_XSTREAM_ADMINISTRATOR
ALL_XSTREAM_OUT_SUPPORT_MODE and DBA_XSTREAM_OUT_SUPPORT_MODE
ALL_XSTREAM_TRANSFORMATIONS and DBA_XSTREAM_TRANSFORMATIONS
AUDIT_UNIFIED_CONTEXTS
AUDIT_UNIFIED_ENABLED_POLICIES
AUDIT_UNIFIED_POLICIES
AUDIT_UNIFIED_POLICY_COMMENTS
AUDITABLE_SYSTEM_ACTIONS
DATABASE_EXPORT_OBJECTS
DBA_ACL_NAME_MAP
DBA_ALERT_HISTORY_DETAIL
DBA_CDB_RSRC_PLAN_DIRECTIVES
DBA_CDB_RSRC_PLANS
DBA_CONTAINER_DATA
DBA_DIGEST_VERIFIERS
DBA_DISCOVERY_SOURCE
DBA_EDITIONED_TYPES and USER_EDITIONED_TYPES
DBA_GOLDENGATE_SUPPORT_MODE
DBA_HEATMAP_TOP_OBJECTS
DBA_HEATMAP_TOP_TABLESPACES
DBA_HIST_APPLY_SUMMARY
DBA_HIST_ASH_SNAPSHOT
DBA_HIST_CAPTURE
DBA_HIST_PDB_INSTANCE
DBA_HIST_REPLICATION_TBL_STATS
DBA_HIST_REPLICATION_TXN_STATS
DBA_HIST_REPORTS
DBA_HIST_REPORTS_DETAILS
DBA_HIST_REPORTS_TIMEBANDS
DBA_HIST_SESS_SGA_STATS
DBA_HIST_TABLESPACE
DBA_HOST_ACES and USER_HOST_ACES
DBA_HOST_ACLS
DBA_ILMDATAMOVEMENTPOLICIES and USER_ILMDATAMOVEMENTPOLICIES
DBA_ILMEVALUATIONDETAILS and USER_ILMEVALUATIONDETAILS
DBA_ILMOBJECTS and USER_ILMOBJECTS
DBA_ILMPARAMETERS
DBA_ILMPOLICIES and USER_ILMPOLICIES
DBA_ILMRESULTS and USER_ILMRESULTS
DBA_ILMTASKS and USER_ILMTASKS
DBA_LOGSTDBY_EDS_SUPPORTED
DBA_LOGSTDBY_EDS_TABLES
DBA_LOGSTDBY_PLSQL_MAP
DBA_LOGSTDBY_PLSQL_SUPPORT
DBA_MINING_MODEL_TABLES
DBA_OBJECT_USAGE and USER_OBJECT_USAGE
DBA_OPTSTAT_OPERATION_TASKS
DBA_PDB_HISTORY
DBA_PDBS
DBA_PRIV_CAPTURES
DBA_ROLLING_DATABASES
DBA_ROLLING_EVENTS
DBA_ROLLING_PARAMETERS
DBA_ROLLING_PLAN
DBA_ROLLING_STATISTICS
DBA_ROLLING_STATUS
DBA_SENSITIVE_COLUMN_TYPES
DBA_SENSITIVE_COLUMNS
DBA_SQL_PLAN_DIR_OBJECTS
DBA_SQL_PLAN_DIRECTIVES
DBA_SR_GRP_STATUS and USER_SR_GRP_STATUS
DBA_SR_GRP_STATUS_ALL and USER_SR_GRP_STATUS_ALL
DBA_SR_OBJ and USER_SR_OBJ
DBA_SR_OBJ_ALL and USER_SR_OBJ_ALL
DBA_SR_OBJ_STATUS and USER_SR_OBJ_STATUS
DBA_SR_OBJ_STATUS_ALL and USER_SR_OBJ_STATUS_ALL
DBA_SR_PARTN_OPS and USER_SR_PARTN_OPS
DBA_SR_STLOG_EXCEPTIONS and USER_SR_STLOG_EXCEPTIONS
DBA_SR_STLOG_STATS and USER_SR_STLOG_STATS
DBA_SUPPLEMENTAL_LOGGING
DBA_TSDP_IMPORT_ERRORS
DBA_TSDP_POLICY_CONDITION
DBA_TSDP_POLICY_FEATURE
DBA_TSDP_POLICY_PARAMETER
DBA_TSDP_POLICY_PROTECTION
DBA_TSDP_POLICY_TYPE
DBA_UNUSED_OBJPRIVS
DBA_UNUSED_OBJPRIVS_PATH
DBA_UNUSED_PRIVS
DBA_UNUSED_SYSPRIVS
DBA_UNUSED_SYSPRIVS_PATH
DBA_UNUSED_USERPRIVS
DBA_UNUSED_USERPRIVS_PATH
DBA_USED_OBJPRIVS
DBA_USED_OBJPRIVS_PATH
DBA_USED_PRIVS
DBA_USED_PUBPRIVS
DBA_USED_SYSPRIVS
DBA_USED_SYSPRIVS_PATH
DBA_USED_USERPRIVS
DBA_USED_USERPRIVS_PATH
DBA_WALLET_ACES and USER_WALLET_ACES
DBA_WI_CAPTURE_FILES
DBA_WI_JOBS
DBA_WI_OBJECTS
DBA_WI_PATTERN_ITEMS
DBA_WI_PATTERNS
DBA_WI_STATEMENTS
DBA_WI_TEMPLATE_EXECUTIONS
DBA_WI_TEMPLATES
DBA_WORKLOAD_ACTIVE_USER_MAP
DBA_WORKLOAD_REPLAY_SCHEDULES
DBA_WORKLOAD_SCHEDULE_CAPTURES
DBA_WORKLOAD_SCHEDULE_ORDERING
DBA_WORKLOAD_USER_MAP
DBA_XS_AUDIT_POLICY_OPTIONS
DBA_XS_AUDIT_TRAIL
DBA_XS_ENB_AUDIT_POLICIES
DBA_XSTREAM_SPLIT_MERGE
DBA_XSTREAM_SPLIT_MERGE_HIST
DBA_XSTREAM_STMT_HANDLERS
DBA_XSTREAM_STMTS
PDB_PLUG_IN_VIOLATIONS
REDACTION_COLUMNS
REDACTION_POLICIES
REDACTION_VALUES_FOR_TYPE_FULL
SCHEMA_EXPORT_OBJECTS
TABLE_EXPORT_OBJECTS
UNIFIED_AUDIT_TRAIL
USER_PRIVILEGE_MAP
See Also:
Static Data Dictionary Views for more information about these static data dictionary views
There are new CDB views introduced in this release.
See Also:
"CDB_* Views" for more information about CDB views
The following dynamic performance views are new in this release:
GV$AQ_BACKGROUND_COORDINATOR and V$AQ_BACKGROUND_COORDINATOR
GV$AQ_BMAP_NONDUR_SUBSCRIBERS and V$AQ_BMAP_NONDUR_SUBSCRIBERS
GV$AQ_CROSS_INSTANCE_JOBS and V$AQ_CROSS_INSTANCE_JOBS
GV$AQ_JOB_COORDINATOR and V$AQ_JOB_COORDINATOR
GV$AQ_NONDUR_REGISTRATIONS and V$AQ_NONDUR_REGISTRATIONS
GV$AQ_NONDUR_SUBSCRIBER and V$AQ_NONDUR_SUBSCRIBER
GV$AQ_NONDUR_SUBSCRIBER_LWM and V$AQ_NONDUR_SUBSCRIBER_LWM
GV$AQ_NOTIFICATION_CLIENTS and V$AQ_NOTIFICATION_CLIENTS
GV$AQ_SERVER_POOL and V$AQ_SERVER_POOL
GV$AQ_SUBSCRIBER_LOAD and V$AQ_SUBSCRIBER_LOAD
GV$ASM_ACFS_SEC_ADMIN and V$ASM_ACFS_SEC_ADMIN
GV$ASM_ACFS_SEC_CMDRULE and V$ASM_ACFS_SEC_CMDRULE
GV$ASM_ACFS_SEC_REALM and V$ASM_ACFS_SEC_REALM
GV$ASM_ACFS_SEC_REALM_FILTER and V$ASM_ACFS_SEC_REALM_FILTER
GV$ASM_ACFS_SEC_REALM_GROUP and V$ASM_ACFS_SEC_REALM_GROUP
GV$ASM_ACFS_SEC_REALM_USER and V$ASM_ACFS_SEC_REALM_USER
GV$ASM_ACFS_SEC_RULE and V$ASM_ACFS_SEC_RULE
GV$ASM_ACFS_SEC_RULESET and V$ASM_ACFS_SEC_RULESET
GV$ASM_ACFS_SEC_RULESET_RULE and V$ASM_ACFS_SEC_RULESET_RULE
GV$ASM_ACFSREPL and V$ASM_ACFSREPL
GV$ASM_ACFSREPLTAG and V$ASM_ACFSREPLTAG
GV$ASM_ACFSTAG and V$ASM_ACFSTAG
GV$ASM_ESTIMATE and V$ASM_ESTIMATE
GV$BACKUP_NONLOGGED and V$BACKUP_NONLOGGED
GV$CLIENT_SECRETS and V$CLIENT_SECRETS
GV$CLONEDFILE and V$CLONEDFILE
GV$CON_SYS_TIME_MODEL and V$CON_SYS_TIME_MODEL
GV$CON_SYSSTAT and V$CON_SYSSTAT
GV$CON_SYSTEM_EVENT and V$CON_SYSTEM_EVENT
GV$CON_SYSTEM_WAIT_CLASS and V$CON_SYSTEM_WAIT_CLASS
GV$CONTAINERS and V$CONTAINERS
GV$COPY_NONLOGGED and V$COPY_NONLOGGED
GV$DEAD_CLEANUP and V$DEAD_CLEANUP
GV$DG_BROKER_CONFIG and V$DG_BROKER_CONFIG
GV$EDITIONABLE_TYPES and V$EDITIONABLE_TYPES
GV$ENCRYPTION_KEYS and V$ENCRYPTION_KEYS
GV$FLASHFILESTAT and V$FLASHFILESTAT
GV$GG_APPLY_COORDINATOR and V$GG_APPLY_COORDINATOR
GV$GG_APPLY_READER and V$GG_APPLY_READER
GV$GG_APPLY_SERVER and V$GG_APPLY_SERVER
GV$GOLDENGATE_CAPTURE and V$GOLDENGATE_CAPTURE
GV$GOLDENGATE_MESSAGE_TRACKING and V$GOLDENGATE_MESSAGE_TRACKING
GV$GOLDENGATE_TABLE_STATS and V$GOLDENGATE_TABLE_STATS
GV$GOLDENGATE_TRANSACTION and V$GOLDENGATE_TRANSACTION
GV$HEAT_MAP_SEGMENT and V$HEAT_MAP_SEGMENT
GV$INSTANCE_PING and V$INSTANCE_PING
GV$IO_OUTLIER and V$IO_OUTLIER
GV$LGWRIO_OUTLIER and V$LGWRIO_OUTLIER
GV$MAPPED_SQL and V$MAPPED_SQL
GV$NONLOGGED_BLOCK and V$NONLOGGED_BLOCK
GV$IO_OUTLIER and V$IO_OUTLIER
GV$OPTIMIZER_PROCESSING_RATE and V$OPTIMIZER_PROCESSING_RATE
GV$PATCHES and V$PATCHES
GV$PDB_INCARNATION and V$PDB_INCARNATION
GV$PDBS and V$PDBS
GV$SESSIONS_COUNT and V$SESSIONS_COUNT
GV$RO_USER_ACCOUNT and V$RO_USER_ACCOUNT
GV$SQL_MONITOR_SESSTAT and V$SQL_MONITOR_SESSTAT
GV$SQL_MONITOR_STATNAME and V$SQL_MONITOR_STATNAME
GV$TEMPUNDOSTAT and V$TEMPUNDOSTAT
GV$XSTREAM_APPLY_COORDINATOR and V$XSTREAM_APPLY_COORDINATOR
GV$XSTREAM_APPLY_READER and V$XSTREAM_APPLY_READER
GV$XSTREAM_APPLY_SERVER and V$XSTREAM_APPLY_SERVER
GV$XSTREAM_TABLE_STATS and V$XSTREAM_TABLE_STATS
See Also:
Dynamic Performance Views for more information about these dynamic performance views
The following features are deprecated in Oracle Database 12c Release 1 (12.1.0.1), and may be desupported in a future release:
The FILE_MAPPING initialization parameter has been deprecated.
See "FILE_MAPPING" for more information.
The SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated.
See Oracle Database Security Guide for more information.
The ALL_SCHEDULER_CREDENTIALS view has been deprecated.
See "ALL_SCHEDULER_CREDENTIALS" for information about alternatives.
The DBA_NETWORK_ACL_PRIVILEGES view has been deprecated.
See "DBA_NETWORK_ACL_PRIVILEGES" for information about alternatives.
The DBA_NETWORK_ACLS view has been deprecated.
See "DBA_NETWORK_ACLS" for information about alternatives.
The DBA_SCHEDULER_CREDENTIALS view has been deprecated.
See "DBA_SCHEDULER_CREDENTIALS" for information about alternatives.
The USER_NETWORK_ACL_PRIVILEGES view has been deprecated.
See "USER_NETWORK_ACL_PRIVILEGES" for information about alternatives.
The USER_SCHEDULER_CREDENTIALS view has been deprecated.
See "USER_SCHEDULER_CREDENTIALS" for information about alternatives.
The V$OBJECT_USAGE view has been deprecated.
See "V$OBJECT_USAGE" for information about alternatives.
Footnote Legend
Footnote 1:This initialization parameter was introduced in Oracle Database 11g Release 2 (11.2.0.4), but is available for the first time in Oracle Database 12c with Oracle Database 12c Release 1 (12.1.0.2).