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:

    Part I, "Initialization Parameters" for more information about these initialization parameters
  • The following static data dictionary views are new in this release:

    ALL_ Views DBA_ Views USER_ Views
    ALL_CLUSTERING_DIMENSIONS DBA_CLUSTERING_DIMENSIONS USER_CLUSTERING_DIMENSIONS
    ALL_CLUSTERING_JOINS DBA_CLUSTERING_JOINS USER_CLUSTERING_JOINS
    ALL_CLUSTERING_KEYS DBA_CLUSTERING_KEYS USER_CLUSTERING_KEYS
    ALL_CLUSTERING_TABLES DBA_CLUSTERING_TABLES USER_CLUSTERING_TABLES
    ALL_JSON_COLUMNS DBA_JSON_COLUMNS USER_JSON_COLUMNS
    ALL_ZONEMAP_MEASURES DBA_ZONEMAP_MEASURES USER_ZONEMAP_MEASURES
    ALL_ZONEMAPS DBA_ZONEMAPS USER_ZONEMAPS
      DBA_HIST_IM_SEG_STAT  
      DBA_HIST_IM_SEG_STAT_OBJ  
      DBA_PDB_SAVED_STATES  
      DBA_ROLLING_UNSUPPORTED  

    See Also:

    Part II, "Static Data Dictionary Views" for more information about these static data dictionary views
  • The following dynamic performance views are new in this release:

    GV$ Views V$ Views
    GV$BT_SCAN_CACHE V$BT_SCAN_CACHE
    GV$BT_SCAN_OBJ_TEMP V$BT_SCAN_OBJ_TEMP
    GV$EMX_USAGE_STATS V$EMX_USAGE_STATS
    GV$EVENT_HISTOGRAM_MICRO V$EVENT_HISTOGRAM_MICRO
    GV$FS_OBSERVER_HISTOGRAMFoot 1  V$FS_OBSERVER_HISTOGRAMFootref 1
    GV$IM_COLUMN_LEVEL V$IM_COLUMN_LEVEL
    GV$IM_SEGMENTS V$IM_SEGMENTS
    GV$IM_USER_SEGMENTS V$IM_USER_SEGMENTS
    GV$INMEMORY_AREA V$INMEMORY_AREA
    GV$KEY_VECTOR V$KEY_VECTOR

    Footnote 1 This view 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).

    See Also:

    Part III, "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:

    Part I, "Initialization Parameters" for more information about these initialization parameters
  • The following static data dictionary views are new in this release:

    ALL_ Views DBA_ Views USER_ Views
    ALL_APPLY_INSTANTIATED_GLOBAL DBA_APPLY_INSTANTIATED_GLOBAL  
    ALL_APPLY_INSTANTIATED_OBJECTS DBA_APPLY_INSTANTIATED_OBJECTS  
    ALL_APPLY_INSTANTIATED_SCHEMAS DBA_APPLY_INSTANTIATED_SCHEMAS  
    ALL_ATTRIBUTE_TRANSFORMATIONS DBA_ATTRIBUTE_TRANSFORMATIONS USER_ATTRIBUTE_TRANSFORMATIONS
    ALL_CODE_ROLE_PRIVS DBA_CODE_ROLE_PRIVS USER_CODE_ROLE_PRIVS
    ALL_CREDENTIALS DBA_CREDENTIALS USER_CREDENTIALS
    ALL_CUBE_NAMED_BUILD_SPECS DBA_CUBE_NAMED_BUILD_SPECS USER_CUBE_NAMED_BUILD_SPECS
    ALL_CUBE_SUB_PARTITION_LEVELS DBA_CUBE_SUB_PARTITION_LEVELS USER_CUBE_SUB_PARTITION_LEVELS
    ALL_ERROR_TRANSLATIONS DBA_ERROR_TRANSLATIONS USER_ERROR_TRANSLATIONS
    ALL_GG_INBOUND_PROGRESS DBA_GG_INBOUND_PROGRESS  
    ALL_GOLDENGATE_INBOUND DBA_GOLDENGATE_INBOUND  
    ALL_GOLDENGATE_PRIVILEGES DBA_GOLDENGATE_PRIVILEGES USER_GOLDENGATE_PRIVILEGES
    ALL_GOLDENGATE_RULES DBA_GOLDENGATE_RULES  
    ALL_HEAT_MAP_SEG_HISTOGRAM DBA_HEAT_MAP_SEG_HISTOGRAM USER_HEAT_MAP_SEG_HISTOGRAM
    ALL_HEAT_MAP_SEGMENT DBA_HEAT_MAP_SEGMENT USER_HEAT_MAP_SEGMENT
    ALL_MEASURE_FOLDER_SUBFOLDERS DBA_MEASURE_FOLDER_SUBFOLDERS USER_MEASURE_FOLDER_SUBFOLDERS
    ALL_METADATA_PROPERTIES DBA_METADATA_PROPERTIES USER_METADATA_PROPERTIES
    ALL_PLSQL_COLL_TYPES DBA_PLSQL_COLL_TYPES USER_PLSQL_COLL_TYPES
    ALL_PLSQL_TYPE_ATTRS DBA_PLSQL_TYPE_ATTRS USER_PLSQL_TYPE_ATTRS
    ALL_PLSQL_TYPES DBA_PLSQL_TYPES USER_PLSQL_TYPES
    ALL_POLICY_ATTRIBUTES DBA_POLICY_ATTRIBUTES USER_POLICY_ATTRIBUTES
    ALL_SQL_TRANSLATION_PROFILES DBA_SQL_TRANSLATION_PROFILES USER_SQL_TRANSLATION_PROFILES
    ALL_SQL_TRANSLATIONS DBA_SQL_TRANSLATIONS USER_SQL_TRANSLATIONS
    ALL_TAB_IDENTITY_COLS DBA_TAB_IDENTITY_COLS USER_TAB_IDENTITY_COLS
    ALL_TRANSFORMATIONS DBA_TRANSFORMATIONS USER_TRANSFORMATIONS
    ALL_XML_NESTED_TABLES DBA_XML_NESTED_TABLES USER_XML_NESTED_TABLES
    ALL_XML_OUT_OF_LINE_TABLES DBA_XML_OUT_OF_LINE_TABLES USER_XML_OUT_OF_LINE_TABLES
    ALL_XML_SCHEMA_ATTRIBUTES DBA_XML_SCHEMA_ATTRIBUTES USER_XML_SCHEMA_ATTRIBUTES
    ALL_XML_SCHEMA_COMPLEX_TYPES DBA_XML_SCHEMA_COMPLEX_TYPES USER_XML_SCHEMA_COMPLEX_TYPES
    ALL_XML_SCHEMA_ELEMENTS DBA_XML_SCHEMA_ELEMENTS USER_XML_SCHEMA_ELEMENTS
    ALL_XML_SCHEMA_NAMESPACES DBA_XML_SCHEMA_NAMESPACES USER_XML_SCHEMA_NAMESPACES
    ALL_XML_SCHEMA_SIMPLE_TYPES DBA_XML_SCHEMA_SIMPLE_TYPES USER_XML_SCHEMA_SIMPLE_TYPES
    ALL_XML_SCHEMA_SUBSTGRP_HEAD DBA_XML_SCHEMA_SUBSTGRP_HEAD USER_XML_SCHEMA_SUBSTGRP_HEAD
    ALL_XML_SCHEMA_SUBSTGRP_MBRS DBA_XML_SCHEMA_SUBSTGRP_MBRS USER_XML_SCHEMA_SUBSTGRP_MBRS
    ALL_XSTREAM_ADMINISTRATOR DBA_XSTREAM_ADMINISTRATOR  
    ALL_XSTREAM_OUT_SUPPORT_MODE DBA_XSTREAM_OUT_SUPPORT_MODE  
    ALL_XSTREAM_TRANSFORMATIONS 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 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 USER_HOST_ACES
      DBA_HOST_ACLS  
      DBA_ILMDATAMOVEMENTPOLICIES USER_ILMDATAMOVEMENTPOLICIES
      DBA_ILMEVALUATIONDETAILS USER_ILMEVALUATIONDETAILS
      DBA_ILMOBJECTS USER_ILMOBJECTS
      DBA_ILMPARAMETERS  
      DBA_ILMPOLICIES USER_ILMPOLICIES
      DBA_ILMRESULTS USER_ILMRESULTS
      DBA_ILMTASKS 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 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 USER_SR_GRP_STATUS
      DBA_SR_GRP_STATUS_ALL USER_SR_GRP_STATUS_ALL
      DBA_SR_OBJ USER_SR_OBJ
      DBA_SR_OBJ_ALL USER_SR_OBJ_ALL
      DBA_SR_OBJ_STATUS USER_SR_OBJ_STATUS
      DBA_SR_OBJ_STATUS_ALL USER_SR_OBJ_STATUS_ALL
      DBA_SR_PARTN_OPS USER_SR_PARTN_OPS
      DBA_SR_STLOG_EXCEPTIONS USER_SR_STLOG_EXCEPTIONS
      DBA_SR_STLOG_STATS 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 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:

    Part II, "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$ Views V$ Views
    GV$AQ_BACKGROUND_COORDINATOR V$AQ_BACKGROUND_COORDINATOR
    GV$AQ_BMAP_NONDUR_SUBSCRIBERS V$AQ_BMAP_NONDUR_SUBSCRIBERS
    GV$AQ_CROSS_INSTANCE_JOBS V$AQ_CROSS_INSTANCE_JOBS
    GV$AQ_JOB_COORDINATOR V$AQ_JOB_COORDINATOR
    GV$AQ_NONDUR_REGISTRATIONS V$AQ_NONDUR_REGISTRATIONS
    GV$AQ_NONDUR_SUBSCRIBER V$AQ_NONDUR_SUBSCRIBER
    GV$AQ_NONDUR_SUBSCRIBER_LWM V$AQ_NONDUR_SUBSCRIBER_LWM
    GV$AQ_NOTIFICATION_CLIENTS V$AQ_NOTIFICATION_CLIENTS
    GV$AQ_SERVER_POOL V$AQ_SERVER_POOL
    GV$AQ_SUBSCRIBER_LOAD V$AQ_SUBSCRIBER_LOAD
    GV$ASM_ACFS_SEC_ADMIN V$ASM_ACFS_SEC_ADMIN
    GV$ASM_ACFS_SEC_CMDRULE V$ASM_ACFS_SEC_CMDRULE
    GV$ASM_ACFS_SEC_REALM V$ASM_ACFS_SEC_REALM
    GV$ASM_ACFS_SEC_REALM_FILTER V$ASM_ACFS_SEC_REALM_FILTER
    GV$ASM_ACFS_SEC_REALM_GROUP V$ASM_ACFS_SEC_REALM_GROUP
    GV$ASM_ACFS_SEC_REALM_USER V$ASM_ACFS_SEC_REALM_USER
    GV$ASM_ACFS_SEC_RULE V$ASM_ACFS_SEC_RULE
    GV$ASM_ACFS_SEC_RULESET V$ASM_ACFS_SEC_RULESET
    GV$ASM_ACFS_SEC_RULESET_RULE V$ASM_ACFS_SEC_RULESET_RULE
    GV$ASM_ACFSREPL V$ASM_ACFSREPL
    GV$ASM_ACFSREPLTAG V$ASM_ACFSREPLTAG
    GV$ASM_ACFSTAG V$ASM_ACFSTAG
    GV$ASM_ESTIMATE V$ASM_ESTIMATE
    GV$BACKUP_NONLOGGED V$BACKUP_NONLOGGED
    GV$CLIENT_SECRETS V$CLIENT_SECRETS
    GV$CLONEDFILE V$CLONEDFILE
    GV$CON_SYS_TIME_MODEL V$CON_SYS_TIME_MODEL
    GV$CON_SYSSTAT V$CON_SYSSTAT
    GV$CON_SYSTEM_EVENT V$CON_SYSTEM_EVENT
    GV$CON_SYSTEM_WAIT_CLASS V$CON_SYSTEM_WAIT_CLASS
    GV$CONTAINERS V$CONTAINERS
    GV$COPY_NONLOGGED V$COPY_NONLOGGED
    GV$DEAD_CLEANUP V$DEAD_CLEANUP
    GV$DG_BROKER_CONFIG V$DG_BROKER_CONFIG
    GV$EDITIONABLE_TYPES V$EDITIONABLE_TYPES
    GV$ENCRYPTION_KEYS V$ENCRYPTION_KEYS
    GV$FLASHFILESTAT V$FLASHFILESTAT
    GV$GG_APPLY_COORDINATOR V$GG_APPLY_COORDINATOR
    GV$GG_APPLY_READER V$GG_APPLY_READER
    GV$GG_APPLY_SERVER V$GG_APPLY_SERVER
    GV$GOLDENGATE_CAPTURE V$GOLDENGATE_CAPTURE
    GV$GOLDENGATE_MESSAGE_TRACKING V$GOLDENGATE_MESSAGE_TRACKING
    GV$GOLDENGATE_TABLE_STATS V$GOLDENGATE_TABLE_STATS
    GV$GOLDENGATE_TRANSACTION V$GOLDENGATE_TRANSACTION
    GV$HEAT_MAP_SEGMENT V$HEAT_MAP_SEGMENT
    GV$INSTANCE_PING V$INSTANCE_PING
    GV$IO_OUTLIER V$IO_OUTLIER
    GV$LGWRIO_OUTLIER V$LGWRIO_OUTLIER
    GV$MAPPED_SQL V$MAPPED_SQL
    GV$NONLOGGED_BLOCK V$NONLOGGED_BLOCK
    GV$OPTIMIZER_PROCESSING_RATE V$OPTIMIZER_PROCESSING_RATE
    GV$PATCHES V$PATCHES
    GV$PDB_INCARNATION V$PDB_INCARNATION
    GV$PDBS V$PDBS
    GV$SESSIONS_COUNT V$SESSIONS_COUNT
    GV$RO_USER_ACCOUNT V$RO_USER_ACCOUNT
    GV$SQL_MONITOR_SESSTAT V$SQL_MONITOR_SESSTAT
    GV$SQL_MONITOR_STATNAME V$SQL_MONITOR_STATNAME
    GV$TEMPUNDOSTAT V$TEMPUNDOSTAT
    GV$XSTREAM_APPLY_COORDINATOR V$XSTREAM_APPLY_COORDINATOR
    GV$XSTREAM_APPLY_READER V$XSTREAM_APPLY_READER
    GV$XSTREAM_APPLY_SERVER V$XSTREAM_APPLY_SERVER
    GV$XSTREAM_TABLE_STATS V$XSTREAM_TABLE_STATS

    See Also:

    Part III, "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:



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