A cada nova versão do Oracle Database, novas funcionalidades, novas “features” e novas correções de bug’s são adicionados ao banco de dados e com isso novos parâmetros para controlar tudo isso. E não é de hoje que esses novos parâmetros são adicionados a uma nova versão de Oracle.
Exatamente na versão 9i Release 9.2.0.8.0 existiam cerca de 871 parâmetros de configuração do Oracle entre é claro parâmetros documentados e não documentados, já na versão 10g no Release 10.2.0.4.0 esse número passou para incríveis 1495 parâmetros, exatos 624 parâmetros a mais do que na versão anterior. Já com a versão 11g Release 11.2.0.4.0 que contém exatamente 2914 parâmetros, cerca de 2043 parâmetros a mais do que na versão 9i.
Com o lançamento do Oracle Database 12c, podemos mais uma vez fazer esse comparativo, isso através da table Oracle memory x$ksppi, que fornece todos os parâmetros documentados, parâmetros ocultos documentos e parâmetros ocultos não documentados pelo Oracle Database. É por intermédio dessa x$ table que podemos observar as diferenças de parâmetros entre uma versão e outra.
Veja o caso na versão 11g Release 11.2.0.4.0, temos exatos 2914 parâmetros:
SQL> select count(*) from x$ksppi;
COUNT(*)
----------
2914
1 row selected.
SQL>
Já na versão 12c (12.1.0.2.0), esse número passou para 3978:
SQL> select count(*) from x$ksppi;
COUNT(*)
----------
3978
SQL>
Quase mil parâmetros a mais do que na versão anterior. Outro fato interessante que na versão 12.1.0.1.0 para a versão 12.1.0.2.0, já temos uma grande diferenças de novos parâmetros:
Oracle 12c (12.1.0.1.0)
SQL> select count(*) from x$ksppi;
COUNT(*)
----------
3351
1 row selected.
SQL>
Oracle 12c (12.1.0.2.0)
SQL> select count(*) from x$ksppi;
COUNT(*)
----------
3978
1 row selected.
SQL>
Abaixo está a lista completa de todos os parâmetros que estão somente na versão Oracle 12c, ou seja, todos os parâmetros a seguir são os novos parâmetros do Oracle 12c. Para conseguir isso, estou utilizando uma tabela temporária que criei chamada ksppi, que nada mais é que uma CTAS (Create Table AS) da x$ table x$ksppi, isso foi feito para conseguir realizar a consulta nos dados da x$ utilizando dblink.
Lembrando também que essa é a lista de todos os parâmetros documentos, ocultos documentados e ocultos não documentados. Nem preciso dizer que não é para você mudar qualquer um dos parâmetros ocultos abaixo, principalmente no seu banco de produção, sem antes ter a permissão do suporte Oracle. Tenha muito cuidado com qualquer um desses parâmetro ocultos.
Aqui a lista, com a descrição de cada parâmetro:
Aqui a lista, com a descrição de cada parâmetro:
SQL> COLUMN PARAMETER_ONLY_12C FORMAT a50
SQL> SELECT
2 KSPPINM PARAMETER_ONLY_12C
3 FROM ksppi
4 WHERE KSPPINM NOT IN (
5 SELECT KSPPINM parameter_name_11g
6 FROM ksppi@db11g
7 );
PARAMETER_ONLY_12C
----------------------------------------
_appqos_po_multiplier
_appqos_cdb_setting
_latch_wait_list_pri_sleep_secs
__wait_test_param
_system_state_runtime_limit
_system_state_cputime_limit
_enqueue_sync_retry_attempts
_enqueue_sync_sim_mem_error
_number_group_memberships_per_cache_line
_ksdxw_stack_readable
_touch_sga_pages_during_allocation
_realfree_heap_pagesize
_realfree_pq_heap_pagesize
_kgh_restricted_trace
_kgh_restricted_subheaps
_defer_sga_enabled
_defer_sga_min_total_defer_segs_sz
_defer_sga_alloc_chunk_size
_defer_sga_min_spsz_at_startup
_defer_sga_test_alloc_intv
_sga_alloc_slaves_term_timeout_secs
_ksmlsaf
_pga_limit_target_perc
_pga_limit_watch_perc
_pga_limit_time_to_interrupt
_pga_limit_interrupt_smaller
_pga_limit_time_until_idle
_pga_limit_time_until_killed
_pga_limit_use_immediate_kill
_pga_limit_dump_summary
_pga_limit_watch_size
_pga_limit_min_req_size
_pga_limit_check_wait_time
_pga_limit_simulated_physmem_size
_pga_limit_physmem_perc
_sga_data_protection_disabled
_sga_dp_precise_errors
_sga_heap_chunk_alignment
_sga_heap_chunk_alignment_disabled
_sga_dp_bytes_per_alloc
_NUMA_bind_mode
pga_aggregate_limit
_pga_limit_tracing
_test_param_8
_highest_priority_processes
_os_sched_highest_priority
_bg_spawn_diag_opts
_mpmt_enabled_backgrounds
_background_process_opts
_kse_snap_ring_suppress
_kse_snap_ring_disable
_enqueue_deadlock_detect_all_global_locks
_enable_kernel_io_outliers
_dnfs_rdma_max
_dnfs_rdma_min
_dnfs_rdma_enable
_simulate_logical_sectorsize
_io_outlier_threshold
_lgwr_io_outlier
_asm_access
_ksfd_fob_pct
_use_dynamic_shares
_dynamic_share_range_factor
_cpu_util_adj_force
_cpu_util_adj_target
_high_threshold_delta
db_performance_profile
_rm_force_caging
_ksv_slave_exit_timeout
_twenty-ninth_spare_parameter
_thirty-ninth_spare_parameter
_forty-first_spare_parameter
_forty-second_spare_parameter
_forty-third_spare_parameter
_forty-fourth_spare_parameter
_forty-fifth_spare_parameter
_forty-sixth_spare_parameter
_forty-seventh_spare_parameter
_forty-eighth_spare_parameter
_forty-ninth_spare_parameter
_fiftieth_spare_parameter
_fifty-first_spare_parameter
_fifty-second_spare_parameter
_fifty-third_spare_parameter
_fifty-fourth_spare_parameter
_fifty-fifth_spare_parameter
_fifty-sixth_spare_parameter
_fifty-seventh_spare_parameter
_fifty-eighth_spare_parameter
_fifty-ninth_spare_parameter
_sixtieth_spare_parameter
_sixty-first_spare_parameter
_sixty-second_spare_parameter
_sixty-third_spare_parameter
_sixty-fourth_spare_parameter
_sixty-fifth_spare_parameter
_sixty-sixth_spare_parameter
_sixty-seventh_spare_parameter
_sixty-eighth_spare_parameter
_sixty-ninth_spare_parameter
_seventieth_spare_parameter
_seventy-first_spare_parameter
_seventy-second_spare_parameter
_seventy-third_spare_parameter
_seventy-fourth_spare_parameter
_seventy-fifth_spare_parameter
_seventy-sixth_spare_parameter
_seventy-seventh_spare_parameter
_seventy-eighth_spare_parameter
_seventy-ninth_spare_parameter
_eightieth_spare_parameter
_eighty-first_spare_parameter
_eighty-second_spare_parameter
_eighty-third_spare_parameter
_eighty-fourth_spare_parameter
_eighty-fifth_spare_parameter
_eighty-sixth_spare_parameter
_eighty-seventh_spare_parameter
_eighty-eighth_spare_parameter
_eighty-ninth_spare_parameter
_ninetieth_spare_parameter
_ninety-first_spare_parameter
_ninety-second_spare_parameter
_ninety-third_spare_parameter
_ninety-fourth_spare_parameter
_ninety-fifth_spare_parameter
_ninety-sixth_spare_parameter
_ninety-seventh_spare_parameter
_ninety-eighth_spare_parameter
_ninety-ninth_spare_parameter
_one-hundredth_spare_parameter
_one-hundred-and-first_spare_parameter
_one-hundred-and-second_spare_parameter
_one-hundred-and-third_spare_parameter
_one-hundred-and-fourth_spare_parameter
_one-hundred-and-fifth_spare_parameter
_one-hundred-and-sixth_spare_parameter
_one-hundred-and-seventh_spare_parameter
_one-hundred-and-eighth_spare_parameter
_one-hundred-and-ninth_spare_parameter
_one-hundred-and-tenth_spare_parameter
_one-hundred-and-eleventh_spare_parameter
_one-hundred-and-twelfth_spare_parameter
_one-hundred-and-thirteenth_spare_parameter
_one-hundred-and-fourteenth_spare_parameter
_one-hundred-and-fifteenth_spare_parameter
_one-hundred-and-sixteenth_spare_parameter
_one-hundred-and-seventeenth_spare_parameter
_one-hundred-and-eighteenth_spare_parameter
_one-hundred-and-nineteenth_spare_parameter
_one-hundred-and-twentieth_spare_parameter
_one-hundred-and-twenty-first_spare_parameter
_one-hundred-and-twenty-second_spare_parameter
_one-hundred-and-twenty-third_spare_parameter
_one-hundred-and-twenty-fourth_spare_parameter
_one-hundred-and-twenty-fifth_spare_parameter
_one-hundred-and-twenty-sixth_spare_parameter
_one-hundred-and-twenty-seventh_spare_parameter
_one-hundred-and-twenty-eighth_spare_parameter
_one-hundred-and-twenty-ninth_spare_parameter
_one-hundred-and-thirtieth_spare_parameter
_one-hundred-and-thirty-first_spare_parameter
_one-hundred-and-thirty-second_spare_parameter
_one-hundred-and-thirty-third_spare_parameter
_one-hundred-and-thirty-fourth_spare_parameter
_one-hundred-and-thirty-fifth_spare_parameter
_one-hundred-and-thirty-sixth_spare_parameter
_one-hundred-and-thirty-seventh_spare_parameter
_one-hundred-and-thirty-eighth_spare_parameter
_one-hundred-and-thirty-ninth_spare_parameter
_one-hundred-and-fortieth_spare_parameter
_one-hundred-and-forty-first_spare_parameter
_one-hundred-and-forty-second_spare_parameter
_one-hundred-and-forty-third_spare_parameter
_one-hundred-and-forty-fourth_spare_parameter
_one-hundred-and-forty-fifth_spare_parameter
_one-hundred-and-forty-sixth_spare_parameter
_one-hundred-and-forty-seventh_spare_parameter
_one-hundred-and-forty-eighth_spare_parameter
_one-hundred-and-forty-ninth_spare_parameter
_one-hundred-and-fiftieth_spare_parameter
_one-hundred-and-fifty-first_spare_parameter
_one-hundred-and-fifty-second_spare_parameter
_one-hundred-and-fifty-third_spare_parameter
_one-hundred-and-fifty-fourth_spare_parameter
_one-hundred-and-fifty-fifth_spare_parameter
_one-hundred-and-fifty-sixth_spare_parameter
_one-hundred-and-fifty-seventh_spare_parameter
_one-hundred-and-fifty-eighth_spare_parameter
_one-hundred-and-fifty-ninth_spare_parameter
_one-hundred-and-sixtieth_spare_parameter
_one-hundred-and-sixty-first_spare_parameter
_one-hundred-and-sixty-second_spare_parameter
_one-hundred-and-sixty-third_spare_parameter
_one-hundred-and-sixty-fourth_spare_parameter
_one-hundred-and-sixty-fifth_spare_parameter
_one-hundred-and-sixty-sixth_spare_parameter
_one-hundred-and-sixty-seventh_spare_parameter
_one-hundred-and-sixty-eighth_spare_parameter
_one-hundred-and-sixty-ninth_spare_parameter
_one-hundred-and-seventieth_spare_parameter
_one-hundred-and-seventy-first_spare_parameter
_one-hundred-and-seventy-second_spare_parameter
_one-hundred-and-seventy-third_spare_parameter
_one-hundred-and-seventy-fourth_spare_parameter
_one-hundred-and-seventy-fifth_spare_parameter
_one-hundred-and-seventy-sixth_spare_parameter
_one-hundred-and-seventy-seventh_spare_parameter
_one-hundred-and-seventy-eighth_spare_parameter
_one-hundred-and-seventy-ninth_spare_parameter
_one-hundred-and-eightieth_spare_parameter
_one-hundred-and-eighty-first_spare_parameter
_one-hundred-and-eighty-second_spare_parameter
_one-hundred-and-eighty-third_spare_parameter
_one-hundred-and-eighty-fourth_spare_parameter
_one-hundred-and-eighty-fifth_spare_parameter
_one-hundred-and-eighty-sixth_spare_parameter
_one-hundred-and-eighty-seventh_spare_parameter
_one-hundred-and-eighty-eighth_spare_parameter
_one-hundred-and-eighty-ninth_spare_parameter
_one-hundred-and-ninetieth_spare_parameter
_one-hundred-and-ninety-first_spare_parameter
_one-hundred-and-ninety-second_spare_parameter
_one-hundred-and-ninety-third_spare_parameter
_one-hundred-and-ninety-fourth_spare_parameter
_one-hundred-and-ninety-fifth_spare_parameter
_one-hundred-and-ninety-sixth_spare_parameter
_one-hundred-and-ninety-seventh_spare_parameter
_one-hundred-and-ninety-eighth_spare_parameter
_one-hundred-and-ninety-ninth_spare_parameter
_two-hundredth_spare_parameter
_two-hundred-and-first_spare_parameter
_two-hundred-and-second_spare_parameter
_two-hundred-and-third_spare_parameter
_two-hundred-and-fourth_spare_parameter
_two-hundred-and-fifth_spare_parameter
_two-hundred-and-sixth_spare_parameter
_two-hundred-and-seventh_spare_parameter
_two-hundred-and-eighth_spare_parameter
_two-hundred-and-ninth_spare_parameter
_two-hundred-and-tenth_spare_parameter
_two-hundred-and-eleventh_spare_parameter
_two-hundred-and-twelfth_spare_parameter
_two-hundred-and-thirteenth_spare_parameter
_two-hundred-and-fourteenth_spare_parameter
_two-hundred-and-fifteenth_spare_parameter
_two-hundred-and-sixteenth_spare_parameter
_two-hundred-and-seventeenth_spare_parameter
_two-hundred-and-eighteenth_spare_parameter
_two-hundred-and-nineteenth_spare_parameter
_two-hundred-and-twentieth_spare_parameter
_ksipc_mode
_ksipc_libipc_path
_ksipc_wait_flags
_ksipc_spare_param1
_ksipc_spare_param2
_ksxp_ksmsq_ip_config
_ksxp_ipclw_enabled
_ipc_config_opts_stat
_ipc_config_opts_dyn
_ksipc_efchecks
_datapump_metadata_buffer_size
_datapump_tabledata_buffer_size
_datapump_compressbas_buffer_size
_midtier_affinity_cluswait_prc_threshold
_disable_modsvc_refresh
threaded_execution
_mpmt_single_process_instance
_mpmt_procs_per_osp
_prespawn_batch_count
_dataguard_prespawn_count
_proc_grp_enabled
_min_time_between_psp0_diag_secs
_disable_rolling_patch
_deadlock_record_to_alert_log
_process_heartbeat_range
_lthread_cleanup_intv_secs
_lthread_enabled
_lthread_debug
_lthread_max_spawn_time_csecs
_lthread_spawn_check_intv_ms
_lthread_clnup_pmon_softkill_wait_secs
_lthread_clnup_spawner_sk_wait_secs
_lthread_clnup_hk_wait_secs
_lthread_step_debugging
_full_diag_on_rim
_hang_cross_boundary_hang_detection_enabled
_hang_resolution_percent_hung_sessions_threshold
_hang_terminate_session_replay_enabled
_diag_xm_enabled
_hm_xm_enabled
_lm_hash_control
_ges_server_processes
_lm_lms_opt_priority
_lm_lms_priority_check_frequency
_lm_db_rank
_lm_db_ranks
_lm_cache_enqueue
_lm_reloc_use_mhint
_lm_rcfg_kjcdump_time
_lm_enqueue_blocker_dump_timeout_cnt
_lm_num_bnft_stats_buckets
_lm_exchange_opt
_lm_drm_we_size
_lm_drm_we_interval
_read_mostly_instance
_read_mostly_instance_qa_control
_read_mostly_slave_timeout
_read_mostly_enable_logon
_lm_big_cluster_optimizations
_ges_lmd_mapping
_ges_hash_groups
_ges_default_lmds
_ges_nres_divide
_lm_drmopt12
_lm_adrm_options
_lm_adrm_scan_timeout
_lm_adrm_interval
_lm_adrm_time_out
_lm_resend_open_convert_timeout
_lm_process_lock_q_scan_limit
_ges_gather_res_reuse_stats
_ges_freeable_res_chunk_free
_lm_share_lock_restype
_ges_freeable_res_chunk_free_interval
_ges_dump_open_locks
_lm_exadata_fence_type
_rond_test_mode
_adg_distributed_lockmaster
_kjdd_call_stack_dump_enabled
_kjdd_wfg_dump_cntrl
_omni_enqueue_enable
_lm_idle_connection_kill_max_skips
_lm_idle_connection_quorum_threshold
_lm_msg_pool_dump_threshold
_lm_msg_pool_user_callstack_dump
_lm_idle_connection_max_ignore_kill_count
_lm_mp_avail_queue_threshold
_lm_mp_bulk_mbuf_free
_lm_wait_pending_send_queue
_lm_hashtable_bkt_low
_lm_hashtable_bkt_high
_lm_hashtable_bkt_thr
_lm_comm_tkts_adaptive
_lm_comm_tkts_calc_period_length
_lm_comm_tkts_max_periods
_lm_comm_tkts_min_increase_wait
_lm_comm_tkts_min_decrease_wait
_lm_comm_tkts_nullreq_threshold
_lm_comm_tkts_mult_factor
_lm_comm_tkts_sub_factor
_lm_comm_tkts_max_add
_exafusion_enabled
_lm_comm_channel
_lm_comm_msgq_busywait
_lm_comm_reap_count
_lm_gl_hash_scheme
_cluster_flash_cache_slave_file
_gcs_res_hash_buckets
_gcs_reserved_resources
_gcs_min_slaves
_gcs_dynamic_slaves
_gcs_reserved_shadows
_broadcast_scn_mode
_nameservice_consistency_check
_nameservice_request_batching
_cgs_ticket_sendback
_cgs_msg_batch_size
_cgs_msg_batching
_cgs_comm_readiness_check
_imr_rr_holder_kill_time
_imr_check_css_incarnation_number
_cgs_memberkill_from_rim_instance
_cgs_os_level_connection_check
_cgs_os_level_connection_reqno
_cgs_big_group_enabled
_cgs_support_rim_disc
_lm_rm_slaves
_lm_timed_statistics_level
_shutdown_sync_enable
_crs_2phase
_ges_vbfreelists
_lm_hb_enable_acl_check
_lm_hb_acceptable_hang_condition
_lm_hb_maximum_hang_report_count
_lm_hb_exponential_hang_time_factor
_gcr_enable_high_memory_kill
_gcr_high_memory_threshold
_gcr_cpu_min_free
_gcr_mem_min_free
_gcr_css_use_2group_lock
_gcr_css_group_try_lock_delay
_gcr_css_group_query_boost
_gcr_css_group_update_interval
_gcr_css_group_update2_interval
_gcr_css_group_large
_gcr_tick
_gcr_enable_statistical_cpu_check
_gcr_enable_new_drm_check
_gcr_max_rt_procs
_kjac_force_outcome_current_session
_ka_enabled
_ka_mode
_ka_locks_per_sector
_ka_msg_reap_count
_ka_compatibility_requirement
_ka_allow_reenable
_ka_pbatch_messages
_ka_doorbell
_ka_scn_enabled
_ka_scn_accel_shrmem
_ka_scn_use_ka_msgs
_ka_grant_policy
_ka_msg_wait_count
_ka_max_wait_delay
_gcs_cluster_flash_cache_mode
_gcs_flash_cache_mode
_max_defer_gran_xfer_atonce
_asm_allow_small_memory_target
_controlfile_split_brain_check
db_big_table_cache_percent_target
_db_full_db_cache_diff_pct
_db_writer_coalesce_encrypted_buffers
_dbwr_stall_write_detection_interval
_pin_time_statistics
_adg_buffer_wait_timeout
_db_full_caching
_db_flash_cache_disable_write_batchsize
_switch_current_scan_scn
_cleanout_shrcur_buffers
_child_read_ahead_dba_check
_data_warehousing_scan_buffers
_data_warehousing_scan_flash_buffers
_data_warehousing_serial_scan
_db_dw_scan_obj_cooling_policy
_db_dw_scan_obj_cooling_interval
_db_dw_scan_obj_cooling_factor
_db_dw_scan_obj_warming_increment
_db_dw_scan_adaptive_cooling
_db_dw_scan_max_shadow_count
_pq_numa_working_set_affinity
_db_cache_advice_hash_latch_multiple
_redo_log_record_life
_redo_log_debug_config
_redo_log_check_backup
_cache_orl_during_open
_target_log_write_size
_target_log_write_size_timeout
_use_single_log_writer
_max_outstanding_log_writes
_adaptive_scalable_log_writer_enable_worker_threshold
_adaptive_scalable_log_writer_disable_worker_threshold
_adaptive_scalable_log_writer_sampling_count
_adaptive_scalable_log_writer_sampling_time
_adaptive_scalable_log_writer_enable_worker_aging
_max_log_write_parallelism
_max_log_write_io_parallelism
_serial_log_write_worker_io
_simulated_log_write_usecs
_adaptive_log_file_sync_use_postwait_threshold_aging
_adaptive_log_file_sync_sampling_count
_adaptive_log_file_sync_sampling_time
_check_pdbid_in_redo
_ping_wait_for_log_force
_log_writer_worker_dlm_hearbeat_update_freq
_hb_redo_interval
_disable_file_resize_logging
_file_set_enqueue_timeout
_file_offline_sync_timeout
_gc_policy_rm_dirty_percent
_gc_dump_remote_lock
_gc_save_cleanout
_gc_temp_affinity
_gc_fg_spin_time
_gc_async_send
_gc_try_to_skip_imc_flush
_gc_msgq_buffer_size
_gc_msgq_buffers
_gc_serve_from_flash_cache
_gc_trace_freelist_empty
_kcbl_assert_reset_slot
_thread_state_change_timeout_pnp
_allow_file_1_offline_error_1245
_switchover_timeout
_fast_psby_conversion
_ac_enable_dscn_in_rac
_ac_strict_SCN_check
_allow_convert_to_standby
_early_flush_delta
_backup_ksfq_bufmem_max
_backup_min_ct_unused_optim
_krb_trace_buffer_size
_catalog_foreign_restore
_prefered_standby
_krbabr_trace_buffer_size
_backup_appliance_enabled
_ba_container_filesystem_ausize
_ba_max_groups
_ba_max_containers
_ba_max_seg_bytes
_ba_cf_trace_buffer_size
_ba_timeouts_enabled
_aux_dfc_keep_time
_undo_tbs_slave_percent
_clone_one_pdb_recovery
_time_based_rcv_ckpt_target
_time_based_rcv_hdr_update_interval
_use_pdb_parselock
_snapshot_recovery_enabled
_bct_public_dba_buffer_dynresize
_bct_public_dba_buffer_maxsize
_krc_trace_buffer_size
_kra_trace_buffer_size
_kcfis_qm_prioritize_sys_plan
_kcfis_qm_user_plan_name
_kcfis_xtgran_prefetch_count
_nologging_sendbuf_ratio
_nologging_load_slotsz
_force_logging_in_upgrade
_nologging_kcnbuf_hash_buckets
_nologging_kcnbuf_hash_latches
_nologging_sdcl_append_wait
_nologging_txn_cmt_wait
_max_data_transfer_cache_size
_data_transfer_cache_bc_perc_x100
_data_transfer_cache_size
__data_transfer_cache_size
_max_kcnibr_ranges
_log_undo_df_info
_cvmap_buffers
_txn_control_trace_buf_size
_collect_tempundo_stats
temp_undo_enabled
_temp_undo_disable_adg
_resumable_critical_alert
_securefile_log_num_latches
_securefile_log_shared_pool_size
_cli_cachebktalloc
_ilm_mem_limit
_ktilmsc_exp
_inmemory_check_prot_meta
_inmemory_private_journal_quota
_inmemory_private_journal_sharedpool_quota
_inmemory_private_journal_numbkts
_inmemory_private_journal_numgran
_inmemory_jscan
_inmemory_pin_hist_mode
_inmemory_txn_checksum
_inmemory_buffer_waittime
_inmemory_cu_timeout
_inmemory_cudrop_timeout
_inmemory_exclto_timeout
_inmemory_num_hash_latches
_inmemory_strdlxid_timeout
_inmemory_incremental_repopulation
_inmemory_lock_for_smucreate
_old_extent_scheme
_trace_temp
_concurrency_chosen
_no_small_file
_assm_test_force_rej
_assm_test_force_rej2
_assm_test_reentrant_gsp
_disable_flashback_recyclebin_opt
_enable_securefile_flashback_opt
_enable_12g_bft
_undotbs_stepdown_pcent
_undotbs_regular_tables
_minmax_spacebg_slaves
_min_spacebg_slaves
_securefiles_breakreten_retry
_securefiles_spcutl
_trace_ktfs
_trace_ktfs_mem
heat_map
_enable_ilm_flush_stats
_enable_ilm_testflush_stats
_disable_12cbigfile
_enable_heatmap_internal
_heatmap_format_1block
_test_hm_extent_map
_ilmset_stat_limit
_ilmflush_stat_limit
_heatmap_min_maxsize
_ilmstat_memlimit
_flush_ilm_stats
_create_stat_segment
_drop_stat_segment
_print_stat_segment
_print_inmem_heatmap
_inmemory_auto_distribute
_inmemory_autodist_2safe
_inmemory_distribute_timeout
_inmemory_distribute_ondemand_timeout
inmemory_size
_inmemory_64k_percent
_inmemory_min_ima_defersize
_inmemory_memprot
_trace_ktds
_track_space_reuse
_spacereuse_track_memlimit
_print_inmem_srmap
_sage_block_checking
_suppress_identifiers_on_dupkey
_widetab_comp_enabled
_force_sys_compress
_oltp_comp_dbg_scan
_cu_row_locking
_oltp_spill
_pdb_use_sequence_cache
_index_max_inc_trans_pct
_advanced_index_compression_options
_advanced_index_compression_options_value
_advanced_index_compression_trace
db_index_compression_inheritance
_ldr_tempseg_threshold
_kdli_descn_adj
_kdli_mts_so
_kdli_ralc_length
_kdli_ralc_rounding
_kdli_space_cache_segments
_sf_default_enabled
_kdlf_read_flag
_kdz_pcode_flags
_enable_columnar_cache
_kdz_proj_nrows
_kdz_pred_nrows
_kdzk_enable_init_trace
_kdzk_load_specialized_library
_kdzk_trace_level
_hpk_project_cost_weighting
_hpk_throughput_range
_hpk_compression_range
_inmemory_analyzer_optimize_for
_dbfs_modify_implicit_fetch
_ILM_FILTER_TIME
_ILM_FILTER_TIME_LOWER
_ILM_POLICY_NAME
_inmemory_default_flags
_inmemory_default_new
inmemory_clause_default
inmemory_force
inmemory_query
_inmemory_query_scan
_inmemory_scan_override
_inmemory_scan_threshold_percent_noscan
_inmemory_small_segment_threshold
_inmemory_query_fetch_by_rowid
_inmemory_pruning
_inmemory_enable_sys
_inmemory_populate_fg
_inmemory_pga_per_server
inmemory_max_populate_servers
_inmemory_servers_throttle_pgalim_percent
inmemory_trickle_repopulate_servers_percent
_inmemory_populate_wait
_inmemory_populate_wait_max
_inmemory_imco_cycle
_inmemory_enable_population_verify
_inmemory_log_level
_inmemory_fs_verify
_inmemory_force_fs
_inmemory_force_fs_tbs
_inmemory_force_fs_tbs_size
_inmemory_fs_raise_error
_inmemory_fs_nodml
_inmemory_fs_enable
_inmemory_fs_enable_blk_lvl_inv
_inmemory_fs_blk_inv_blkcnt
_inmemory_fs_blk_inv_blk_percent
_inmemory_enable_stat_alert
_inmemory_imcu_align
_inmemory_max_populate_retry
_inmemory_imcu_target_rows
_inmemory_imcu_target_bytes
_inmemory_imcu_source_extents
_inmemory_imcu_source_blocks
_inmemory_imcu_source_minbytes
_inmemory_imcu_populate_minbytes
_inmemory_imcu_source_analyze_bytes
_inmemory_imcu_target_maxrows
_inmemory_imcu_source_maxbytes
_inmemory_max_queued_tasks
_inmemory_repopulate_threshold_rows
_inmemory_repopulate_threshold_blocks
_inmemory_pct_inv_rows_invalidate_imcu
_inmemory_pct_inv_blocks_invalidate_imcu
_inmemory_repopulate_threshold_mintime_factor
_inmemory_repopulate_threshold_mintime
_inmemory_repopulate_threshold_scans
_inmemory_repopulate_priority_scale_factor
_inmemory_repopulate_invalidate_rate_percent
_inmemory_repopulate_priority_threshold_row
_inmemory_repopulate_priority_threshold_block
_inmemory_repopulate_threshold_rows_percent
_inmemory_repopulate_threshold_blocks_percent
_inmemory_repopulate_disable
_inmemory_check_protect
_inmemory_checksum
_inmemory_validate_fetch
_inmemory_journal_row_logging
_inmemory_journal_check
_inmemory_rows_check_interrupt
_inmemory_dbg_scan
_inmemory_segment_populate_verify
_inmemory_query_check
_inmemory_test_verification
_inmemory_invalidate_cursors
_inmemory_prepopulate_fg
_inmemory_prepopulate
_inmemory_trickle_repopulate
_inmemory_trickle_repopulate_threshold_dirty_ratio
_inmemory_trickle_repopulate_min_interval
_inmemory_trickle_repopulate_fg
_inmemory_force_non_engineered
_inmemory_suppress_vsga_ima
_index_load_buf_oltp_sacrifice_pct
_index_load_buf_oltp_under_pct
_kdizoltp_uncompsentinal_freq
_kqdsn_min_instance_bits
_kqdsn_max_instance_bits
_kqdsn_partition_ratio
_kgl_large_heap_assert_threshold
_revoke_new_semantics
_tsenc_obfuscate_key
_db_discard_lost_masterkey
_db_generate_dummy_masterkey
_use_fips_mode
DBFIPS_140
_pbkdf2_sder_count
_resource_includes_unlimited_tablespace
_xs_cleanup_task
_xds_max_child_cursors
_xs_dispatcher_only
_unified_audit_policy_disabled
unified_audit_sga_queue_size
_unified_audit_flush_threshold
_unified_audit_flush_interval
_reco_sessions_max_percentage
_disable_duplicate_service_warning
_dispatcher_listen_on_vip
use_dedicated_broker
_mpmt_fg_enabled
connection_brokers
_cursor_reload_failure_threshold
_kks_obsolete_dump_threshold
_plsql_icd_arg_dump
_redef_on_statement
_AllowMultInsteadofDDLTrigger
_kktAllowInsteadOfDDLTriggeronDDL
_lock_next_constraint_count
_max_string_size_bypass
_bigdata_external_table
_kxscio_cap_stacks
_px_proactive_slave_alloc_threshold
_px_load_balancing_policy
_px_dp_array_size
_sort_sync_min_spillsize
_sort_sync_min_spill_threshold
_cell_offload_expressions
_cell_materialize_virtual_columns
_cell_materialize_all_expressions
_cell_offload_sys_context
_gby_vector_aggregation_enabled
_optimizer_vector_transformation
_optimizer_vector_fact_dim_ratio
_key_vector_max_size
_key_vector_predicate_enabled
_key_vector_predicate_threshold
_key_vector_offload
_key_vector_caching
_vector_operations_control
_optimizer_vector_min_fact_rows
_vector_serialize_temp_threshold
_always_vector_transformation
_vector_aggregation_max_size
_optimizer_key_vector_aggr_factor
_optimizer_vector_cost_adj
_crash_domain_on_exception
_odci_aggregate_save_space
_cell_storidx_minmax_enabled
_cell_offload_complex_processing
_optimizer_partial_join_eval
_optimizer_unnest_scalar_sq
_px_object_sampling
_utlmmig_table_stats_gathering
_remove_exf_component
_bloom_filter_size
_bloom_predicate_offload
_bloom_rm_filter
_dbop_enabled
_optimizer_ansi_join_lateral_enhance
_optimizer_multi_table_outerjoin
_optimizer_null_accepting_semijoin
_optimizer_ansi_rearchitecture
_optimizer_aggr_groupby_elim
_optimizer_gather_feedback
_part_redef_global_index_update
_optimizer_generate_transitive_pred
_optimizer_cube_join_enabled
max_string_size
_dm_enable_legacy_dmf_output_types
_dm_dmf_details_compatibility
_optimizer_hybrid_fpwj_enabled
_px_message_compression
_px_object_sampling_enabled
_px_concurrent
_px_back_to_parallel
_scalar_type_lob_storage_threshold
_px_replication_enabled
_zonemap_use_enabled
_zonemap_staleness_tracking
_zonemap_control
_sql_plan_directive_mgmt_control
_px_filter_parallelized
_px_filter_skew_handling
_px_groupby_pushdown
_partition_advisor_srs_active
_px_parallelize_expression
_fast_index_maintenance
_optimizer_gather_stats_on_load
_multi_transaction_optimization_enable
_optimizer_batch_table_access_by_rowid
optimizer_adaptive_reporting_only
_optimizer_ads_result_cache_life
_px_wif_dfo_declumping
_px_wif_extend_distribution_keys
_px_wif_min_ndv_per_slave
_px_join_skew_handling
_px_join_skew_ratio
_px_join_skew_minfreq
_px_adaptive_dist_method
_px_adaptive_dist_method_threshold
_parallel_fault_tolerance_enabled
_parallel_fault_tolerance_threshold
_px_partial_rollup_pushdown
_sql_diag_repo_retain
_sql_diag_repo_origin
_optimizer_dsdir_usage_control
_px_cpu_autodop_enabled
parallel_degree_level
_px_cpu_process_bandwidth
_px_cpu_operator_bandwidth
_px_single_server_enabled
_optimizer_use_gtt_session_stats
_optimizer_adaptive_plans
_optimizer_adaptive_plan_control
_optimizer_adaptive_random_seed
_optimizer_strans_adaptive_pruning
_optimizer_proc_rate_level
_px_hybrid_TSM_HWMB_load
_optimizer_use_histograms
_disable_directory_link_check
_add_nullable_column_with_default_optim
_emx_max_sessions
_emx_session_timeout
_emx_control
_parallel_blackbox_sga
_rowsets_enabled
_rowsets_target_maxsize
_rowsets_max_rows
_use_hidden_partitions
_px_load_monitor_threshold
_px_monitor_load
_px_adaptive_offload_percentage
_modify_column_index_unusable
_adaptive_window_consolidator_enabled
_sql_hvshare_threshold
_px_tq_rowhvs
_sql_hvshare_debug
_sql_show_expreval
_parallel_ctas_enabled
_optimizer_performance_feedback
_optimizer_proc_rate_source
_hashops_prefetch_size
_stat_aggs_one_pass_algorithm
_px_onepass_slave_acquisition
_online_ctas_diag
_upddel_dba_hash_mask_bits
_px_pwmr_enabled
_px_cdb_view_enabled
optimizer_adaptive_features
_partition_cdb_view_enabled
_common_data_view_enabled
_pred_push_cdb_view_enabled
_rowsets_cdb_view_enabled
_distinct_agg_optimization_gsets
_array_cdb_view_enabled
_mv_refresh_truncate_log
_rc_sys_obj_enabled
_px_scalable_invdist
_indexable_con_id
_optimizer_reduce_groupby_key
_optimizer_cluster_by_rowid_batched
_optimizer_cluster_by_rowid_batch_size
_object_link_fixed_enabled
_optimizer_synopsis_min_size
_merge_monitor_threshold
optimizer_inmemory_aware
_optimizer_inmemory_table_expansion
_optimizer_inmemory_gen_pushable_preds
_optimizer_inmemory_autodop
_optimizer_inmemory_access_path
_optimizer_inmemory_quotient
_optimizer_inmemory_pruning_ratio_rows
_parallel_inmemory_min_time_threshold
_parallel_inmemory_time_unit
_px_external_table_default_stats
_optimizer_nlj_hj_adaptive_join
_px_autodop_pq_overhead
_px_overhead_init_slavealloc
_px_overhead_init_endpoints
_px_overhead_exec_ctrlmesg
_px_overhead_teardown
_grant_read_instead_of_select
_optimizer_inmemory_bloom_filter
_optimizer_inmemory_cluster_aware_dop
_cdb_cross_container
_cdb_view_parallel_degree
_optimizer_hll_entry
_cross_con_row_count
_cdb_view_prefetch_batch_size
_cdb_view_rc_shelflife
_approx_cnt_distinct_gby_pushdown
_approx_cnt_distinct_optimization
_px_cdb_view_join_enabled
_external_table_smart_scan
_optimizer_inmemory_minmax_pruning
_query_execution_time_limit
_optimizer_ads_use_partial_results
_alter_upgrade_signature_only
_max_clients_per_emon
_emon_pool_inc
_emon_pool_min
_emon_pool_max
_aq_streaming_threshold
_re_fast_sql_operator
_re_result_cache_keysiz
_re_result_cache_size
_re_independent_expression_cache_size
_enable_iee_stats
_re_num_complex_operator
_re_num_rowcache_load
_aqsharded_cache_limit
_aq_Txn_ht_sz
_aq_shard_bitmap_child_latches
_aq_shard_retry_child_latches
_aq_shard_txn_child_latches
_aq_shard_sub_child_latches
_aq_shard_sub_child_Elem_latches
_aq_shard_child_latches
_aq_shard_prty_latches
_aq_init_shards
_aq_disable_x
_aq_latency_relative_threshold
_aq_latency_absolute_threshold
_aq_x_msg_size
_aq_stop_backgrounds
_aq_lb_cycle
_aq_lb_stats_collect_cycle
_aq_pt_processes
_aq_subshard_Size
_aq_subshards_per_qpartition
_aq_subshards_per_dqpartition
_aq_lookback_size
_aq_qt_prefetch_Size
_aq_dq_prefetch_Siz
_aq_pt_statistics_window
_aq_pt_shrink_frequency
_aq_addpt_batch_size
_aq_truncpt_batch_size
_aq_droppt_batch_size
_shrd_que_tm_processes
_shrd_que_tm_statistics_duration
_aq_ipc_max_slave
_ctx_doc_policy_stems
_olap_row_load_time_precision
_olap_disable_loop_optimized
_remote_asm
_asm_relocation_trace
_asm_relocation_ignore_hard_failure
_asm_max_parallelios
_kffmlk_hash_size
_asm_diskgroups2
_asm_diskgroups3
_asm_diskgroups4
_asm_disable_dangerous_failgroup_checking
_asm_diskerr_traces
_asm_procs_trace_diskerr
_asm_trace_limit_timeout
_asm_skip_dbfile_ios
_asm_offload_all
_asm_read_cancel
_asm_read_cancel_back_out
_asm_write_cancel
_afd_disable_fence
_asm_network_timeout
_asm_skip_diskval_check
_asm_remote_client_timeout
_asm_allow_unsafe_reconnect
_asm_disable_ufgmemberkill
_asm_nodekill_escalate_time
_asm_healthcheck_timeout
_asm_resyncCkpt
_asm_noevenread_diskgroups
_asm_networks
_asm_allowdegeneratemounts
_asm_proxy_startwait
_asm_allow_dangerous_unprotected_volumes
_asm_appliance_ignore_oak
_dirty_appliance_mode
_asm_appliance_slot_from_path
_asm_scrub_limit
_asm_scrub_unmatched_dba
_asm_enable_xrov
_asm_xrov_single
_asm_xrov_rsnmod
_asm_xrov_nvios
_asm_xrov_nstats
_skip_acfs_checks
_asm_force_vam
_usd_recent_read
_usd_preload_blks
_remote_awr_enabled
_awr_disabled_purge_tables
_awr_snapshot_level
_awr_remote_target_dblink
_awr_pdb_registration_enabled
_awr_cdbperf_threshold
_awr_partition_interval
_kewm_simulate_oer4031
_enable_metrics_allpdb
_enable_metrics_pdb
_autotask_test_name
_max_queued_report_requests
_report_capture_cycle_time
_report_capture_dbtime_percent_cutoff
_report_capture_timeband_length
_report_capture_recharge_window
_max_report_flushes_percycle
_report_request_ageout_minutes
_kecap_cache_size
_rtaddm_trigger_enabled
_rtaddm_trigger_args
spatial_vector_acceleration
_diag_adr_trace_dest
_diag_patch_cap_enabled
_log_segment_dump_parameter
_log_segment_dump_patch
_max_incident_file_size
_uts_trace_segment_size
_uts_trace_segments
_uts_first_segment_size
_uts_first_segment_retain
_uts_trace_disk_threshold
_diag_test_seg_reinc_mode
_kxdbio_ctx_init_count
_kxdbio_disable_offload_opcode
_kxdbio_enable_ds_opcode
_enable_offloaded_writes
_block_level_offload_high_lat_thresh
_kxdbio_hca_loadavg_thresh
_kxdbio_ut_ctl
_cell_offload_backup_compression
_enable_pluggable_database
enable_pluggable_database
_oracle_script
_discard_cmn_ddl_in_pdb_err
pdb_os_credential
pdb_lockdown
pdb_file_name_convert
_pluggable_database_debug
noncdb_compatible
_cdb_compatible
_deferred_seg_in_seed
common_user_prefix
_common_user_prefix
_relocate_pdb
_cdb_rac_affinity
_set_container_service
_multiple_char_set_cdb
_cdb_spfile_inherit
_enable_pdb_close_abort
_max_pdbs
_pdb_cluster_database
_pdb_mask_cdb_info
exclude_seed_cdb_view
_disable_cdb_view_rc_invalidation
_gsm
_gsm_region_list
_cloud_name
_dbpool_name
_region_name
_db_num_gsm
_gsm_config_vers
_gsm_max_instances_per_db
_gsm_max_num_regions
_gsm_drv_interval
_gsm_srlat_thresh
_gsm_cpu_thresh
_gsm_thresh_zone
_gsm_thresh_respct
_gwm_spare1
_gwm_spare2
_gwm_spare3
_rq_shm_max_size
1106 rows selected.
E ae, já decorou todos 🙂