All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

12c Database : New Parameters in place

The following are the parameters are introduced newly in 12c. (Note I have compared them with 11.2.0.1 Database)

Excluded _Parameters

select KSPPINM, KSPPDESC from x$ksppi where con_id=1
minus
select KSPPINM, KSPPDESC from t2@Geek DBA11g
order by 1,2

awr_snapshot_time_offset                  Setting for AWR Snapshot Time Offset
cell_offloadgroup_name                    Set the offload group name
clonedb                                   clone database
connection_brokers                        connection brokers specification
cursor_bind_capture_destination           Allowed destination for captured bind variables
db_big_table_cache_percent_target         Big table cache target size in percentage
db_index_compression_inheritance          options for table or tablespace level compression inheritance
db_unrecoverable_scn_tracking             Track nologging SCN in controlfile
dnfs_batch_size                           Max number of dNFS asynch I/O requests queued per session
enable_pluggable_database                 Enable Pluggable Database
heat_map                                  ILM Heatmap Tracking
max_string_size                           controls maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL
nls_timestamp_tz_format                   timestamp with timezone format
noncdb_compatible                         Non-CDB Compatible
optimizer_adaptive_features               controls adaptive features
optimizer_adaptive_reporting_only         use reporting-only mode for adaptive optimizations
parallel_degree_level                     adjust the computed degree in percentage
parallel_degree_policy                    policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO/ADAPTIVE)
parallel_fault_tolerance_enabled          enables or disables fault-tolerance for parallel statement
pdb_file_name_convert                     PDB file name convert patterns and strings for create cdb/pdb
pga_aggregate_limit                       limit of aggregate PGA memory consumed by the instance
processor_group_name                      Name of the processor group that this instance should run in.
spatial_vector_acceleration               enable spatial vector acceleration
temp_undo_enabled                         is temporary undo enabled
threaded_execution                        Threaded Execution Mode
unified_audit_sga_queue_size              Size of Unified audit SGA Queue
use_dedicated_broker                      Use dedicated connection broker
use_large_pages                           Use large pages if available (TRUE/FALSE/ONLY)

-Thanks

Geek DBA

Comments are closed.