1. Database Reference
  2. Changes in This Release for Oracle Database Reference

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)

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