Changes in This Release for Oracle Database Reference

This preface lists changes in Oracle Database Reference:

• Changes in Oracle Database 18c

• 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 18c

This section lists changes in Oracle Database Reference for Oracle Database 18c.

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 18c.

The following initialization parameters are new in Oracle Database 18c:

• ADG_ACCOUNT_INFO_TRACKING

• FORWARD_LISTENER

• INMEMORY_AUTOMATIC_LEVEL

• INMEMORY_OPTIMIZED_ARITHMETIC

• MEMOPTIMIZE_POOL_SIZE

• MULTISHARD_QUERY_DATA_CONSISTENCY

• OPTIMIZER_IGNORE_HINTS

• OPTIMIZER_IGNORE_PARALLEL_HINTS

• PARALLEL_MIN_DEGREE

• PRIVATE_TEMP_TABLE_PREFIX

• STANDBY_PDB_SOURCE_FILE_DBLINK

• STANDBY_PDB_SOURCE_FILE_DIRECTORY

• TDE_CONFIGURATION

• UNIFIED_AUDIT_SYSTEMLOG

• WALLET_ROOT

See Also:

Initialization Parameters for more information about these initialization parameters

The following static data dictionary views are new in Oracle Database 18c:

• ALL_JSON_DATAGUIDE_FIELDS, DBA_JSON_DATAGUIDE_FIELDS, and USER_JSON_DATAGUIDE_FIELDS

• ALL_MINING_ALGORITHMS

• DBA_CONNECTION_TESTS

• DBA_HIST_PROCESS_WAITTIME

• DBA_INMEMORY_AIMTASKDETAILS

• DBA_INMEMORY_AIMTASKS

• DBA_PDB_SNAPSHOTS

• DBA_PRIVATE_TEMP_TABLES and USER_PRIVATE_TEMP_TABLES

• DBA_WORKLOAD_DIV_SUMMARY

• DICTIONARY_CREDENTIALS_ENCRYPT

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 18c:

• 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$ASM_DBCLONE_INFO and V$ASM_DBCLONE_INFO

• 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 18c, and may be desupported in a future release.

• The MAX_CONNECTIONS attribute of the LOG_ARCHIVE_DEST_n parameter for Data Guard redo transport

Desupported Features

The following features are desupported in Oracle Database 18c:

• The STANDBY_ARCHIVE_DEST initialization parameter

• The UTL_FILE_DIR initialization parameter

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

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