Changes in This Release for Oracle Database Reference

This preface lists changes in Oracle Database Reference:

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 this release:

    • 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 this release, 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 this release:

    • 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 this release, 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).