Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-13
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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