12.2新增的46个参数:
Parameter (Description)
[url=http://docs.oracle.com/database/122/REFRN/ALLOW_GLOBAL_DBLINKS.htm#REFRN-GUID-854693F5-87F6-46FB-A656-F6DAC3524BA2]allow_global_dblinks[/url] (LDAP lookup for DBLINKS)
[url=http://docs.oracle.com/database/122/REFRN/ALLOW_GROUP_ACCESS_TO_SGA.htm#REFRN-GUID-A6BABC97-7EF8-4E1A-89C9-CF81EDCFB4A2]allow_group_access_to_sga[/url] (Allow read access for SGA to users of Oracle owner group)
[url=http://docs.oracle.com/database/122/REFRN/APPROX_FOR_AGGREGATION.htm#REFRN-GUID-46853DF9-7688-46C7-A5BA-308B9B2DAF67]approx_for_aggregation[/url] (Replace exact aggregation with approximate aggregation)
[url=http://docs.oracle.com/database/122/REFRN/APPROX_FOR_COUNT_DISTINCT.htm#REFRN-GUID-D2A8A53F-113A-4E6F-AC2E-37139460EF8D]approx_for_count_distinct[/url] (Replace count distinct with approx_count_distinct)
[url=http://docs.oracle.com/database/122/REFRN/APPROX_FOR_PERCENTILE.htm#REFRN-GUID-3872A78C-9B3F-457C-AD28-4E86F71AE74D]approx_for_percentile[/url] (Replace percentile_* with approx_percentile)
[url=http://docs.oracle.com/database/122/REFRN/ASM_IO_PROCESSES.htm#REFRN-GUID-25CB85C7-6371-4AEC-A79F-2DC1E0D4370D]asm_io_processes[/url] (number of I/O processes per domain in the ASM IOSERVER instance)
[url=http://docs.oracle.com/database/122/REFRN/AUTOTASK_MAX_ACTIVE_PDBS.htm#REFRN-GUID-5DC631A2-4CDD-4C1F-B337-184BFD4C29B8]autotask_max_active_pdbs[/url] (Setting for Autotask Maximum Maintenance PDBs)
[url=http://docs.oracle.com/database/122/REFRN/AWR_PDB_AUTOFLUSH_ENABLED.htm#REFRN-GUID-08FA21BC-8FB1-4C51-BEEA-139C734D17A7]awr_pdb_autoflush_enabled[/url] (Enable/Disable AWR automatic PDB flushing)
cdb_cluster [undocumented] (if TRUE startup in CDB Cluster mode)
cdb_cluster_name [undocumented] (CDB Cluster name)
[url=http://docs.oracle.com/database/122/REFRN/CLONEDB_DIR.htm#REFRN-GUID-34FD869A-CECA-4D12-9143-0ACE3AA73AFD]clonedb_dir[/url] (CloneDB Directory)
[url=http://docs.oracle.com/database/122/REFRN/CONTAINERS_PARALLEL_DEGREE.htm#REFRN-GUID-17F470E8-4C0D-43C8-AD2F-376B1503BCF6]containers_parallel_degree[/url] (Parallel degree for a CONTAINERS() query)
[url=http://docs.oracle.com/database/122/REFRN/CURSOR_INVALIDATION.htm#REFRN-GUID-6BAB61E7-FABA-41D3-B73A-EB828A6767E5]cursor_invalidation[/url] (default for DDL cursor invalidation semantics)
[url=http://docs.oracle.com/database/122/REFRN/DATA_GUARD_SYNC_LATENCY.htm#REFRN-GUID-A0965F0B-608C-4B68-85D1-9F14EFC191CC]data_guard_sync_latency[/url] (Data Guard SYNC latency)
[url=http://docs.oracle.com/database/122/REFRN/DATA_TRANSFER_CACHE_SIZE.htm#GUID-322093B7-1673-490D-8A1A-5F461D7897DD]data_transfer_cache_size[/url] (Size of data transfer cache)
[url=http://docs.oracle.com/database/122/REFRN/DEFAULT_SHARING.htm#REFRN-GUID-15D1391E-7FAB-46A8-9F1F-9F59045B71EC]default_sharing[/url] (Default sharing clause)
disable_pdb_feature [undocumented] (Disable features)
[url=http://docs.oracle.com/database/122/REFRN/ENABLE_AUTOMATIC_MAINTENANCE_PDB.htm#REFRN-GUID-3ACE01FA-8342-4F35-94BB-955412B9C76A]enable_automatic_maintenance_pdb[/url] (Enable/Disable Automated Maintenance for Non-Root PDB)
[url=http://docs.oracle.com/database/122/REFRN/ENABLE_DNFS_DISPATCHER.htm#REFRN-GUID-2209E40B-1280-4C38-ADD8-324EAACF3501]enable_dnfs_dispatcher[/url] (Enable DNFS Dispatcher)
[url=http://docs.oracle.com/database/122/REFRN/ENABLED_PDBS_ON_STANDBY.htm#REFRN-GUID-A2EC2381-D9C0-4612-87C9-A225C7BCE8C4]enabled_PDBs_on_standby[/url] (List of Enabled PDB patterns)
[url=http://docs.oracle.com/database/122/REFRN/ENCRYPT_NEW_TABLESPACES.htm#REFRN-GUID-44EF2AAC-1313-4437-B0F3-A427F45016F2]encrypt_new_tablespaces[/url] (whether to encrypt newly created tablespaces)
[url=http://docs.oracle.com/database/122/REFRN/EXAFUSION_ENABLED.htm#REFRN-GUID-A0612249-0A65-476D-A2B8-FA94DF5EEC7F]exafusion_enabled[/url] (Enable Exafusion)
[url=http://docs.oracle.com/database/122/REFRN/EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION.htm#REFRN-GUID-FD2C1839-E3CC-47E2-99B4-ECE29EB923B6]external_keystore_credential_location[/url] (external keystore credential location)
[url=http://docs.oracle.com/database/122/REFRN/INMEMORY_ADG_ENABLED.htm#REFRN-GUID-74F7324A-6067-4B7A-9D72-3046DDE70D0A]inmemory_adg_enabled[/url] (Enable IMC support on ADG)
[url=http://docs.oracle.com/database/122/REFRN/INMEMORY_EXPRESSIONS_USAGE.htm#GUID-9B926459-CA8A-4843-B9A1-4DE6F630EB45]inmemory_expressions_usage[/url] (Controls which In-Memory Expressions are populated in-memory)
[url=http://docs.oracle.com/database/122/REFRN/INMEMORY_VIRTUAL_COLUMNS.htm#GUID-1B066B16-4F22-4D9D-9D82-AF7B786DB97E]inmemory_virtual_columns[/url] (Controls which user-defined virtual columns are stored in-memory)
[url=http://docs.oracle.com/database/122/REFRN/INSTANCE_ABORT_DELAY_TIME.htm#GUID-F15A6EC9-1F4F-4DB7-9981-FFC1F181559F]instance_abort_delay_time[/url] (time to delay an internal initiated abort (in seconds))
[url=http://docs.oracle.com/database/122/REFRN/INSTANCE_MODE.htm#GUID-77461EFC-0925-4511-AD4C-426CF842B4FD]instance_mode[/url] (indicates whether the instance read-only or read-write or read-mostly)
[url=http://docs.oracle.com/database/122/REFRN/LONG_MODULE_ACTION.htm#GUID-DA943655-E516-44A3-8D11-A86E5EF5F585]long_module_action[/url] (Use longer module and action)
[url=http://docs.oracle.com/database/122/REFRN/MAX_DATAPUMP_JOBS_PER_PDB.htm#GUID-E911645F-2CA4-447D-AFB7-EBD4753AA09F]max_datapump_jobs_per_pdb[/url] (maximum number of concurrent Data Pump Jobs per PDB)
[url=http://docs.oracle.com/database/122/REFRN/MAX_IDLE_TIME.htm#GUID-9E26A81D-D99E-4EA8-88DE-77AF68482A20]max_idle_time[/url] (maximum session idle time in minutes)
[url=http://docs.oracle.com/database/122/REFRN/MAX_IOPS.htm#GUID-7D89F457-0CE6-4152-98EA-7F1BE4E0ADC7]max_iops[/url] (MAX IO per second)
[url=http://docs.oracle.com/database/122/REFRN/MAX_MBPS.htm#REFRN-GUID-9F7E0143-76FB-488A-9A04-2D85F1417CB6]max_mbps[/url] (MAX MB per second)
[url=http://docs.oracle.com/database/122/REFRN/MAX_PDBS.htm#GUID-55526BAC-DCB2-4C76-9ACF-1E3D2047E267]max_pdbs[/url] (max number of pdbs allowed in CDB or Application ROOT)
[url=http://docs.oracle.com/database/122/REFRN/OFS_THREADS.htm#GUID-76B8B306-C8DC-414B-9491-65532D696E46]ofs_threads[/url] (Number of OFS threads)
one_step_plugin_for_pdb_with_tde [undocumented] (Facilitate one-step plugin for PDB with TDE encrypted data)
[url=http://docs.oracle.com/database/122/REFRN/OPTIMIZER_ADAPTIVE_PLANS.htm#GUID-58C3E867-36BA-449A-B452-4E90FE6DCF05]optimizer_adaptive_plans[/url] (controls all types of adaptive plans)
[url=http://docs.oracle.com/database/122/REFRN/OPTIMIZER_ADAPTIVE_STATISTICS.htm#GUID-D52B4342-3887-4054-A65C-5AEA83F69E35]optimizer_adaptive_statistics[/url] (controls all types of adaptive statistics)
[url=http://docs.oracle.com/database/122/REFRN/OUTBOUND_DBLINK_PROTOCOLS.htm#GUID-4E760A19-5791-4E2D-8792-016B7B6D10D6]outbound_dblink_protocols[/url] (Outbound DBLINK Protocols allowed)
[url=http://docs.oracle.com/database/122/REFRN/REMOTE_RECOVERY_FILE_DEST.htm#GUID-CF179320-40F2-4000-AF2F-9226738B472B]remote_recovery_file_dest[/url] (default remote database recovery file location for refresh/relocate)
[url=http://docs.oracle.com/database/122/REFRN/RESOURCE_MANAGE_GOLDENGATE.htm#GUID-389AB551-F4EB-4294-BD52-5E5E41AFDA80]resource_manage_goldengate[/url] (goldengate resource manager enabled)
[url=http://docs.oracle.com/database/122/REFRN/SGA_MIN_SIZE.htm#REFRN-GUID-560759EC-504D-4658-8DE6-EA808331B303]sga_min_size[/url] (Minimum, guaranteed size of PDB's SGA)
[url=http://docs.oracle.com/database/122/REFRN/SHRD_DUPL_TABLE_REFRESH_RATE.htm#GUID-074CDADE-71CE-4EA6-BC3C-EE165284C0AC]shrd_dupl_table_refresh_rate[/url] (duplicated table refresh rate (in seconds)
[url=http://docs.oracle.com/database/122/REFRN/STANDBY_DB_PRESERVE_STATES.htm#GUID-8D332556-30B7-4C45-8557-50988DC2219E]standby_db_preserve_states[/url] (Preserve state cross standby role transition)
target_pdbs [undocumented] (Parameter is a hint to adjust certain attributes of the CDB)
[url=http://docs.oracle.com/database/122/REFRN/UNIFORM_LOG_TIMESTAMP_FORMAT.htm#GUID-041BC204-EA0E-4260-9726-D25C2C86A2F5]uniform_log_timestamp_format[/url] (use uniform timestamp formats vs pre-12.2 formats)
废弃的159个参数:
[code]SQL> select name from V$OBSOLETE_PARAMETER order by 1;
NAME
----------------------------------------------------------------
_app_ctx_vers
_average_dirties_half_life
_aw_row_source_enabled
_compatible_no_recovery
_data_transfer_cache_size
_db_no_mount_lock
_dlm_send_timeout
_dtree_bintest_id
_dtree_compressbmp_enabled
_evolve_plan_baseline_report_level
_fast_start_instance_recovery_target
_fic_max_length
_fic_outofmem_candidates
_idl_conventional_index_maintenance
_kgl_latch_count
_kks_free_cursor_stat_pct
_kspptbl_mem_usage
_lm_direct_sends
_lm_multiple_receivers
_lm_rcv_buffer_size
_lm_statistics
_log_archive_buffer_size
_log_io_size
_max_log_write_io_parallelism
_module_action_old_length
_optimizer_adaptive_plans
_optimizer_choose_permutation
_oracle_trace_events
_oracle_trace_facility_version
_plan_verify_local_time_limit
_plsql_conditional_compilation
_px_async_getgranule
_px_slaves_share_cursors
_seq_process_cache_const
_spr_use_hash_table
_sqlexec_progression_cost
_use_hidden_partitions
_very_large_partitioned_table
allow_partial_sn_results
always_anti_join
always_semi_join
arch_io_slaves
b_tree_bitmap_plans
backup_disk_io_slaves
cache_size_threshold
cell_partition_large_extents
cleanup_rollback_entries
close_cached_open_cursors
complex_view_merging
db_block_checkpoint_batch
db_block_lru_extended_statistics
db_block_lru_latches
db_block_lru_statistics
db_block_max_dirty_target
db_file_simultaneous_writes
dblink_encrypt_login
ddl_wait_for_locks
delayed_logging_block_cleanouts
discrete_transactions_enabled
distributed_recovery_connection_hold_time
distributed_transactions
drs_start
enqueue_resources
exclude_seed_cdb_view
fast_full_scan_enabled
freeze_DB_for_fast_instance_recovery
gc_defer_time
gc_files_to_locks
gc_latches
gc_lck_procs
gc_releasable_locks
gc_rollback_locks
hash_join_enabled
hash_multiblock_io_count
instance_nodeset
job_queue_interval
job_queue_keep_connections
large_pool_min_alloc
lgwr_io_slaves
lm_locks
lm_procs
lm_procs
lm_ress
lock_sga_areas
log_block_checksum
log_files
log_parallelism
log_simultaneous_copies
log_small_entry_max_size
logmnr_max_persistent_sessions
max_commit_propagation_delay
max_rollback_segments
max_transaction_branches
mts_circuits
mts_dispatchers
mts_listener_address
mts_max_dispatchers
mts_max_servers
mts_multiple_listeners
mts_servers
mts_service
mts_sessions
ogms_home
ops_admin_group
ops_interconnects
optimizer_adaptive_features
optimizer_max_permutations
optimizer_percent_parallel
optimizer_search_limit
oracle_trace_collection_name
oracle_trace_collection_path
oracle_trace_collection_size
oracle_trace_enable
oracle_trace_facility_name
oracle_trace_facility_path
parallel_automatic_tuning
parallel_broadcast_enabled
parallel_default_max_instances
parallel_degree_level
parallel_io_cap_enabled
parallel_min_message_pool
parallel_server
parallel_server_idle_time
parallel_server_instances
parallel_transaction_resource_timeout
partition_view_enabled
plsql_compiler_flags
plsql_native_c_compiler
plsql_native_library_dir
plsql_native_library_subdir_count
plsql_native_linker
plsql_native_make_file_name
plsql_native_make_utility
push_join_predicate
remote_archive_enable
row_cache_cursors
row_locking
sequence_cache_entries
sequence_cache_hash_buckets
serializable
shared_pool_reserved_min_alloc
snapshot_refresh_interval
snapshot_refresh_keep_connections
snapshot_refresh_processes
sort_direct_writes
sort_multiblock_read_count
sort_read_fac
sort_spacemap_size
sort_write_buffer_size
sort_write_buffers
spin_count
sql_version
standby_preserves_names
temporary_table_locks
text_enable
transaction_auditing
undo_suppress_errors
use_indirect_data_buffers
use_ism[/code]
「喜欢文章,快来给作者赞赏墨值吧」 赞赏
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
请登录后发表评论