Os novos parâmetros do Oracle Database 12c
setembro 11, 2014

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:

SQ> 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:

SQL> COLUMN PARAMETER_ONLY_12C FORMAT a50
SQL> COLUMN description FORMAT a80

SQL> SELECT 
2	KSPPINM PARAMETER_ONLY_12C, KSPPDESC description 
3    FROM ksppi 
4    WHERE KSPPINM NOT IN (SELECT KSPPINM parameter_name_11g FROM ksppi@db11g);

PARAMETER_ONLY_12C					     DESCRIPTION
-----------------------------------------------------        --------------------------------------------------------
_appqos_po_multiplier					     Multiplier for PC performance objective value
_appqos_cdb_setting					     QoSM CDB Performance Class Setting
_latch_wait_list_pri_sleep_secs 			     Time to sleep on latch wait list until getting priority
__wait_test_param					     wait test parameter
_system_state_runtime_limit				     runtime limit for system state dump
_system_state_cputime_limit				     cputime limit for system state dump
_enqueue_sync_retry_attempts				     max number of times the bg process to retry synchronous enqueue open if it faile
							     d because master could not allocate memory

_enqueue_sync_sim_mem_error				     simulate master instance running out of memory when synchronously getting a remo
							     tely mastered enqueue

_number_group_memberships_per_cache_line		     maximum number of group memberships per cache line
_ksdxw_stack_readable					     dump readable stack when watchpoint is hit
_touch_sga_pages_during_allocation			     touch SGA pages during allocation
_realfree_heap_pagesize 				     hint for real-free page size in bytes
_realfree_pq_heap_pagesize				     hint for pq real-free page size in bytes
_kgh_restricted_trace					     trace level for heap dump-restricted mode
_kgh_restricted_subheaps				     number of subheaps in heap restricted mode
_defer_sga_enabled					     Enable deferred shared memory allocation for SGA
_defer_sga_min_total_defer_segs_sz			     Minimum total deferred segs size for defer sga allocation
_defer_sga_alloc_chunk_size				     Chunk size for defer sga allocation
_defer_sga_min_spsz_at_startup				     Minimum shared pool size at startup with deferred sga enabled
_defer_sga_test_alloc_intv				     SA** sleeps for N secs before allocating a deferred segment
_sga_alloc_slaves_term_timeout_secs			     Termination timeout in secs for SA** slaves
_ksmlsaf						     KSM log alloc and free
_pga_limit_target_perc					     default percent of pga_aggregate_target for pga_aggregate_limit
_pga_limit_watch_perc					     percentage of limit to have processes watch
_pga_limit_time_to_interrupt				     seconds to wait until direct interrupt
_pga_limit_interrupt_smaller				     whether to interrupt smaller eligible processes
_pga_limit_time_until_idle				     seconds to wait before treating process as idle
_pga_limit_time_until_killed				     seconds to wait before killing session over limit
_pga_limit_use_immediate_kill				     use immediate kill for sessions over limit
_pga_limit_dump_summary 				     dump PGA summary when signalling ORA-4036
_pga_limit_watch_size					     bytes of PGA usage at which process will begin watching limit
_pga_limit_min_req_size 				     bytes of PGA usage below which process will not get ORA-4036
_pga_limit_check_wait_time				     microseconds to wait for over limit confirmation
_pga_limit_simulated_physmem_size			     bytes of physical memory to determine pga_aggregate_limit with
_pga_limit_physmem_perc 				     default percent of physical memory for pga_aggregate_limit and SGA
_sga_data_protection_disabled				     disable SGA data protection
_sga_dp_precise_errors					     enable precise SGA data protection errors
_sga_heap_chunk_alignment				     force SGA heap chunk alignment
_sga_heap_chunk_alignment_disabled			     force SGA heap chunks not to be aligned
_sga_dp_bytes_per_alloc 				     bytes per allocation that have SGA data protection
_NUMA_bind_mode 					     Numa bind mode
pga_aggregate_limit					     limit of aggregate PGA memory consumed by the instance
_pga_limit_tracing					     trace pga_aggregate_limit activity
_test_param_8						     test parameter 8 - cdb tests
_highest_priority_processes				     Highest Priority Process Name Mask
_os_sched_highest_priority				     OS highest priority level
_bg_spawn_diag_opts					     background processes spawn diagnostic options
_mpmt_enabled_backgrounds				     mpmt enabled backgrounds
_background_process_opts				     Misc BG procs parameter
_kse_snap_ring_suppress 				     List of error numbers to suppress in the snap error history
_kse_snap_ring_disable					     set to TRUE or FALSE to disable or enable error logging
_enqueue_deadlock_detect_all_global_locks		     enable deadlock detection on all global enqueues
_enable_kernel_io_outliers				     enable kernel I/O outlier feature
_dnfs_rdma_max						     Maximum size of dNFS RDMA transfer
_dnfs_rdma_min						     Minimum size of dNFS RDMA transfer
_dnfs_rdma_enable					     Enable dNFS RDMA transfers
_simulate_logical_sectorsize				     Enables skgfr to report simulated logical disk sector size
_io_outlier_threshold					     Latency threshold for io_outlier table
_lgwr_io_outlier					     LGWR I/O outlier frequency
_asm_access						     ASM File access mechanism
_ksfd_fob_pct						     percentage of FOB state objects allocation
_use_dynamic_shares					     use dynamic shares
_dynamic_share_range_factor				     dynamic share range factor
_cpu_util_adj_force					     force cpu util adjustment
_cpu_util_adj_target					     cpu utilization adjustment target
_high_threshold_delta					     high threshold delta
db_performance_profile					     Database performance category
_rm_force_caging
_ksv_slave_exit_timeout 				     slave exit timeout
_twenty-ninth_spare_parameter				     twenty-ninth spare parameter - integer
_thirty-ninth_spare_parameter				     thirty-ninth spare parameter - integer
_forty-first_spare_parameter				     forty-first spare parameter - integer
_forty-second_spare_parameter				     forty-second spare parameter - integer
_forty-third_spare_parameter				     forty-third spare parameter - integer
_forty-fourth_spare_parameter				     forty-fourth spare parameter - integer
_forty-fifth_spare_parameter				     forty-fifth spare parameter - integer
_forty-sixth_spare_parameter				     forty-sixth spare parameter - integer
_forty-seventh_spare_parameter				     forty-seventh spare parameter - integer
_forty-eighth_spare_parameter				     forty-eighth spare parameter - integer
_forty-ninth_spare_parameter				     forty-ninth spare parameter - integer
_fiftieth_spare_parameter				     fiftieth spare parameter - integer
_fifty-first_spare_parameter				     fifty-first spare parameter - integer
_fifty-second_spare_parameter				     fifty-second spare parameter - integer
_fifty-third_spare_parameter				     fifty-third spare parameter - integer
_fifty-fourth_spare_parameter				     fifty-fourth spare parameter - integer
_fifty-fifth_spare_parameter				     fifty-fifth spare parameter - integer
_fifty-sixth_spare_parameter				     fifty-sixth spare parameter - integer
_fifty-seventh_spare_parameter				     fifty-seventh spare parameter - integer
_fifty-eighth_spare_parameter				     fifty-eighth spare parameter - integer
_fifty-ninth_spare_parameter				     fifty-ninth spare parameter - integer
_sixtieth_spare_parameter				     sixtieth spare parameter - integer
_sixty-first_spare_parameter				     sixty-first spare parameter - integer
_sixty-second_spare_parameter				     sixty-second spare parameter - integer
_sixty-third_spare_parameter				     sixty-third spare parameter - integer
_sixty-fourth_spare_parameter				     sixty-fourth spare parameter - integer
_sixty-fifth_spare_parameter				     sixty-fifth spare parameter - integer
_sixty-sixth_spare_parameter				     sixty-sixth spare parameter - integer
_sixty-seventh_spare_parameter				     sixty-seventh spare parameter - integer
_sixty-eighth_spare_parameter				     sixty-eighth spare parameter - integer
_sixty-ninth_spare_parameter				     sixty-ninth spare parameter - integer
_seventieth_spare_parameter				     seventieth spare parameter - integer
_seventy-first_spare_parameter				     seventy-first spare parameter - integer
_seventy-second_spare_parameter 			     seventy-second spare parameter - integer
_seventy-third_spare_parameter				     seventy-third spare parameter - integer
_seventy-fourth_spare_parameter 			     seventy-fourth spare parameter - integer
_seventy-fifth_spare_parameter				     seventy-fifth spare parameter - integer
_seventy-sixth_spare_parameter				     seventy-sixth spare parameter - integer
_seventy-seventh_spare_parameter			     seventy-seventh spare parameter - integer
_seventy-eighth_spare_parameter 			     seventy-eighth spare parameter - integer
_seventy-ninth_spare_parameter				     seventy-ninth spare parameter - integer
_eightieth_spare_parameter				     eightieth spare parameter - integer
_eighty-first_spare_parameter				     eighty-first spare parameter - string
_eighty-second_spare_parameter				     eighty-second spare parameter - string
_eighty-third_spare_parameter				     eighty-third spare parameter - string
_eighty-fourth_spare_parameter				     eighty-fourth spare parameter - string
_eighty-fifth_spare_parameter				     eighty-fifth spare parameter - string
_eighty-sixth_spare_parameter				     eighty-sixth spare parameter - string
_eighty-seventh_spare_parameter 			     eighty-seventh spare parameter - string
_eighty-eighth_spare_parameter				     eighty-eighth spare parameter - string
_eighty-ninth_spare_parameter				     eighty-ninth spare parameter - string
_ninetieth_spare_parameter				     ninetieth spare parameter - string
_ninety-first_spare_parameter				     ninety-first spare parameter - string
_ninety-second_spare_parameter				     ninety-second spare parameter - string
_ninety-third_spare_parameter				     ninety-third spare parameter - string
_ninety-fourth_spare_parameter				     ninety-fourth spare parameter - string
_ninety-fifth_spare_parameter				     ninety-fifth spare parameter - string
_ninety-sixth_spare_parameter				     ninety-sixth spare parameter - string
_ninety-seventh_spare_parameter 			     ninety-seventh spare parameter - string
_ninety-eighth_spare_parameter				     ninety-eighth spare parameter - string
_ninety-ninth_spare_parameter				     ninety-ninth spare parameter - string
_one-hundredth_spare_parameter				     one-hundredth spare parameter - string
_one-hundred-and-first_spare_parameter			     one-hundred-and-first spare parameter - string
_one-hundred-and-second_spare_parameter 		     one-hundred-and-second spare parameter - string
_one-hundred-and-third_spare_parameter			     one-hundred-and-third spare parameter - string
_one-hundred-and-fourth_spare_parameter 		     one-hundred-and-fourth spare parameter - string
_one-hundred-and-fifth_spare_parameter			     one-hundred-and-fifth spare parameter - string
_one-hundred-and-sixth_spare_parameter			     one-hundred-and-sixth spare parameter - string
_one-hundred-and-seventh_spare_parameter		     one-hundred-and-seventh spare parameter - string
_one-hundred-and-eighth_spare_parameter 		     one-hundred-and-eighth spare parameter - string
_one-hundred-and-ninth_spare_parameter			     one-hundred-and-ninth spare parameter - string
_one-hundred-and-tenth_spare_parameter			     one-hundred-and-tenth spare parameter - string
_one-hundred-and-eleventh_spare_parameter		     one-hundred-and-eleventh spare parameter - string
_one-hundred-and-twelfth_spare_parameter		     one-hundred-and-twelfth spare parameter - string
_one-hundred-and-thirteenth_spare_parameter		     one-hundred-and-thirteenth spare parameter - string
_one-hundred-and-fourteenth_spare_parameter		     one-hundred-and-fourteenth spare parameter - string
_one-hundred-and-fifteenth_spare_parameter		     one-hundred-and-fifteenth spare parameter - string
_one-hundred-and-sixteenth_spare_parameter		     one-hundred-and-sixteenth spare parameter - string
_one-hundred-and-seventeenth_spare_parameter		     one-hundred-and-seventeenth spare parameter - string
_one-hundred-and-eighteenth_spare_parameter		     one-hundred-and-eighteenth spare parameter - string
_one-hundred-and-nineteenth_spare_parameter		     one-hundred-and-nineteenth spare parameter - string
_one-hundred-and-twentieth_spare_parameter		     one-hundred-and-twentieth spare parameter - string
_one-hundred-and-twenty-first_spare_parameter		     one-hundred-and-twenty-first spare parameter - string
_one-hundred-and-twenty-second_spare_parameter		     one-hundred-and-twenty-second spare parameter - string
_one-hundred-and-twenty-third_spare_parameter		     one-hundred-and-twenty-third spare parameter - string
_one-hundred-and-twenty-fourth_spare_parameter		     one-hundred-and-twenty-fourth spare parameter - string
_one-hundred-and-twenty-fifth_spare_parameter		     one-hundred-and-twenty-fifth spare parameter - string
_one-hundred-and-twenty-sixth_spare_parameter		     one-hundred-and-twenty-sixth spare parameter - string
_one-hundred-and-twenty-seventh_spare_parameter 	     one-hundred-and-twenty-seventh spare parameter - string
_one-hundred-and-twenty-eighth_spare_parameter		     one-hundred-and-twenty-eighth spare parameter - string
_one-hundred-and-twenty-ninth_spare_parameter		     one-hundred-and-twenty-ninth spare parameter - string
_one-hundred-and-thirtieth_spare_parameter		     one-hundred-and-thirtieth spare parameter - string
_one-hundred-and-thirty-first_spare_parameter		     one-hundred-and-thirty-first spare parameter - string list
_one-hundred-and-thirty-second_spare_parameter		     one-hundred-and-thirty-second spare parameter - string list
_one-hundred-and-thirty-third_spare_parameter		     one-hundred-and-thirty-third spare parameter - string list
_one-hundred-and-thirty-fourth_spare_parameter		     one-hundred-and-thirty-fourth spare parameter - string list
_one-hundred-and-thirty-fifth_spare_parameter		     one-hundred-and-thirty-fifth spare parameter - string list
_one-hundred-and-thirty-sixth_spare_parameter		     one-hundred-and-thirty-sixth spare parameter - string list
_one-hundred-and-thirty-seventh_spare_parameter 	     one-hundred-and-thirty-seventh spare parameter - string list
_one-hundred-and-thirty-eighth_spare_parameter		     one-hundred-and-thirty-eighth spare parameter - string list
_one-hundred-and-thirty-ninth_spare_parameter		     one-hundred-and-thirty-ninth spare parameter - string list
_one-hundred-and-fortieth_spare_parameter		     one-hundred-and-fortieth spare parameter - string list
_one-hundred-and-forty-first_spare_parameter		     one-hundred-and-forty-first spare parameter - boolean
_one-hundred-and-forty-second_spare_parameter		     one-hundred-and-forty-second spare parameter - boolean
_one-hundred-and-forty-third_spare_parameter		     one-hundred-and-forty-third spare parameter - boolean
_one-hundred-and-forty-fourth_spare_parameter		     one-hundred-and-forty-fourth spare parameter - boolean
_one-hundred-and-forty-fifth_spare_parameter		     one-hundred-and-forty-fifth spare parameter - boolean
_one-hundred-and-forty-sixth_spare_parameter		     one-hundred-and-forty-sixth spare parameter - boolean
_one-hundred-and-forty-seventh_spare_parameter		     one-hundred-and-forty-seventh spare parameter - boolean
_one-hundred-and-forty-eighth_spare_parameter		     one-hundred-and-forty-eighth spare parameter - boolean
_one-hundred-and-forty-ninth_spare_parameter		     one-hundred-and-forty-ninth spare parameter - boolean
_one-hundred-and-fiftieth_spare_parameter		     one-hundred-and-fiftieth spare parameter - boolean
_one-hundred-and-fifty-first_spare_parameter		     one-hundred-and-fifty-first spare parameter - boolean
_one-hundred-and-fifty-second_spare_parameter		     one-hundred-and-fifty-second spare parameter - boolean
_one-hundred-and-fifty-third_spare_parameter		     one-hundred-and-fifty-third spare parameter - boolean
_one-hundred-and-fifty-fourth_spare_parameter		     one-hundred-and-fifty-fourth spare parameter - boolean
_one-hundred-and-fifty-fifth_spare_parameter		     one-hundred-and-fifty-fifth spare parameter - boolean
_one-hundred-and-fifty-sixth_spare_parameter		     one-hundred-and-fifty-sixth spare parameter - boolean
_one-hundred-and-fifty-seventh_spare_parameter		     one-hundred-and-fifty-seventh spare parameter - boolean
_one-hundred-and-fifty-eighth_spare_parameter		     one-hundred-and-fifty-eighth spare parameter - boolean
_one-hundred-and-fifty-ninth_spare_parameter		     one-hundred-and-fifty-ninth spare parameter - boolean
_one-hundred-and-sixtieth_spare_parameter		     one-hundred-and-sixtieth spare parameter - boolean
_one-hundred-and-sixty-first_spare_parameter		     one-hundred-and-sixty-first spare parameter - boolean
_one-hundred-and-sixty-second_spare_parameter		     one-hundred-and-sixty-second spare parameter - boolean
_one-hundred-and-sixty-third_spare_parameter		     one-hundred-and-sixty-third spare parameter - boolean
_one-hundred-and-sixty-fourth_spare_parameter		     one-hundred-and-sixty-fourth spare parameter - boolean
_one-hundred-and-sixty-fifth_spare_parameter		     one-hundred-and-sixty-fifth spare parameter - boolean
_one-hundred-and-sixty-sixth_spare_parameter		     one-hundred-and-sixty-sixth spare parameter - boolean
_one-hundred-and-sixty-seventh_spare_parameter		     one-hundred-and-sixty-seventh spare parameter - boolean
_one-hundred-and-sixty-eighth_spare_parameter		     one-hundred-and-sixty-eighth spare parameter - boolean
_one-hundred-and-sixty-ninth_spare_parameter		     one-hundred-and-sixty-ninth spare parameter - boolean
_one-hundred-and-seventieth_spare_parameter		     one-hundred-and-seventieth spare parameter - boolean
_one-hundred-and-seventy-first_spare_parameter		     one-hundred-and-seventy-first spare parameter - boolean
_one-hundred-and-seventy-second_spare_parameter 	     one-hundred-and-seventy-second spare parameter - boolean
_one-hundred-and-seventy-third_spare_parameter		     one-hundred-and-seventy-third spare parameter - boolean
_one-hundred-and-seventy-fourth_spare_parameter 	     one-hundred-and-seventy-fourth spare parameter - boolean
_one-hundred-and-seventy-fifth_spare_parameter		     one-hundred-and-seventy-fifth spare parameter - boolean
_one-hundred-and-seventy-sixth_spare_parameter		     one-hundred-and-seventy-sixth spare parameter - boolean
_one-hundred-and-seventy-seventh_spare_parameter	     one-hundred-and-seventy-seventh spare parameter - boolean
_one-hundred-and-seventy-eighth_spare_parameter 	     one-hundred-and-seventy-eighth spare parameter - boolean
_one-hundred-and-seventy-ninth_spare_parameter		     one-hundred-and-seventy-ninth spare parameter - boolean
_one-hundred-and-eightieth_spare_parameter		     one-hundred-and-eightieth spare parameter - boolean
_one-hundred-and-eighty-first_spare_parameter		     one-hundred-and-eighty-first spare parameter - boolean
_one-hundred-and-eighty-second_spare_parameter		     one-hundred-and-eighty-second spare parameter - boolean
_one-hundred-and-eighty-third_spare_parameter		     one-hundred-and-eighty-third spare parameter - boolean
_one-hundred-and-eighty-fourth_spare_parameter		     one-hundred-and-eighty-fourth spare parameter - boolean
_one-hundred-and-eighty-fifth_spare_parameter		     one-hundred-and-eighty-fifth spare parameter - boolean
_one-hundred-and-eighty-sixth_spare_parameter		     one-hundred-and-eighty-sixth spare parameter - boolean
_one-hundred-and-eighty-seventh_spare_parameter 	     one-hundred-and-eighty-seventh spare parameter - boolean
_one-hundred-and-eighty-eighth_spare_parameter		     one-hundred-and-eighty-eighth spare parameter - boolean
_one-hundred-and-eighty-ninth_spare_parameter		     one-hundred-and-eighty-ninth spare parameter - boolean
_one-hundred-and-ninetieth_spare_parameter		     one-hundred-and-ninetieth spare parameter - boolean
_one-hundred-and-ninety-first_spare_parameter		     one-hundred-and-ninety-first spare parameter - boolean
_one-hundred-and-ninety-second_spare_parameter		     one-hundred-and-ninety-second spare parameter - boolean
_one-hundred-and-ninety-third_spare_parameter		     one-hundred-and-ninety-third spare parameter - boolean
_one-hundred-and-ninety-fourth_spare_parameter		     one-hundred-and-ninety-fourth spare parameter - boolean
_one-hundred-and-ninety-fifth_spare_parameter		     one-hundred-and-ninety-fifth spare parameter - boolean
_one-hundred-and-ninety-sixth_spare_parameter		     one-hundred-and-ninety-sixth spare parameter - boolean
_one-hundred-and-ninety-seventh_spare_parameter 	     one-hundred-and-ninety-seventh spare parameter - boolean
_one-hundred-and-ninety-eighth_spare_parameter		     one-hundred-and-ninety-eighth spare parameter - boolean
_one-hundred-and-ninety-ninth_spare_parameter		     one-hundred-and-ninety-ninth spare parameter - boolean
_two-hundredth_spare_parameter				     two-hundredth spare parameter - boolean
_two-hundred-and-first_spare_parameter			     two-hundred-and-first spare parameter - boolean
_two-hundred-and-second_spare_parameter 		     two-hundred-and-second spare parameter - boolean
_two-hundred-and-third_spare_parameter			     two-hundred-and-third spare parameter - boolean
_two-hundred-and-fourth_spare_parameter 		     two-hundred-and-fourth spare parameter - boolean
_two-hundred-and-fifth_spare_parameter			     two-hundred-and-fifth spare parameter - boolean
_two-hundred-and-sixth_spare_parameter			     two-hundred-and-sixth spare parameter - boolean
_two-hundred-and-seventh_spare_parameter		     two-hundred-and-seventh spare parameter - boolean
_two-hundred-and-eighth_spare_parameter 		     two-hundred-and-eighth spare parameter - boolean
_two-hundred-and-ninth_spare_parameter			     two-hundred-and-ninth spare parameter - boolean
_two-hundred-and-tenth_spare_parameter			     two-hundred-and-tenth spare parameter - boolean
_two-hundred-and-eleventh_spare_parameter		     two-hundred-and-eleventh spare parameter - boolean
_two-hundred-and-twelfth_spare_parameter		     two-hundred-and-twelfth spare parameter - boolean
_two-hundred-and-thirteenth_spare_parameter		     two-hundred-and-thirteenth spare parameter - boolean
_two-hundred-and-fourteenth_spare_parameter		     two-hundred-and-fourteenth spare parameter - boolean
_two-hundred-and-fifteenth_spare_parameter		     two-hundred-and-fifteenth spare parameter - boolean
_two-hundred-and-sixteenth_spare_parameter		     two-hundred-and-sixteenth spare parameter - boolean
_two-hundred-and-seventeenth_spare_parameter		     two-hundred-and-seventeenth spare parameter - boolean
_two-hundred-and-eighteenth_spare_parameter		     two-hundred-and-eighteenth spare parameter - boolean
_two-hundred-and-nineteenth_spare_parameter		     two-hundred-and-nineteenth spare parameter - boolean
_two-hundred-and-twentieth_spare_parameter		     two-hundred-and-twentieth spare parameter - boolean
_ksipc_mode						     ksipc mode
_ksipc_libipc_path					     over-ride default location of libipc
_ksipc_wait_flags					     tune ksipcwait
_ksipc_spare_param1					     ksipc spare param 1
_ksipc_spare_param2					     ksipc spare param 2
_ksxp_ksmsq_ip_config					     ksxp ksmsq ip config
_ksxp_ipclw_enabled					     enable ipclw for KSXP
_ipc_config_opts_stat					     static config for ipclw startup
_ipc_config_opts_dyn					     Dyn config for ipclw startup
_ksipc_efchecks 					     Check HCA/OS version for Exafusion
_datapump_metadata_buffer_size				     specifies buffer size for metadata file I/O
_datapump_tabledata_buffer_size 			     specifies buffer size for table data file I/O
_datapump_compressbas_buffer_size			     specifies buffer size for BASIC compression algorithm
_midtier_affinity_cluswait_prc_threshold		     cluster wait precentage threshold to enter affinity
_disable_modsvc_refresh 				     disable modify service cache refresh
threaded_execution					     Threaded Execution Mode
_mpmt_single_process_instance				     MPMT - single process instance mode enabled
_mpmt_procs_per_osp					     max procs per osp
_prespawn_batch_count					     prespawn batch count
_dataguard_prespawn_count				     prespawn foreground init count
_proc_grp_enabled					     proc-group enabled
_min_time_between_psp0_diag_secs			     minimum time between PSP0 diagnostic used for flow control
_disable_rolling_patch					     Disable Rolling Patch Feature
_deadlock_record_to_alert_log				     record resolved deadlocks to the alert log
_process_heartbeat_range				     Process heartbeat range
_lthread_cleanup_intv_secs				     interval for cleaning lightweight threads in secs
_lthread_enabled					     Enable lightweight threads
_lthread_debug						     Enable Debugging mode for lightweight threads
_lthread_max_spawn_time_csecs				     maximum time interval a spawner will wait for a lthread to get ready
_lthread_spawn_check_intv_ms				     time interval for a spawner to check for spawnee to get ready
_lthread_clnup_pmon_softkill_wait_secs			     wait timeout for PMON between soft kill and hard kill of lthreads
_lthread_clnup_spawner_sk_wait_secs			     timeout for spawner between soft kill and hard kill of lthreads
_lthread_clnup_hk_wait_secs				     timeout after hard killing operation for lthread to exit
_lthread_step_debugging 				     Enable Step wise Debugging mode for lightweight threads
_full_diag_on_rim					     rim nodes have full DIA* function
_hang_cross_boundary_hang_detection_enabled		     Hang Management Cross Boundary detection
_hang_resolution_percent_hung_sessions_threshold	     Hang Manager hang resolution percent hung sessions threshold
_hang_terminate_session_replay_enabled			     Hang Management terminates sessions allowing replay
_diag_xm_enabled					     If TRUE, DIAG allows message exchanges across DB/ASM boundary
_hm_xm_enabled						     If TRUE, DIA0 allows message exchanges across DB/ASM boundary
_lm_hash_control					     bit field controlling the hashing behavior of the lock manager
_ges_server_processes					     number of background global enqueue server processes
_lm_lms_opt_priority					     enable freeslot lms priority optimization
_lm_lms_priority_check_frequency			     frequency of LMS priority decisions in milliseconds
_lm_db_rank						     rank of this DB for process priority purposes
_lm_db_ranks						     ranks of DBs on this node
_lm_cache_enqueue					     string of enqueues to cache at the client: separate by |, use DECIMAL identifier
							     s or '*' as wildcard, eg. AK-12-*

_lm_reloc_use_mhint					     if TRUE, AR-/AH-enqueues use mastering hints
_lm_rcfg_kjcdump_time					     dlm reconfiguration communication dump interval
_lm_enqueue_blocker_dump_timeout_cnt			     enqueue blocker dump timeout count
_lm_num_bnft_stats_buckets				     number of buckets in the benefit stats hash table
_lm_exchange_opt					     exchange step optimization in reconfig
_lm_drm_we_size 					     size of drm wait events statistics
_lm_drm_we_interval					     drm wait events collection interval in seconds
_read_mostly_instance					     indicates this is a read_mostly instance
_read_mostly_instance_qa_control			     internal parameter to control read mostly instance QA
_read_mostly_slave_timeout				     Time to wait on read mostly node when hub not available
_read_mostly_enable_logon				     Read mostly instances enable non-privileged logons
_lm_big_cluster_optimizations				     enable certain big cluster optimizations in drm
_ges_lmd_mapping					     enqueue to lmd mapping
_ges_hash_groups					     enqueue hash table groups
_ges_default_lmds					     default lmds for enqueue hashing
_ges_nres_divide					     how to divide number of enqueue resources among hash tables
_lm_drmopt12						     enable drm scan optimizations in 12
_lm_adrm_options					     active drm options
_lm_adrm_scan_timeout					     active drm f2a/flush scan timeout in centisecs
_lm_adrm_interval					     active drm interval in centiseconds
_lm_adrm_time_out					     active drm timeout in minutes
_lm_resend_open_convert_timeout 			     timeout in secs before resubmitting the open-convert
_lm_process_lock_q_scan_limit				     limit on scanning process lock queue instead of resource convert lock queue
_ges_gather_res_reuse_stats				     if TRUE, gather resource reuse statistics
_ges_freeable_res_chunk_free				     if TRUE, free dynamic resource chunks which are freeable
_lm_share_lock_restype					     string of resource types using S-lock optimisation
_ges_freeable_res_chunk_free_interval			     time interval for freeing freeable dynamic resource chunks
_ges_dump_open_locks					     if TRUE, dump open locks for the LCK process during shutdown
_lm_exadata_fence_type					     if FALSE disable Exadata fence type
_rond_test_mode 					     rac one node test mode
_adg_distributed_lockmaster				     standby runs under ADG distributed lockmaster mode
_kjdd_call_stack_dump_enabled				     Enables printing of short call stack with the WFG
_kjdd_wfg_dump_cntrl					     To control the way Wait-For_Graph is dumped
_omni_enqueue_enable					     Enable Omni Enqueue feature (0 = disable, 1 = enable on ASM (default), 2 = enabl
							     e)

_lm_idle_connection_kill_max_skips			     GES idle connection max skip kill request
_lm_idle_connection_quorum_threshold			     GES idle connection health quorum threshold
_lm_msg_pool_dump_threshold				     GES message pool dump threshold in terms of buffer count
_lm_msg_pool_user_callstack_dump			     GES message pool call stack dump upon exceeding of threshold
_lm_idle_connection_max_ignore_kill_count		     GES maximum idle connection kill request ignore count
_lm_mp_avail_queue_threshold				     GES MP avail queue threshold
_lm_mp_bulk_mbuf_free					     GES MP bulk free message buffer queues
_lm_wait_pending_send_queue				     GES wait on pending send queue
_lm_hashtable_bkt_low					     Low element threshold in hash table bucket
_lm_hashtable_bkt_high					     High element threshold in hash table bucket
_lm_hashtable_bkt_thr					     Threshold for hash table resizing
_lm_comm_tkts_adaptive					     Adpative ticketing enabled
_lm_comm_tkts_calc_period_length			     Weighted average calculation interval length (second)
_lm_comm_tkts_max_periods				     Max number of periods used in weighted avearage calculation
_lm_comm_tkts_min_increase_wait 			     Seconds to wait before allowing an allocation increase
_lm_comm_tkts_min_decrease_wait 			     Seconds to wait before allowing an allocation decrease
_lm_comm_tkts_nullreq_threshold 			     Null request threshold
_lm_comm_tkts_mult_factor				     Ticket allocation multiplication factor
_lm_comm_tkts_sub_factor				     Ticket allocation subtraction factor
_lm_comm_tkts_max_add					     Ticket allocation maximum allotments
_exafusion_enabled					     enable exafusion
_lm_comm_channel					     GES communication channel type
_lm_comm_msgq_busywait					     busy wait time in microsecond for msgq
_lm_comm_reap_count					     message reap count for receive
_lm_gl_hash_scheme					     group lock table hashing scheme (0|1|2)
_cluster_flash_cache_slave_file 			     cluster flash cache slave file for default block size
_gcs_res_hash_buckets					     number of gcs resource hash buckets to be allocated
_gcs_reserved_resources 				     allocate the number of reserved resources in reconfiguration
_gcs_min_slaves 					     if non zero, it enables the minimum number of gcs slaves
_gcs_dynamic_slaves					     if TRUE, it enables dynamic adjustment of the number of gcs slaves
_gcs_reserved_shadows					     allocate the number of reserved shadows in reconfiguration
_broadcast_scn_mode					     broadcast-on-commit scn mode
_nameservice_consistency_check				     NameService Consistency check switch
_nameservice_request_batching				     NameService request batching switch
_cgs_ticket_sendback					     CGS ticket active sendback percentage threshold
_cgs_msg_batch_size					     CGS message batch size in bytes
_cgs_msg_batching					     CGS message batching
_cgs_comm_readiness_check				     CGS communication readiness check
_imr_rr_holder_kill_time				     IMR max time instance is allowed to hold RR lock in seconds
_imr_check_css_incarnation_number			     IMR verify the global consistency of CSS incarnation number
_cgs_memberkill_from_rim_instance			     allow a RIM instance to issue a CSS member kill
_cgs_os_level_connection_check				     allow OS level connection and interface check
_cgs_os_level_connection_reqno				     number of ping rqst to process at once, threads created
_cgs_big_group_enabled					     big group membership support
_cgs_support_rim_disc					     rim instance disconnect and reconnect event support
_lm_rm_slaves						     if non zero, it enables remastering slaves
_lm_timed_statistics_level				     if non zero, it enables timed statistics on lmd and lms
_shutdown_sync_enable					     if TRUE, shutdown sync is issued before shutdown normal
_crs_2phase						     crs 2phase
_ges_vbfreelists					     number of valueblock freelists (will be adjusted to power of 2)
_lm_hb_enable_acl_check 				     to enable the wait analysis with acceptable condition lists
_lm_hb_acceptable_hang_condition			     list of acceptable hang conditions in heartbeat check
_lm_hb_maximum_hang_report_count			     maximum heartbeat hang report count
_lm_hb_exponential_hang_time_factor			     heartbeat exponential hang time multiplier
_gcr_enable_high_memory_kill				     if TRUE, GCR may kill foregrounds under high memory load
_gcr_high_memory_threshold				     minimum amount of Memory process must consume to be kill target
_gcr_cpu_min_free					     minimum amount of free CPU to flag an anomaly
_gcr_mem_min_free					     minimum amount of free memory to flag an anomaly
_gcr_css_use_2group_lock				     if FALSE, GCR will not try to lock 2 CSS groups at the same time
_gcr_css_group_try_lock_delay				     minimum delay between group locking attempts, secs
_gcr_css_group_query_boost				     allowed number of serial multiple queries
_gcr_css_group_update_interval				     interval between CSS group updates, secs
_gcr_css_group_update2_interval 			     interval between CSS group updates when busy, secs
_gcr_css_group_large					     size of large CSS group above which query/update disabled
_gcr_tick						     duration of time tick used by state machine, centisecs
_gcr_enable_statistical_cpu_check			     if FALSE, revert to old cpu load metric
_gcr_enable_new_drm_check				     if FALSE, revert to old drm load metric
_gcr_max_rt_procs					     maximum number of RT DLM processes allowed by GCR
_kjac_force_outcome_current_session			     if TRUE, enable to run force outcome on the current session
_ka_enabled						     Enable/disable kernel accelerator
_ka_mode						     kernel accelerator mode
_ka_locks_per_sector					     locks per sector in kernel accelerator
_ka_msg_reap_count					     maximum number of KA messages to receive and process per wait
_ka_compatibility_requirement				     kernel accelerator compatibility operation requirement
_ka_allow_reenable					     reenability of kernel accelerator service after disable
_ka_pbatch_messages					     kernel accelerator perform pbatch messages
_ka_doorbell						     kernel accelerator doorbell mode
_ka_scn_enabled 					     KA SCN processing enabled
_ka_scn_accel_shrmem					     KA SCN accelerate shr memory
_ka_scn_use_ka_msgs					     KA SCN use KA type messages
_ka_grant_policy					     KA grant policy to favor fusion grant, make it automatic, or favor KA
_ka_msg_wait_count					     KA maximum number of requests to retrieve per OSD wait
_ka_max_wait_delay					     KA maximum amount of time before forcing OSD wait call
_gcs_cluster_flash_cache_mode				     cluster flash cache mode
_gcs_flash_cache_mode					     flash cache mode
_max_defer_gran_xfer_atonce				     Maximum deferred granules transferred by MMAN atonce
_asm_allow_small_memory_target				     Allow a small memory_target for ASM instances
_controlfile_split_brain_check				     Check for a split-brain in distributed lock manager domain
db_big_table_cache_percent_target			     Big table cache target size in percentage
_db_full_db_cache_diff_pct				     Cache at least this % larger than DB size for full db caching
_db_writer_coalesce_encrypted_buffers			     Coalecsing for encrypted buffers
_dbwr_stall_write_detection_interval			     dbwriter stall write detection interval
_pin_time_statistics					     if TRUE collect statistics for how long a current pin is held
_adg_buffer_wait_timeout				     Active Dataguard buffer wait time in cs
_db_full_caching					     enable full db implicit caching
_db_flash_cache_disable_write_batchsize 		     Flash cache disable writes processing batchsize
_switch_current_scan_scn				     switch current uses scan scn
_cleanout_shrcur_buffers				     if TRUE, cleanout shrcur buffers
_child_read_ahead_dba_check				     if TRUE, assert child read ahead dba to be continuous of parent
_data_warehousing_scan_buffers				     if TRUE, enable data warehousing scan buffers
_data_warehousing_scan_flash_buffers			     if TRUE, enable data warehousing scan flash buffers
_data_warehousing_serial_scan				     if TRUE, enable data warehousing serial scans
_db_dw_scan_obj_cooling_policy				     DW scan objtect cooling policy
_db_dw_scan_obj_cooling_interval			     DW Scan object cooling interval in number of scans, seconds, or pct of cache siz
							     e

_db_dw_scan_obj_cooling_factor				     DW Scan object cooling factor to cool all temperatures
_db_dw_scan_obj_warming_increment			     DW Scan object warming increment when an object is scanned
_db_dw_scan_adaptive_cooling				     if TRUE, enable adaptive DW scan cooling
_db_dw_scan_max_shadow_count				     DW Scan adaptive cooling max shadow count
_pq_numa_working_set_affinity				     if TRUE, enable pq slave NUMA affinity
_db_cache_advice_hash_latch_multiple			     cache advisory hash latch multiple
_redo_log_record_life					     Life time in hours for redo log table records
_redo_log_debug_config					     Various configuration flags for debugging redo logs
_redo_log_check_backup					     time interval in minutes between wakeups to check backup of redo logs
_cache_orl_during_open					     cache online logs
_target_log_write_size					     Do log write if this many redo blocks in buffer (auto=0)
_target_log_write_size_timeout				     How long LGWR will wait for redo to accumulate (csecs)
_use_single_log_writer					     Use a single process for redo log writing
_max_outstanding_log_writes				     Maximum number of outstanding redo log writes
_adaptive_scalable_log_writer_enable_worker_threshold	     Increase in redo generation rate as a percentage
_adaptive_scalable_log_writer_disable_worker_threshold	     Percentage of overlap across multiple outstanding writes
_adaptive_scalable_log_writer_sampling_count		     Evaluate single versus scalable LGWR every N writes
_adaptive_scalable_log_writer_sampling_time		     Evaluate single versus scalable LGWR every N seconds
_adaptive_scalable_log_writer_enable_worker_aging	     Per million of redo gen rate when LGWR workers were last used
_max_log_write_parallelism				     Maximum parallelism within a log write (auto=0)
_max_log_write_io_parallelism				     Maximum I/O parallelism within a log write (auto=0)
_serial_log_write_worker_io				     Serialize log write slave I/O
_simulated_log_write_usecs				     Simulated latency of log writes (usecs)
_adaptive_log_file_sync_use_postwait_threshold_aging	     Permille of foreground load from when post/wait was last used
_adaptive_log_file_sync_sampling_count			     Evaluate post/wait versus polling every N writes
_adaptive_log_file_sync_sampling_time			     Evaluate post/wait versus polling every N seconds
_check_pdbid_in_redo					     Enable checking of pluggable database ID in redo
_ping_wait_for_log_force				     Wait for log force before block ping
_log_writer_worker_dlm_hearbeat_update_freq		     LGWR worker DLM health-monitoring heartbeat update frequency (ms)
_hb_redo_interval					     generic heartbeat redo frequency
_disable_file_resize_logging				     disable file resize logging to alert log
_file_set_enqueue_timeout				     Timeout to acquire file set enqueue (secs)
_file_offline_sync_timeout				     Timeout to sync file offline enqueue (secs)
_gc_policy_rm_dirty_percent				     percent of cache which can be dirty for readmostly
_gc_dump_remote_lock					     if TRUE, dump remote lock
_gc_save_cleanout					     if TRUE, save cleanout to apply later
_gc_temp_affinity					     if TRUE, enable global temporary affinity
_gc_fg_spin_time					     foreground msgq spin time
_gc_async_send						     send blocks asynchronously
_gc_try_to_skip_imc_flush				     if TRUE, try to skip an imc populate flush
_gc_msgq_buffer_size					     MSGQ buffer size
_gc_msgq_buffers					     number of MSGQ buffers
_gc_serve_from_flash_cache				     if TRUE, try to serve a flash cache buffer
_gc_trace_freelist_empty				     if TRUE, dump a trace when we run out of lock elements
_kcbl_assert_reset_slot 				     assert slot state in kcblResetSlot
_thread_state_change_timeout_pnp			     Thread state change timeout for PnP instance (in sec)
_allow_file_1_offline_error_1245			     don't signal ORA-1245 due to file 1 being offline
_switchover_timeout					     Switchover timeout in minutes
_fast_psby_conversion					     Enable fast physical standby conversion
_ac_enable_dscn_in_rac					     Enable Dependent Commit SCN tracking
_ac_strict_SCN_check					     enforce strict SCN check for AC replay across DG failover
_allow_convert_to_standby				     allow convert to standby to go through
_early_flush_delta					     SCN delta to trigger early log flush
_backup_ksfq_bufmem_max 				     maximum amount of memory (in bytes) used for buffers for backup/restore
_backup_min_ct_unused_optim				     mimimun size in bytes of change tracking to apply unused space optimuzation
_krb_trace_buffer_size					     size of per-process I/O trace buffer
_catalog_foreign_restore				     catalog foreign file restore
_prefered_standby					     standby db_unique_name prefered for krb operations
_krbabr_trace_buffer_size				     size of I/O trace buffer
_backup_appliance_enabled				     Backup Appliance Enabled
_ba_container_filesystem_ausize 			     allocation unit size for Backup Appliance containers
_ba_max_groups						     maximum number of Backup Appliance container groups
_ba_max_containers					     maximum number of Backup Appliance containers
_ba_max_seg_bytes					     maximum number of bytes per array segment
_ba_cf_trace_buffer_size				     size of per-process I/O KBC trace buffer
_ba_timeouts_enabled					     enable timeouts
_aux_dfc_keep_time					     auxiliary datafile copy keep time in minutes
_undo_tbs_slave_percent 				     Percentage of redo slaves for undo tablespace
_clone_one_pdb_recovery 				     Recover ROOT and only one PDB in clone database
_time_based_rcv_ckpt_target				     time-based incremental recovery checkpoint target in sec
_time_based_rcv_hdr_update_interval			     time-based incremental recovery file header update interval in sec
_use_pdb_parselock					     use PDB level parselock on ADG
_snapshot_recovery_enabled				     enable/disable snapshot recovery
_bct_public_dba_buffer_dynresize			     allow dynamic resizing of public dba buffers, zero to disable
_bct_public_dba_buffer_maxsize				     max buffer size permitted for public dba buffers, in bytes
_krc_trace_buffer_size					     size of I/O trace buffer
_kra_trace_buffer_size					     size of I/O trace buffer
_kcfis_qm_prioritize_sys_plan				     Prioritize Quaranitine Manager system plan
_kcfis_qm_user_plan_name				     Quaranitine Manager user plan name
_kcfis_xtgran_prefetch_count				     External Table Smart Scan granule prefetch count
_nologging_sendbuf_ratio				     Nologging standby: outstanding send buffer ratio
_nologging_load_slotsz					     Nologging standby: direct load buffer size
_force_logging_in_upgrade				     force logging during upgrade mode
_nologging_kcnbuf_hash_buckets				     Number of nologging buffer hash buckets
_nologging_kcnbuf_hash_latches				     Number of nologging buffer hash latches
_nologging_sdcl_append_wait				     Nologging standby append sdcl wait time
_nologging_txn_cmt_wait 				     Nologging standby transaction commit wait time
_max_data_transfer_cache_size				     Maximum size of data transfer cache
_data_transfer_cache_bc_perc_x100			     Percentange * 100 of buffer cache to transfer to data transfer cache
_data_transfer_cache_size				     Size of data transfer cache
__data_transfer_cache_size				     Actual size of data transfer cache
_max_kcnibr_ranges					     Max number of nonlogged data block ranges
_log_undo_df_info					     generate marker to log file# that belong to undo tablespace
_cvmap_buffers						     Number of change vector buffers for multi instance media recovery
_txn_control_trace_buf_size				     size the in-memory buffer size of txn control
_collect_tempundo_stats 				     Collect Statistics v$tempundostat
temp_undo_enabled					     is temporary undo enabled
_temp_undo_disable_adg					     is temp undo disabled on ADG
_resumable_critical_alert				     raise critical alert for resumable failure
_securefile_log_num_latches				     Maximum number of open descriptors for securefile log
_securefile_log_shared_pool_size			     Size of securefile log buffer pool from SGA
_cli_cachebktalloc					     Percentage of memory to allocate
_ilm_mem_limit						     percentage of the max shared pool heat-map can use - internal
_ktilmsc_exp						     expiration time of ktilm segment cache (in second)
_inmemory_check_prot_meta				     If true, marks SMU area read only to prevent stray writes
_inmemory_private_journal_quota 			     quota for transaction in-memory private journals
_inmemory_private_journal_sharedpool_quota		     quota for transaction in-memory objects
_inmemory_private_journal_numbkts			     Number of priv jrnl ht bkts
_inmemory_private_journal_numgran			     Number of granules per HT node
_inmemory_jscan 					     inmemory jscan enable
_inmemory_pin_hist_mode 				     settings for IM pinned buffer history
_inmemory_txn_checksum					     checksum for SMUs and private journals
_inmemory_buffer_waittime				     wait interval for one SMU or IMCU to be freed
_inmemory_cu_timeout					     maximum wait time for one IMCU to be freed
_inmemory_cudrop_timeout				     maximum wait time for IMCU to be freed during drop
_inmemory_exclto_timeout				     maximum wait time to pin SMU for cleanout
_inmemory_num_hash_latches				     Maximum number of latches for IM buffers
_inmemory_strdlxid_timeout				     max time to determine straddling transactions
_inmemory_incremental_repopulation			     If true, incremental repopulation of IMCU will be attempted
_inmemory_lock_for_smucreate				     take object lock during smu creation
_old_extent_scheme					     Revert to old extent allocation
_trace_temp						     Trace Tempspace Management
_concurrency_chosen					     what is the chosen value of concurrency
_no_small_file						     Not to apply new extent scheme for small file temp spaces
_assm_test_force_rej					     assm min number of blocks to cbk-reject
_assm_test_force_rej2					     assm min number of blocks to kdt-reject
_assm_test_reentrant_gsp				     assm test reentrant gsp
_disable_flashback_recyclebin_opt			     Don't use the Flashback Recyclebin optimization
_enable_securefile_flashback_opt			     Enable securefile flashback optimization
_enable_12g_bft 					     enable 12g bigfile tablespace
_undotbs_stepdown_pcent 				     Undo Tablespace small allocation step down percentage
_undotbs_regular_tables 				     Create regular tables in undo tablespace
_minmax_spacebg_slaves					     min-max space management background slaves
_min_spacebg_slaves					     minimum space management background slaves
_securefiles_breakreten_retry				     segment retry before dishonoring retention
_securefiles_spcutl					     securefiles segment utl optimization
_trace_ktfs						     Trace ILM Stats Tracking
_trace_ktfs_mem 					     Debug memleak
heat_map						     ILM Heatmap Tracking
_enable_ilm_flush_stats 				     Enable ILM Stats Flush
_enable_ilm_testflush_stats				     Enable Test ILM Stats Flush
_disable_12cbigfile					     DIsable Storing ILM Statistics in 12cBigFiles
_enable_heatmap_internal				     heatmap related - to be used by oracle dev only
_heatmap_format_1block					     heatmap related - to be used by oracle dev only
_test_hm_extent_map					     heatmap related - to be used by oracle dev only
_ilmset_stat_limit					     ILM set statistics limit - Internal testing only
_ilmflush_stat_limit					     ILM flush statistics limit - Internal testing only
_heatmap_min_maxsize					     Internal testing only
_ilmstat_memlimit					     Percentage of shared pool for use by ILM Statistics
_flush_ilm_stats					     flush ilm stats
_create_stat_segment					     create ilm statistics segment
_drop_stat_segment					     drop ilm statistics segment
_print_stat_segment					     print ilm statistics segment
_print_inmem_heatmap					     print inmem ilm heatmap
_inmemory_auto_distribute				     If true, enable auto distribute
_inmemory_autodist_2safe				     If true, enable auto distribute with 2safe
_inmemory_distribute_timeout				     If true, enable auto distribute with 2safe
_inmemory_distribute_ondemand_timeout			     On demand timeout for redistribute
inmemory_size						     size in bytes of in-memory area
_inmemory_64k_percent					     percentage of in-memory area for 64k pools
_inmemory_min_ima_defersize				     Defer in-memory area allocation beyond this size
_inmemory_memprot					     enable or disable memory protection for in-memory
_trace_ktds						     Trace block reuse
_track_space_reuse					     SpaceReuse Tracking
_spacereuse_track_memlimit				     Percentage of shared pool for use by spacereuse tracking
_print_inmem_srmap					     print inmem spacereuse map
_sage_block_checking					     enable block checking of blocks returned by smartscan
_suppress_identifiers_on_dupkey 			     supress owner index name err msg
_widetab_comp_enabled					     wide table compression enabled
_force_sys_compress					     Sys compress
_oltp_comp_dbg_scan					     oltp compression scan debug
_cu_row_locking 					     CU row level locking
_oltp_spill						     spill rows for oltp compression if loader pga limit is exceeded
_pdb_use_sequence_cache 				     Use sequence cache in PDB mode
_index_max_inc_trans_pct				     max itl expand percentage soft limit during index insert
_advanced_index_compression_options			     advanced index compression options
_advanced_index_compression_options_value		     advanced index compression options2
_advanced_index_compression_trace			     advanced index compression trace
db_index_compression_inheritance			     options for table or tablespace level compression inheritance
_ldr_tempseg_threshold					     amount to buffer prior to allocating temp segment (extent sizing)
_kdli_descn_adj 					     coalesce extents with deallocation scn adjustment
_kdli_mts_so						     use state objects in shared server for asyncIO pipelines
_kdli_ralc_length					     lob length threshold to trigger rounded allocations
_kdli_ralc_rounding					     rounding granularity for rounded allocations
_kdli_space_cache_segments				     #segments in space cache
_sf_default_enabled					     enable 12g securefile default
_kdlf_read_flag 					     kdlf read flag
_kdz_pcode_flags					     pcode flags
_enable_columnar_cache					     Enable Columnar Flash Cache Rewrite
_kdz_proj_nrows 					     Number of rows to project at a time in kdzt
_kdz_pred_nrows 					     Number of rows to predicate at a time in kdzt
_kdzk_enable_init_trace 				     Enable kdzk initialization tracing
_kdzk_load_specialized_library				     Flags for loading HPK specialized library
_kdzk_trace_level					     HPK trace level
_hpk_project_cost_weighting				     hpk project cost weighting
_hpk_throughput_range					     hpk throughput range
_hpk_compression_range					     hpk compression range
_inmemory_analyzer_optimize_for 			     inmemory analyzer optimize for
_dbfs_modify_implicit_fetch				     DBFS Link allows implicit fetch on modify - only on SecureFiles
_ILM_FILTER_TIME					     Upper filter time for ILM block compression
_ILM_FILTER_TIME_LOWER					     Lower filter time for ILM block compression
_ILM_POLICY_NAME					     User specified ILM policy name
_inmemory_default_flags 				     Default flags based on inmemory_clause_default
_inmemory_default_new					     Force in-memory on new tables
inmemory_clause_default 				     Default in-memory clause for new tables
inmemory_force						     Force tables to be in-memory or not
inmemory_query						     Specifies whether in-memory queries are allowed
_inmemory_query_scan					     In-memory scan enabled
_inmemory_scan_override 				     In-memory scan override
_inmemory_scan_threshold_percent_noscan 		     In-memory scan threshold maximum percent dirty no scan
_inmemory_small_segment_threshold			     In-memory small segment threshold (must be larger for in-memory)
_inmemory_query_fetch_by_rowid				     In-memory fetch-by-rowid enabled
_inmemory_pruning					     In-memory pruning
_inmemory_enable_sys					     enable in-memory on system tablespace with sys user
_inmemory_populate_fg					     populate in foreground
_inmemory_pga_per_server				     minimum pga needed per inmemory populate server
inmemory_max_populate_servers				     maximum inmemory populate servers
_inmemory_servers_throttle_pgalim_percent		     In-memory populate servers throttling pga limit percentage
inmemory_trickle_repopulate_servers_percent		     inmemory trickle repopulate servers percent
_inmemory_populate_wait 				     wait for population to complete
_inmemory_populate_wait_max				     maximum wait time in seconds for segment populate
_inmemory_imco_cycle					     IMCO cycle in seconds (sleep period)
_inmemory_enable_population_verify			     verify in-memory population
_inmemory_log_level					     in-memory log level
_inmemory_fs_verify					     in-memory faststart verify
_inmemory_force_fs					     in-memory faststart force
_inmemory_force_fs_tbs					     in-memory faststart force tablespace
_inmemory_force_fs_tbs_size				     in-memory faststart force tablespace size
_inmemory_fs_raise_error				     in-memory faststart raise error
_inmemory_fs_nodml					     in-memory faststart assumes no dmls while populating
_inmemory_fs_enable					     in-memory faststart enable
_inmemory_fs_enable_blk_lvl_inv 			     in-memory faststart enable block level invalidation
_inmemory_fs_blk_inv_blkcnt				     in-memory faststart CU invalidation threshold(blocks)
_inmemory_fs_blk_inv_blk_percent			     in-memory faststart CU invalidation threshold(blocks)
_inmemory_enable_stat_alert				     dump in-memory stats in alert log file
_inmemory_imcu_align					     Enforce 8M IMCU alignment
_inmemory_max_populate_retry				     IM populate maximum number of retry
_inmemory_imcu_target_rows				     IMCU target number of rows
_inmemory_imcu_target_bytes				     IMCU target size in bytes
_inmemory_imcu_source_extents				     number of source extents per IMCU
_inmemory_imcu_source_blocks				     number of source blocks per IMCU
_inmemory_imcu_source_minbytes				     number of minimum source bytes per IMCU
_inmemory_imcu_populate_minbytes			     minimum free space in IMA for populating IMCU
_inmemory_imcu_source_analyze_bytes			     number of source analyze bytes per IMCU
_inmemory_imcu_target_maxrows				     IMCU maximum target number of rows
_inmemory_imcu_source_maxbytes				     IMCU maximum source size in bytes
_inmemory_max_queued_tasks				     Maximum queued populating tasks on the auxiliary queue
_inmemory_repopulate_threshold_rows			     In-memory repopulate threshold number of modified rows
_inmemory_repopulate_threshold_blocks			     In-memory repopulate threshold number of modified blocks
_inmemory_pct_inv_rows_invalidate_imcu			     In-memory percentage invalid rows for IMCU invalidation
_inmemory_pct_inv_blocks_invalidate_imcu		     In-memory percentage invalid blocks for IMCU invalidation
_inmemory_repopulate_threshold_mintime_factor		     In-memory repopulate minimum interval (N*timetorepop)
_inmemory_repopulate_threshold_mintime			     In-memory repopulate minimum interval (millisec)
_inmemory_repopulate_threshold_scans			     In-memory repopulate threshold number of scans
_inmemory_repopulate_priority_scale_factor		     In-memory repopulate priority threshold scale factor
_inmemory_repopulate_invalidate_rate_percent		     In-memory repopulate invalidate rate percent
_inmemory_repopulate_priority_threshold_row		     In-memory repopulate priority threshold row
_inmemory_repopulate_priority_threshold_block		     In-memory repopulate priority threshold block
_inmemory_repopulate_threshold_rows_percent		     In-memory repopulate threshold rows invalid percentage
_inmemory_repopulate_threshold_blocks_percent		     In-memory repopulate threshold blocks invalid percentage
_inmemory_repopulate_disable				     disable In-memory repopulate
_inmemory_check_protect 				     If true, marks in-memory area read only to prevent stray writes
_inmemory_checksum					     If true, checksums in-memory area to detect stray writes
_inmemory_validate_fetch				     If true, validate single-row fetch between in-memory and disk
_inmemory_journal_row_logging				     If true, log the entire row into the in-memory journal
_inmemory_journal_check 				     Depending on value does one of the DML verifications
_inmemory_rows_check_interrupt				     Number of rows buffered before interrupt check
_inmemory_dbg_scan					     In-memory scan debugging
_inmemory_segment_populate_verify			     In-memory segment populate verification
_inmemory_query_check					     In-memory query checking
_inmemory_test_verification				     In-memory verification testing
_inmemory_invalidate_cursors				     In-memory populate enable cursor invalidations
_inmemory_prepopulate_fg				     Force prepopulate of in-memory segment in foreground
_inmemory_prepopulate					     Enable inmemory populate by IMCO
_inmemory_trickle_repopulate				     Enable inmemory trickle repopulate
_inmemory_trickle_repopulate_threshold_dirty_ratio	     IMCO Trickle Repopulate threshold dirty ratio
_inmemory_trickle_repopulate_min_interval		     IMCO Trickle Repopulate Interval
_inmemory_trickle_repopulate_fg 			     Trickle Repopulate in the Foreground
_inmemory_force_non_engineered				     force non-engineered systems in-memory behavior on RAC
_inmemory_suppress_vsga_ima				     Suppress inmemory area in v$sga
_index_load_buf_oltp_sacrifice_pct			     index load buf oltp sacrifice pct
_index_load_buf_oltp_under_pct				     index load buf and comp oltp under-estimation pct
_kdizoltp_uncompsentinal_freq				     kdizoltp uncomp sentinal frequency
_kqdsn_min_instance_bits				     minimum bits used for instance value in sequence partition
_kqdsn_max_instance_bits				     maximum bits used for instance value in sequence partition
_kqdsn_partition_ratio					     ratio of instance to session bits in sequence partition
_kgl_large_heap_assert_threshold			     maximum heap size before KGL raises an internal error
_revoke_new_semantics					     Enable revoke semantics
_tsenc_obfuscate_key					     Encryption key obfuscation in memory
_db_discard_lost_masterkey				     discard lost masterkey handles
_db_generate_dummy_masterkey				     if TRUE, use old havior and generate dummy master key
_use_fips_mode						     Enable use of crypographic libraries in FIPS mode
DBFIPS_140						     Enable use of crypographic libraries in FIPS mode, public
_pbkdf2_sder_count					     The PBKDF2 count to use for session key derivation
_resource_includes_unlimited_tablespace 		     Whether RESOURCE role includes UNLIMITED TABLESPACE privilege
_xs_cleanup_task					     Triton Session Cleanup
_xds_max_child_cursors					     Maximum number of XDS user-specific child cursors
_xs_dispatcher_only					     XS dispatcher only mode
_unified_audit_policy_disabled				     Disable Default Unified Audit Policies on DB Create
unified_audit_sga_queue_size				     Size of Unified audit SGA Queue
_unified_audit_flush_threshold				     Unified Audit SGA Queue Flush Threshold
_unified_audit_flush_interval				     Unified Audit SGA Queue Flush Interval
_reco_sessions_max_percentage				     allowed RECO sessions as a percentage of total sessions allowed
_disable_duplicate_service_warning			     disable listener warning for duplicate service
_dispatcher_listen_on_vip				     Determines if dispatcher listens on VIP if no HOST is supplied
use_dedicated_broker					     Use dedicated connection broker
_mpmt_fg_enabled					     MPMT mode foreground enabled
connection_brokers					     connection brokers specification
_cursor_reload_failure_threshold			     Number of failed reloads before marking cursor unusable
_kks_obsolete_dump_threshold				     Number of parent cursor obsoletions before dumping cursor
_plsql_icd_arg_dump					     Dump arguments to ICD
_redef_on_statement					     Use on-statement refresh in online redefinition
_AllowMultInsteadofDDLTrigger				     Oracle internal parameter to allow multiple instead of DDL triggers
_kktAllowInsteadOfDDLTriggeronDDL			     Oracle internal parameter to allow instead of DDL triggers on specified DDLs
_lock_next_constraint_count				     max number of attempts to lock _NEXT_CONSTRAINT
_max_string_size_bypass 				     controls error checking for the max_string_size parameter
_bigdata_external_table 				     enables use of ORACLE_HIVE and ORACLE_HDFS access drivers
_kxscio_cap_stacks					     capture location when kxscio is set to null
_px_proactive_slave_alloc_threshold			     parallel proactive slave allocation threshold/unit
_px_load_balancing_policy				     parallel load balancing policy
_px_dp_array_size					     Max number of pq processes supported
_sort_sync_min_spillsize				     controls the size of mininum run size for synchronized spill (in kb)
_sort_sync_min_spill_threshold				     controls the mininum spill size for synchronized spill (in percent)
_cell_offload_expressions				     enable offload of expressions to cells
_cell_materialize_virtual_columns			     enable offload of expressions underlying virtual columns to cells
_cell_materialize_all_expressions			     Force materialization of all offloadable expressions on the cells
_cell_offload_sys_context				     enable offload of SYS_CONTEXT evaluation to cells
_gby_vector_aggregation_enabled 			     enable group-by and aggregation using vector scheme
_optimizer_vector_transformation			     perform vector transform
_optimizer_vector_fact_dim_ratio			     cost based vector transform dimension to fact ratio
_key_vector_max_size					     maximum key vector size (in KB)
_key_vector_predicate_enabled				     enables or disables key vector filter predicate pushdown
_key_vector_predicate_threshold 			     selectivity pct for key vector filter predicate pushdown
_key_vector_offload					     controls key vector offload to cells
_key_vector_caching					     Enables vector key vector caching
_vector_operations_control				     control different uses/algorithms related to vector transform
_optimizer_vector_min_fact_rows 			     min number of rows required for vector aggregation transform
_vector_serialize_temp_threshold			     threshold for serializing vector transform temp table writes
_always_vector_transformation				     always favor use of vector transformation
_vector_aggregation_max_size				     max size of vector aggregation space
_optimizer_key_vector_aggr_factor			     the required aggregation between IJK and DGK
_optimizer_vector_cost_adj				     cost adjustment for vector aggregation processing estimates
_crash_domain_on_exception				     allow domain to exit for exceptions in any thread
_odci_aggregate_save_space				     trade speed for space in user-defined aggregation
_cell_storidx_minmax_enabled				     enable Storage Index Min/Max optimization on the cells
_cell_offload_complex_processing			     enable complex SQL processing offload to cells
_optimizer_partial_join_eval				     partial join evaluation parameter
_optimizer_unnest_scalar_sq				     enables unnesting of of scalar subquery
_px_object_sampling					     parallel query sampling for base objects (100000 = 100%)
_utlmmig_table_stats_gathering				     enable/disable utlmmig table stats gathering at upgrade
_remove_exf_component					     enable/disable removing of components EXF and RUL during upgrade
_bloom_filter_size					     bloom filter vector size (in KB)
_bloom_predicate_offload				     enables or disables bloom filter predicate offload to cells
_bloom_rm_filter					     remove bloom predicate in favor of zonemap join pruning predicate
_dbop_enabled						     Any positive number enables automatic DBOP monitoring. 0 is disabled
_optimizer_ansi_join_lateral_enhance			     optimization of left/full ansi-joins and lateral views
_optimizer_multi_table_outerjoin			     allows multiple tables on the left of outerjoin
_optimizer_null_accepting_semijoin			     enables null-accepting semijoin
_optimizer_ansi_rearchitecture				     re-architecture of ANSI left, right, and full outer joins
_optimizer_aggr_groupby_elim				     group-by and aggregation elimination
_optimizer_gather_feedback				     optimizer gather feedback
_part_redef_global_index_update 			     online partition redefinition update global indexes
_optimizer_generate_transitive_pred			     optimizer generate transitive predicates
_optimizer_cube_join_enabled				     enable cube join
max_string_size 					     controls maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL
_dm_enable_legacy_dmf_output_types			     revert dmf output types to pre-12.1.0.1
_dm_dmf_details_compatibility				     set dm dmf details compatibility version
_optimizer_hybrid_fpwj_enabled				     enable hybrid full partition-wise join when TRUE
_px_message_compression 				     enable compression of control messages for parallel query
_px_object_sampling_enabled				     use base object sampling when possible for range distribution
_px_concurrent						     enables pq with concurrent execution of serial inputs
_px_back_to_parallel					     allow going back to parallel after a serial operation
_scalar_type_lob_storage_threshold			     threshold for VARCHAR2, NVARCHAR2, and RAW storage as BLOB
_px_replication_enabled 				     enables or disables replication of small table scans
_zonemap_use_enabled					     enable the use of zonemaps for IO pruning
_zonemap_staleness_tracking				     control the staleness tracking of zonemaps via trigger
_zonemap_control					     control different uses/algorithms related to zonemaps
_sql_plan_directive_mgmt_control			     controls internal SQL Plan Directive management activities
_px_filter_parallelized 				     enables or disables correlated filter parallelization
_px_filter_skew_handling				     enable correlated filter parallelization to handle skew
_px_groupby_pushdown					     perform group-by pushdown for parallel query
_partition_advisor_srs_active				     enables sampling based partitioning validation
_px_parallelize_expression				     enables or disables expression evaluation parallelization
_fast_index_maintenance 				     fast global index maintenance during PMOPs
_optimizer_gather_stats_on_load 			     enable/disable online statistics gathering
_multi_transaction_optimization_enabled 		     reduce SGA memory use during create of a partitioned table
_optimizer_batch_table_access_by_rowid			     enable table access by ROWID IO batching
optimizer_adaptive_reporting_only			     use reporting-only mode for adaptive optimizations
_optimizer_ads_result_cache_life			     result cache shelf life for ADS queries
_px_wif_dfo_declumping					     NDV-aware DFO clumping of multiple window sorts
_px_wif_extend_distribution_keys			     extend TQ data redistribution keys for window functions
_px_wif_min_ndv_per_slave				     mininum NDV of TQ keys needed per slave for scalable WiF PX
_px_join_skew_handling					     enables skew handling for parallel joins
_px_join_skew_ratio					     sets skew ratio for parallel joins
_px_join_skew_minfreq					     sets minimum frequency(%) for skewed value for parallel joins
_px_adaptive_dist_method				     determines the behavior of adaptive distribution methods
_px_adaptive_dist_method_threshold			     Buffering / decision threshold for adaptive distribution methods
_parallel_fault_tolerance_enabled			     enables or disables fault-tolerance for parallel statement
_parallel_fault_tolerance_threshold			     total number of faults fault-tolerance will handle
_px_partial_rollup_pushdown				     perform partial rollup pushdown for parallel execution
_sql_diag_repo_retain					     retain sql diag repository to cursor or not
_sql_diag_repo_origin					     duarations where sql diag repository are retained
_optimizer_dsdir_usage_control				     controls optimizer usage of dynamic sampling directives
_px_cpu_autodop_enabled 				     enables or disables auto dop cpu computation
parallel_degree_level					     adjust the computed degree in percentage
_px_cpu_process_bandwidth				     CPU process bandwidth in MB/sec for DOP computation
_px_cpu_operator_bandwidth				     CPU operator bandwidth in MB/sec for DOP computation
_px_single_server_enabled				     allow single-slave dfo in parallel query
_optimizer_use_gtt_session_stats			     use GTT session private statistics
_optimizer_adaptive_plans				     enable adaptive plans
_optimizer_adaptive_plan_control			     internal controls for adaptive plans
_optimizer_adaptive_random_seed 			     random seed for adaptive plans
_optimizer_strans_adaptive_pruning			     allow adaptive pruning of star transformation bitmap trees
_optimizer_proc_rate_level				     control the level of processing rates
_px_hybrid_TSM_HWMB_load				     Enable Hybrid Temp Segment Merge/High Water Mark Brokered load method
_optimizer_use_histograms				     enable/disable the usage of histograms by the optimizer
_disable_directory_link_check				     Disable directory link checking
_add_nullable_column_with_default_optim 		     Allows add of a nullable column with default optimization
_emx_max_sessions					     Maximum number of sessions in the EM Express cache
_emx_session_timeout					     Session timeout (sec) in the EM Express cache
_emx_control						     EM Express control (internal use only)
_parallel_blackbox_sga					     true if blackbox will be allocated in SGA, false if PGA
_rowsets_enabled					     enable/disable rowsets
_rowsets_target_maxsize 				     target size in bytes for space reserved in the frame for a rowset
_rowsets_max_rows					     maximum number of rows in a rowset
_use_hidden_partitions					     use hidden partitions
_px_load_monitor_threshold				     threshold for pushing information to load slave workload monitor
_px_monitor_load					     enable consumer load slave workload monitoring
_px_adaptive_offload_percentage 			     percentage for PQ adaptive offloading of granules
_modify_column_index_unusable				     allow ALTER TABLE MODIFY(column) to violate index key length limit
_adaptive_window_consolidator_enabled			     enable/disable adaptive window consolidator PX plan
_sql_hvshare_threshold					     threshold to control hash value sharing across operators
_px_tq_rowhvs						     turn on intra-row hash valueing sharing in TQ
_sql_hvshare_debug					     control hash value sharing debug level
_sql_show_expreval					     show expression evalution as shared hash producer in plan
_parallel_ctas_enabled					     enable/disable parallel CTAS operation
_optimizer_performance_feedback 			     controls the performance feedback
_optimizer_proc_rate_source				     control the source of processing rates
_hashops_prefetch_size					     maximum no of rows whose relevant memory locations are prefetched
_stat_aggs_one_pass_algorithm				     enable one pass algorithm for variance-related functions
_px_onepass_slave_acquisition				     enable/disable one pass slave acquisition for parallel execution
_online_ctas_diag					     controls dumping diagnostic information for online ctas
_upddel_dba_hash_mask_bits				     controls masking of lower order bits in DBA
_px_pwmr_enabled					     parallel partition wise match recognize enabled
_px_cdb_view_enabled					     parallel cdb view evaluation enabled
optimizer_adaptive_features				     controls adaptive features
_partition_cdb_view_enabled				     partitioned cdb view evaluation enabled
_common_data_view_enabled				     common objects returned through dictionary views
_pred_push_cdb_view_enabled				     predicate pushdown enabled for CDB views
_rowsets_cdb_view_enabled				     rowsets enabled for CDB views
_distinct_agg_optimization_gsets			     Use Distinct Aggregate Optimization for Grouping Sets
_array_cdb_view_enabled 				     array mode enabled for CDB views
_mv_refresh_truncate_log				     materialized view refresh truncate MV log
_rc_sys_obj_enabled					     result cache enabled for Sys Objects
_px_scalable_invdist					     enable/disable px scalable plan for inverse distribution functions
_indexable_con_id					     indexing of CON_ID column enabled for X$ tables
_optimizer_reduce_groupby_key				     group-by key reduction
_optimizer_cluster_by_rowid_batched			     enable/disable the cluster by rowid batching feature
_optimizer_cluster_by_rowid_batch_size			     Sorting batch size for cluster by rowid feature
_object_link_fixed_enabled				     object linked views evaluated using fixed table
_optimizer_synopsis_min_size				     minimal synopsis size (kb)
_merge_monitor_threshold				     threshold for pushing information to MERGE monitoring
optimizer_inmemory_aware				     optimizer in-memory columnar awareness
_optimizer_inmemory_table_expansion			     optimizer in-memory awareness for table expansion
_optimizer_inmemory_gen_pushable_preds			     optimizer generate pushable predicates for in-memory
_optimizer_inmemory_autodop				     optimizer autoDOP costing for in-memory
_optimizer_inmemory_access_path 			     optimizer access path costing for in-memory
_optimizer_inmemory_quotient				     in-memory quotient (% of rows in in-memory format)
_optimizer_inmemory_pruning_ratio_rows			     in-memory pruning ratio for # rows (% of rows remaining after pruning)
_parallel_inmemory_min_time_threshold			     threshold above which a plan is a candidate for parallelization for in-memory ta
							     bles (in seconds)

_parallel_inmemory_time_unit				     unit of work used to derive the degree of parallelism for in-memory tables (in s
							     econds)

_px_external_table_default_stats			     the external table default stats collection enable/disable
_optimizer_nlj_hj_adaptive_join 			     allow adaptive NL Hash joins
_px_autodop_pq_overhead 				     adjust auto dop calculation using pq overhead
_px_overhead_init_slavealloc				     pq overhead on allocating per slave during initialization (in microseconds)
_px_overhead_init_endpoints				     pq overhead on setting up one end point during initialization (in microseconds)
_px_overhead_exec_ctrlmesg				     pq overhead on sending one control message during execution (in microseconds)
_px_overhead_teardown					     pq overhead on setting up one end point during initialization (in microseconds)
_grant_read_instead_of_select				     grant read privilege instead of select wherever applicable
_optimizer_inmemory_bloom_filter			     controls serial bloom filter for in-memory tables
_optimizer_inmemory_cluster_aware_dop			     Affinitize DOP for inmemory objects
_cdb_cross_container					     Debug flag for cross container operations
_cdb_view_parallel_degree				     Parallel degree for a CDB view query
_optimizer_hll_entry					     number of entries in hll hash table
_cross_con_row_count					     use actual row count for cross container views
_cdb_view_prefetch_batch_size				     Batch Size for Prefetch for a CDB view query
_cdb_view_rc_shelflife					     Result Cache Shelflife for a CDB view query
_approx_cnt_distinct_gby_pushdown			     perform group-by pushdown for approximate distinct count query
_approx_cnt_distinct_optimization			     settings for approx_count_distinct optimizations
_px_cdb_view_join_enabled				     disable parallelism cap on CDB view
_external_table_smart_scan				     External Table Smart Scan
_optimizer_inmemory_minmax_pruning			     controls use of min/max pruning for costing in-memory tables
_query_execution_time_limit				     Query execution time limit in seconds
_optimizer_ads_use_partial_results			     Use partial results of ADS queries
_alter_upgrade_signature_only				     alter table upgrade only sets signature
_max_clients_per_emon					     maximum number of clients per emon
_emon_pool_inc						     increment in EMON slaves per pool type
_emon_pool_min						     minimum number of EMON slaves per pool type
_emon_pool_max						     maximum number of EMON slaves per pool type
_aq_streaming_threshold 				     large payload threshold size
_re_fast_sql_operator					     enables fast boxable sql operator
_re_result_cache_keysiz 				     defines max number key for result cache hash table
_re_result_cache_size					     defines max number of cached elements for result cache
_re_independent_expression_cache_size			     defines max number of compiled cached expressions for iee
_enable_iee_stats					     enables IEE stats gathering
_re_num_complex_operator				     defines max number of compiled complex operator per ruleset-iee
_re_num_rowcache_load					     defines max number of complex operators loaded with row cache
_aqsharded_cache_limit					     Limit for cached enqueue/dequeue operations
_aq_Txn_ht_sz						     Message cache Txn Hash table size
_aq_shard_bitmap_child_latches				     Bitmap child latches
_aq_shard_retry_child_latches				     Retry child latches
_aq_shard_txn_child_latches				     Txn child latches
_aq_shard_sub_child_latches				     Subscriber child latches
_aq_shard_sub_child_Elem_latches			     Subscriber Element child latches
_aq_shard_child_latches 				     Shard child latches
_aq_shard_prty_latches					     Shard priority child latches
_aq_init_shards 					     Minimum enqueue shards per queue at an instance
_aq_disable_x						     AQ - Disable new cross processes at an instance
_aq_latency_relative_threshold				     Relative threshold of average latency
_aq_latency_absolute_threshold				     Absolute threshold greater than average latency
_aq_x_msg_size						     AQ cross single message buffer size
_aq_stop_backgrounds					     Stop all AQ background processes
_aq_lb_cycle						     Time(seconds) between consecutive AQ load balancing efforts
_aq_lb_stats_collect_cycle				     Time(seconds) between consecutive AQ load statistics collection
_aq_pt_processes					     Partition background processes
_aq_subshard_Size					     Sub Shard Size
_aq_subshards_per_qpartition				     SubShards Per Q Partition
_aq_subshards_per_dqpartition				     SubShards Per Deq Partition
_aq_lookback_size					     AQ PT Look Back Size
_aq_qt_prefetch_Size					     AQ PT QT prefech Size
_aq_dq_prefetch_Siz					     AQ PT DQ prefech Size
_aq_pt_statistics_window				     PT statistics sample window Size
_aq_pt_shrink_frequency 				     PT shrink window Size
_aq_addpt_batch_size					     Add PT batch Size
_aq_truncpt_batch_size					     Trunc PT batch Size
_aq_droppt_batch_size					     Drop PT batch Size
_shrd_que_tm_processes					     number of sharded queue Time Managers to start
_shrd_que_tm_statistics_duration			     Shaded queue statistics collection window duration
_aq_ipc_max_slave					     maximum number of slaves for knlpipcm
_ctx_doc_policy_stems					     enable ctx_doc.policy_stems api
_olap_row_load_time_precision				     OLAP Row Load Time Precision
_olap_disable_loop_optimized				     Disable LOOP OPTIMIZED directive in OLAP_TABLE
_remote_asm						     remote ASM configuration
_asm_relocation_trace					     enable extent relocation tracing
_asm_relocation_ignore_hard_failure			     ignore HARD for relocation
_asm_max_parallelios					     Maximum simultaneous outstanding IOs
_kffmlk_hash_size					     size of kffmlk_hash table
_asm_diskgroups2					     disk groups to mount automatically set 2
_asm_diskgroups3					     disk groups to mount automatically set 3
_asm_diskgroups4					     disk groups to mount automatically set 4
_asm_disable_dangerous_failgroup_checking		     Disable checking for dubious failgroup configurations
_asm_diskerr_traces					     Number of read/write errors per disk a process can trace
_asm_procs_trace_diskerr				     Number of processes allowed to trace a disk failure
_asm_trace_limit_timeout				     Time-out in milliseconds to reset the number of traces per disk and the number o
							     f processes allowed to trace

_asm_skip_dbfile_ios					     Skip I/Os to database files (do only ASM metadata I/O)
_asm_offload_all					     Offload all write operations to Exadata cells, when supported
_asm_read_cancel					     Read cancel timeout in milliseconds
_asm_read_cancel_back_out				     Time period in milliseconds when no reads are issued to a disk after a read is c
							     ancelled

_asm_write_cancel					     Write timeout in milliseconds
_afd_disable_fence					     Disable AFD fencing
_asm_network_timeout					     Keepalive timeout for ASM network connections
_asm_skip_diskval_check 				     skip client side discovery for disk revalidate
_asm_remote_client_timeout				     timeout before killing disconnected remote clients
_asm_allow_unsafe_reconnect				     attempt unsafe reconnect to ASM
_asm_disable_ufgmemberkill				     disable ufg member kill
_asm_nodekill_escalate_time				     secs until escalating to nodekill if fence incomplete
_asm_healthcheck_timeout				     seconds until health check takes action
_asm_resyncCkpt 					     number of extents to resync before flushing checkpoint
_asm_noevenread_diskgroups				     List of disk groups having even read disabled
_asm_networks						     ASM network subnet addresses
_asm_allowdegeneratemounts				     Allow force-mounts of DGs w/o proper quorum
_asm_proxy_startwait					     Maximum time to wait for ASM proxy connection
_asm_allow_dangerous_unprotected_volumes		     Disable checking for unprotected volumes in mirrored disk groups
_asm_appliance_ignore_oak				     Ignore OAK appliance library
_dirty_appliance_mode					     Enable appliance mode even on non-appliance
_asm_appliance_slot_from_path				     Get appliance disk slot from disk path
_asm_scrub_limit					     ASM disk scrubbing power
_asm_scrub_unmatched_dba				     Scrub maximum number of blocks with unmatched DBA
_asm_enable_xrov					     Enable XROV capability
_asm_xrov_single					     Enable single issues of IOs
_asm_xrov_rsnmod					     Specify 'reason' mode
_asm_xrov_nvios 					     Specify number of VIO processes
_asm_xrov_nstats					     Specify number of IOs before stats
_skip_acfs_checks					     Override checking if on an ACFS file system
_asm_force_vam						     force VAM for external redundancy
_usd_recent_read					     Allow to scan recent USD blocks
_usd_preload_blks					     USD preload block count for prefetch
_remote_awr_enabled					     Enable/disable Remote AWR Mode
_awr_disabled_purge_tables				     Disable purging of specified AWR tables
_awr_snapshot_level					     Set Default AWR snapshot level
_awr_remote_target_dblink				     AWR Remote Target DBLink for Flushing
_awr_pdb_registration_enabled				     Parameter to enable/disable AWR PDB Registration
_awr_cdbperf_threshold					     Setting for AWR CDBPERF Threshold
_awr_partition_interval 				     Setting for AWR Partition Interval
_kewm_simulate_oer4031					     Simulate OER(4031) for one or more Metric Groups
_enable_metrics_allpdb					     Enable/Disable Metrics for Root and all PDBs if applicable
_enable_metrics_pdb					     Enable/Disable Metrics for this Non-Root PDB
_autotask_test_name					     Name of current Autotask Test (or test step)
_max_queued_report_requests				     Maximum number of report requests that can be queued in a list
_report_capture_cycle_time				     Time (in sec) between two cycles of report capture daemon
_report_capture_dbtime_percent_cutoff			     100X Percent of system db time daemon is allowed over 10 cycles
_report_capture_timeband_length 			     Length of time band (in hours) in the reports time bands table
_report_capture_recharge_window 			     No of report capture cycles after which db time is recharged
_max_report_flushes_percycle				     Max no of report requests that can be flushed per cycle
_report_request_ageout_minutes				     Time (in min) after which a report request is deleted from queue
_kecap_cache_size					     Workload Replay INTERNAL parameter used to set memory usage in  Application Repl
							     ay

_rtaddm_trigger_enabled 				     To enable or disable Real-Time ADDM automatic trigger
_rtaddm_trigger_args					     comma-separated list of numeric arguments for RT addm trigger
spatial_vector_acceleration				     enable spatial vector acceleration
_diag_adr_trace_dest					     diagnosability trace directory path
_diag_patch_cap_enabled 				     Parameter to enable/disable Diag Patch Configuration Capture
_log_segment_dump_parameter				     Dump KSP on Log Segmentation
_log_segment_dump_patch 				     Dump Patchinfo on Log Segmentation
_max_incident_file_size 				     Maximum size (in KB, MB, GB, Blocks) of incident dump file
_uts_trace_segment_size 				     Maximum size (in bytes) of a trace segment
_uts_trace_segments					     Maximum number of trace segments
_uts_first_segment_size 				     Maximum size (in bytes) of first segments
_uts_first_segment_retain				     Should we retain the first trace segment
_uts_trace_disk_threshold				     Trace disk threshold parameter
_diag_test_seg_reinc_mode				     Sets trace segmentation to be in reincarnation mode
_kxdbio_ctx_init_count					     initial count of KXDBIO state object
_kxdbio_disable_offload_opcode				     KXDBIO Disable offload for the set opcodes.  Value is a Bitmap of	  0x00000001
							     - disable cell to cell data copy offload	 0x00000002 - disable disk scrubbing
							     offload to cell	0x00000004 - disable offloaded writes to cell

_kxdbio_enable_ds_opcode				     KXDBIO Enable Dumb storage simulation for the set opcodes.
_enable_offloaded_writes				     Enable offloaded writes for Unit Test
_block_level_offload_high_lat_thresh			     High Latency Threshold for Block Level Offload operations
_kxdbio_hca_loadavg_thresh				     HCA loadavg threshold at which writes need to get offloaded
_kxdbio_ut_ctl						     kxdbio unit test controls
_cell_offload_backup_compression			     enable offload of backup compression to cells
_enable_pluggable_database				     Enable Pluggable Database
enable_pluggable_database				     Enable Pluggable Database
_oracle_script						     Running an Oracle-supplied script
_discard_cmn_ddl_in_pdb_err				     Discard error when Common DDL is attempted in PDB
pdb_os_credential					     pluggable database OS credential to bind
pdb_lockdown						     pluggable database lockdown profile
pdb_file_name_convert					     PDB file name convert patterns and strings for create cdb/pdb
_pluggable_database_debug				     Debug flag for pluggable database related operations
noncdb_compatible					     Non-CDB Compatible
_cdb_compatible 					     CDB Compatible
_deferred_seg_in_seed					     Enable Deferred Segment Creation in Seed
common_user_prefix					     Enforce restriction on a prefix of a Common User/Role/Profile name
_common_user_prefix					     Enforce restriction on a prefix of a Common User/Role/Profile name
_relocate_pdb						     Relocate PDB to another RAC instance after it is closed in the current instance
_cdb_rac_affinity					     rac affinity for parallel cdb operations
_set_container_service					     set container service
_multiple_char_set_cdb					     Multiple character sets enabled in CDB
_cdb_spfile_inherit					     Inherit CDB Spfile enabled/disabled in a PDB
_enable_pdb_close_abort 				     Enable PDB shutdown abort (close abort)
_max_pdbs						     Parameter is a hint to adjust certain attributes of the CDB
_pdb_cluster_database					     This parameter can be turned-off when cluster_database is TRUE
_pdb_mask_cdb_info					     Enable masking CDB information within a PDB
exclude_seed_cdb_view					     exclude PDB$SEED from CDB View Result
_disable_cdb_view_rc_invalidation			     disable Result Cache invalidation for CDB View results
_gsm							     GSM descriptions
_gsm_region_list					     List of GSM Regions
_cloud_name						     gsm cloud name
_dbpool_name						     gsm database pool name
_region_name						     gsm region name
_db_num_gsm						     database number in gsm dbpool
_gsm_config_vers					     version of gsm config
_gsm_max_instances_per_db				     maximum number of instances per database in gsm cloud
_gsm_max_num_regions					     maximum number of regions in gsm cloud
_gsm_drv_interval					     metric derived values interval
_gsm_srlat_thresh					     Single block read latency threshold
_gsm_cpu_thresh 					     CPU busy threshold
_gsm_thresh_zone					     threshold zone
_gsm_thresh_respct					     threshold resource percentage
_gwm_spare1						     gsm spare 1
_gwm_spare2						     gsm spare 2
_gwm_spare3						     gsm spare 3
_rq_shm_max_size					     maximum size of an RQuery shared memory segement (in KB)

1106 rows selected.

SQL> 

E ae, já decorou todos :)