Changes in This Release for Oracle Database Reference

This preface lists changes in Oracle Database Reference:

• Changes in Oracle Database 12c Release 2 (12.2.0.1)

• Changes in Oracle Database 12c Release 1 (12.1.0.2)

• Changes in Oracle Database 12c Release 1 (12.1.0.1)

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):

• 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

The following static data dictionary views are new in this release:

• 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_GG_AUTO_CDR_COLUMN_GROUPS, DBA_GG_AUTO_CDR_COLUMN_GROUPS, and USER_GG_AUTO_CDR_COLUMN_GROUPS

• ALL_GG_AUTO_CDR_COLUMNS, DBA_GG_AUTO_CDR_COLUMNS, and USER_GG_AUTO_CDR_COLUMNS

• ALL_GG_AUTO_CDR_TABLES, DBA_GG_AUTO_CDR_TABLES, and USER_GG_AUTO_CDR_TABLES

• 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

The following dynamic performance views are new in this release:

• 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

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

  See "UTL_FILE_DIR" for information about alternatives.

• 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_REPLICATION^Foot 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_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

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_FEATURES
  • 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_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

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).