+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Blog

    • Home
    • Blog
    • 12cR2 lots of new instance parameters

    12cR2 lots of new instance parameters

    • Posted by John Watson
    • Categories Blog, RDBMS Server
    • Date April 12, 2017

    Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters:

    adg_imc_enabled                               TRUE                 Enable IMC support on ADG                                                                                                  
    allow_global_dblinks                          FALSE                LDAP lookup for DBLINKS                                                                                                    
    allow_group_access_to_sga                     FALSE                Allow read access for SGA to users of Oracle owner group                                                                   
    approx_for_aggregation                        FALSE                Replace exact aggregation with approximate aggregation                                                                     
    approx_for_count_distinct                     FALSE                Replace count distinct with approx_count_distinct                                                                          
    approx_for_percentile                         none                 Replace percentile_* with approx_percentile                                                                                
    asm_io_processes                              0                    number of I/O processes per domain in the ASM IOSERVER instance                                                            
    cdb_cluster                                   FALSE                if TRUE startup in CDB Cluster mode                                                                                        
    cdb_cluster_name                              cfcdba1              CDB Cluster name                                                                                                           
    clonedb_dir                                                        CloneDB Directory                                                                                                          
    containers_parallel_degree                    65535                Parallel degree for a CONTAINERS() query                                                                                   
    cursor_invalidation                           IMMEDIATE            default for DDL cursor invalidation semantics                                                                              
    data_guard_sync_latency                       0                    Data Guard SYNC latency                                                                                                    
    data_transfer_cache_size                      0                    Size of data transfer cache                                                                                                
    default_sharing                               metadata             Default sharing clause                                                                                                     
    disable_pdb_feature                           0                    Disable features                                                                                                           
    enable_dnfs_dispatcher                        FALSE                Enable DNFS Dispatcher                                                                                                     
    enable_pdb_isolation                          FALSE                Enables Pluggable Database isolation inside a CDB                                                                          
    enabled_PDBs_on_standby                       *                    List of Enabled PDB patterns                                                                                               
    encrypt_new_tablespaces                       ALWAYS               whether to encrypt newly created tablespaces                                                                               
    external_keystore_credential_location         +DATA/wallets/tde/us external keystore credential location                                                                                      
    inmemory_expressions_capture                  DISABLE              Controls detection of frequently used costly expressions                                                                   
    inmemory_expressions_usage                    ENABLE               Controls which In-Memory Expressions are populated in-memory                                                               
    inmemory_virtual_columns                      ENABLE               Controls which user-defined virtual columns are stored in-memory                                                           
    instance_abort_delay_time                     0                    time to delay an internal initiated abort (in seconds)                                                                     
    instance_mode                                 READ-WRITE           indicates whether the instance read-only or read-write or read-mostly                                                      
    long_module_action                            TRUE                 Use longer module and action                                                                                               
    max_idle_time                                 60                   maximum session idle time in minutes                                                                                       
    max_iops                                      0                    MAX IO per second                                                                                                          
    max_mbps                                      0                    MAX MB per second                                                                                                          
    ofs_threads                                   4                    Number of OFS threads                                                                                                      
    one_step_plugin_for_pdb_with_tde              FALSE                Facilitate one-step plugin for PDB with TDE encrypted data                                                                 
    optimizer_adaptive_plans                      TRUE                 controls all types of adaptive plans                                                                                       
    optimizer_adaptive_statistics                 FALSE                controls all types of adaptive statistics                                                                                  
    outbound_dblink_protocols                     ALL                  Outbound DBLINK Protocols allowed                                                                                          
    pga_aggregate_xmem_limit                      0                    limit of aggregate PGA XMEM memory consumed by the instance                                                                
    remote_recovery_file_dest                                          default remote database recovery file location for refresh/relocate                                                        
    sec_protocol_allow_deprecated_rpcs            YES                  Allow deprecated TTC RPCs                                                                                                  
    standby_db_preserve_states                    NONE                 Preserve state cross standby role transition                                                                               
    target_pdbs                                   525                  Parameter is a hint to adjust certain attributes of the CDB                                                                
    uniform_log_timestamp_format                  TRUE                 use uniform timestamp formats vs pre-12.2 formats

    A lot of them are to do with Multitenant. The others? Well, some are fairly obvious, some used to be _underscore parameters. As for the others, I’ll have to wait until I can study the docs.

    —
    John Watson
    Oracle Certified Master DBA
    https://skillbuilders.com

    • Share:
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Previous post

    Tuning with equivalent SQLs - a little challenge
    April 12, 2017

    Next post

    Oracle Database Manager, a Free Management Tool
    27 April, 2017

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.