Changes in This Release for Oracle Database Reference
This preface lists changes in Oracle Database Reference:
Changes in Oracle Database Release 18c, Version 18.1
This section lists changes in Oracle Database Reference for Oracle Database release 18c, version 18.1.
See Oracle Database New Features Guide for a complete list of new features in this release.
New Features
This section lists describes new features in this manual for Oracle Database release 18c, version 18.1.
The following initialization parameters are new in Oracle Database release 18c, version 18.1:
See Also:
Initialization Parameters for more information about these initialization parameters
The following static data dictionary views are new in Oracle Database release 18c, version 18.1:
See Also:
Static Data Dictionary Views for more information about these static data dictionary views
The following dynamic performance views are new in Oracle Database release 18c, version 18.1:
-
GV$AQ_IPC_ACTIVE_MSGS and V$AQ_IPC_ACTIVE_MSGS
-
GV$AQ_IPC_MSG_STATS and V$AQ_IPC_MSG_STATS
-
GV$AQ_IPC_PENDING_MSGS and V$AQ_IPC_PENDING_MSGS
-
GV$LOCKDOWN_RULES and V$LOCKDOWN_RULES
-
GV$QUARANTINE_SUMMARY and V$QUARANTINE_SUMMARY
-
GV$SQL_SHARD and V$SQL_SHARD
See Also:
Dynamic Performance Views for more information about these dynamic performance views.
Deprecated Features
The following features are deprecated in Oracle Database release 18c, version 18.1, and may be desupported in a future release.
-
The MAX_CONNECTIONS attribute of the LOG_ARCHIVE_DEST_n parameter for Data Guard redo transport
Changes in Oracle Database 12c Release 2 (12.2.0.1)
This section lists changes in Oracle Database Reference for Oracle Database 12c Release 2 (12.2.0.1).
New Features
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):
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_ATTR_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_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_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_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_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_MVREF_STATS_SYS_DEFAULTS and USER_MVREF_STATS_SYS_DEFAULTS
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
-
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
-
GV$ZONEMAP_USAGE_STATS and V$ZONEMAP_USAGE_STATS
See Also:
GV$ Views and Dynamic Performance Views for more information about these dynamic performance views
Deprecated Features
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
-
The V$MANAGED_STANDBY view
See "V$MANAGED_STANDBY" for information about alternatives.
Desupported Features
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
Changes in Oracle Database 12c Release 1 (12.1.0.2)
The following are changes in Oracle Database Reference for Oracle Database 12c Release 1 (12.1.0.2).
New Features
-
The following initialization parameters are new in Oracle Database 12c Release 1 (12.1.0.2):
- COMMON_USER_PREFIX
- DB_BIG_TABLE_CACHE_PERCENT_TARGET
- DBFIPS_140
- ENABLE_GOLDENGATE_REPLICATIONFoot 1
- INMEMORY_CLAUSE_DEFAULT
- INMEMORY_FORCE
- INMEMORY_MAX_POPULATE_SERVERS
- INMEMORY_QUERY
- INMEMORY_SIZE
- INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
- OPTIMIZER_INMEMORY_AWARE
See 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_ZONEMAP_MEASURES, DBA_ZONEMAP_MEASURES, and USER_ZONEMAP_MEASURES
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_TEMPS
-
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_USER_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:
GV$ Views and Dynamic Performance Views for more information about these dynamic performance views
-
Deprecated Features
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.
Changes in Oracle Database 12c Release 1 (12.1.0.1)
The following are changes in Oracle Database Reference for Oracle Database 12c Release 1 (12.1.0.1).
New Features
-
The following initialization parameters are new in Oracle Database 12c Release 1 (12.1.0.1):
- CONNECTION_BROKERS
- DNFS_BATCH_SIZE
- ENABLE_PLUGGABLE_DATABASE
- HEAT_MAP
- MAX_STRING_SIZE
- OPTIMIZER_ADAPTIVE_REPORTING_ONLY
- PDB_FILE_NAME_CONVERT
- PGA_AGGREGATE_LIMIT
- PROCESSOR_GROUP_NAME
- NONCDB_COMPATIBLE
- SPATIAL_VECTOR_ACCELERATION
- TEMP_UNDO_ENABLED
- THREADED_EXECUTION
- UNIFIED_AUDIT_SGA_QUEUE_SIZE
- USE_DEDICATED_BROKER
See 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_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_GOLDENGATE_PRIVILEGES, DBA_GOLDENGATE_PRIVILEGES, and USER_GOLDENGATE_PRIVILEGES
-
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_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_OUT_SUPPORT_MODE and DBA_XSTREAM_OUT_SUPPORT_MODE
-
DBA_ILMDATAMOVEMENTPOLICIES and USER_ILMDATAMOVEMENTPOLICIES
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$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:
GV$ Views and Dynamic Performance Views for more information about these dynamic performance views
-
Deprecated Features
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).