Some interesting columns
The columns
isses_modifiable
and
issys_modifiable
can be used to determine if a parameter can be changed at session level using
alter session
or at system level using
alter system
.
A parameter is modifiable at session level if isses_modifiable = 'TRUE'
.
A parameter is modifiable at system level if issys_modifiable = 'DEFERRED' or issys_modifiable = 'IMMEDIATE'
.
However, if a parameter is changed at system level if
issys_modifiable = 'DEFERRED'
it only affects sessions that are started after changing the parameter. Additionally, the
alter system
set … deferred option
must be used.
Select from v$parameter
-- Alter session for consistent ordering
alter session set nls_language='english';
select
max(st ) st,
name name,
max(type_ ) type_,
max(description) description
from (
select 'OK' st, name , null type_, description from v$parameter union all
select 'Obsolete' st, name , null type_, null from v$obsolete_parameter union all
select '?' st, name , type type_, null from v$spparameter union all
select '?' st,'_fix_control', null type_,'See v$session_fix_control, v$system_fix_control' from dual
)
group by
name
order by
replace(lower(name), '_','')
;
--
-- OK active_instance_count integer number of active instances in the cluster database
-- Obsolete allow_partial_sn_results
-- Obsolete always_anti_join
-- Obsolete always_semi_join
-- OK aq_tm_processes integer number of AQ Time Managers to start
-- Obsolete arch_io_slaves
-- OK archive_lag_target integer Maximum number of seconds of redos the standby could lose
-- OK asm_diskgroups string disk groups to mount automatically
-- OK asm_diskstring string disk set locations for discovery
-- OK asm_power_limit integer number of parallel relocations for disk rebalancing
-- OK asm_preferred_read_failure_groups string preferred read failure groups
-- OK audit_file_dest string Directory in which auditing files are to reside
-- OK audit_syslog_level string Syslog facility and level
-- OK audit_sys_operations boolean enable sys auditing
-- OK audit_trail string enable system auditing
-- Obsolete _average_dirties_half_life
-- Obsolete _aw_row_source_enabled
-- OK awr_snapshot_time_offset integer Setting for AWR Snapshot Time Offset
-- OK background_core_dump string Core Size for Background Processes
-- OK background_dump_dest string Detached process dump directory
-- Obsolete backup_disk_io_slaves
-- OK backup_tape_io_slaves boolean BACKUP Tape I/O slaves
-- OK bitmap_merge_area_size integer maximum memory allow for BITMAP MERGE
-- OK blank_trimming boolean blank trimming semantics parameter
-- Obsolete b_tree_bitmap_plans
-- OK buffer_pool_keep string Number of database blocks/latches in keep buffer pool
-- OK buffer_pool_recycle string Number of database blocks/latches in recycle buffer pool
-- Obsolete cache_size_threshold
-- OK cell_offload_compaction string Cell packet compaction strategy
-- OK cell_offload_decryption boolean enable SQL processing offload of encrypted data to cells
-- OK cell_offload_parameters string Additional cell offload parameters
-- OK cell_offload_plan_display string Cell offload explain plan display
-- OK cell_offload_processing boolean enable SQL processing offload to cells
-- Obsolete cell_partition_large_extents
-- OK circuits integer max number of circuits
-- Obsolete cleanup_rollback_entries
-- OK client_result_cache_lag big integer client result cache maximum lag in milliseconds
-- OK client_result_cache_size big integer client result cache max size in bytes
-- OK clonedb boolean clone database
-- Obsolete close_cached_open_cursors
-- OK cluster_database boolean if TRUE startup in cluster database mode
-- OK cluster_database_instances integer number of instances to use for sizing cluster db SGA structures
-- OK cluster_interconnects string interconnects for RAC use
-- OK commit_logging string transaction commit log write behaviour
-- OK commit_point_strength integer Bias this node has toward not preparing in a two-phase commit
-- OK commit_wait string transaction commit log wait behaviour
-- OK commit_write string transaction commit log write behaviour
-- OK compatible string Database will be completely compatible with this software version
-- Obsolete _compatible_no_recovery
-- Obsolete complex_view_merging
-- OK control_file_record_keep_time integer control file record keep time in days
-- OK control_files string control file names list
-- OK control_management_pack_access string declares which manageability packs are enabled
-- OK core_dump_dest string Core dump directory
-- OK cpu_count integer number of CPUs for this instance
-- OK create_bitmap_area_size integer size of create bitmap buffer for bitmap index
-- OK create_stored_outlines string create stored outlines for DML statements
-- OK cursor_bind_capture_destination string Allowed destination for captured bind variables
-- OK cursor_sharing string cursor sharing mode
-- OK cursor_space_for_time boolean use more memory in order to get faster execution
-- OK db_16k_cache_size big integer Size of cache for 16K buffers
-- OK db_2k_cache_size big integer Size of cache for 2K buffers
-- OK db_32k_cache_size big integer Size of cache for 32K buffers
-- OK db_4k_cache_size big integer Size of cache for 4K buffers
-- OK db_8k_cache_size big integer Size of cache for 8K buffers
-- OK db_block_buffers integer Number of database blocks cached in memory
-- OK db_block_checking string header checking and data and index block checking
-- Obsolete db_block_checkpoint_batch
-- OK db_block_checksum string store checksum in db blocks and check during reads
-- Obsolete db_block_lru_extended_statistics
-- Obsolete db_block_lru_latches
-- Obsolete db_block_lru_statistics
-- Obsolete db_block_max_dirty_target
-- OK db_block_size integer Size of database block in bytes
-- OK db_cache_advice string Buffer cache sizing advisory
-- OK db_cache_size big integer Size of DEFAULT buffer pool for standard block size buffers
-- OK db_create_file_dest string default database location
-- OK db_create_online_log_dest_1 string online log/controlfile destination #1
-- OK db_create_online_log_dest_2 string online log/controlfile destination #2
-- OK db_create_online_log_dest_3 string online log/controlfile destination #3
-- OK db_create_online_log_dest_4 string online log/controlfile destination #4
-- OK db_create_online_log_dest_5 string online log/controlfile destination #5
-- OK db_domain string directory part of global database name stored with CREATE DATABASE
-- OK db_file_multiblock_read_count integer db block to be read each IO
-- OK db_file_name_convert string datafile name convert patterns and strings for standby/clone db
-- OK db_files integer max allowable # db files
-- Obsolete db_file_simultaneous_writes
-- OK db_flashback_retention_target integer Maximum Flashback Database log retention time in minutes.
-- OK db_flash_cache_file string flash cache file for default block size
-- OK db_flash_cache_size big integer flash cache size for db_flash_cache_file
-- OK db_keep_cache_size big integer Size of KEEP buffer pool for standard block size buffers
-- Obsolete dblink_encrypt_login
-- OK db_lost_write_protect string enable lost write detection
-- OK db_name string database name specified in CREATE DATABASE
-- Obsolete _db_no_mount_lock
-- OK db_recovery_file_dest string default database recovery file location
-- OK db_recovery_file_dest_size big integer database recovery files size limit
-- OK db_recycle_cache_size big integer Size of RECYCLE buffer pool for standard block size buffers
-- OK db_securefile string permit securefile storage during lob creation
-- OK db_ultra_safe string Sets defaults for other parameters that control protection levels
-- OK db_unique_name string Database Unique Name
-- OK db_unrecoverable_scn_tracking boolean Track nologging SCN in controlfile
-- OK dbwr_io_slaves integer DBWR I/O slaves
-- OK db_writer_processes integer number of background database writer processes to start
-- OK ddl_lock_timeout integer timeout to restrict the time that ddls wait for dml lock
-- Obsolete ddl_wait_for_locks
-- OK deferred_segment_creation boolean defer segment creation to first insert
-- Obsolete delayed_logging_block_cleanouts
-- OK dg_broker_config_file1 string data guard broker configuration file #1
-- OK dg_broker_config_file2 string data guard broker configuration file #2
-- OK dg_broker_start boolean start Data Guard broker (DMON process)
-- OK diagnostic_dest string diagnostic base directory
-- OK _disable_interface_checking boolean disable interface checking at startup
-- Obsolete discrete_transactions_enabled
-- OK disk_asynch_io boolean Use asynch I/O for random access devices
-- OK dispatchers string specifications of dispatchers
-- OK distributed_lock_timeout integer number of seconds a distributed transaction waits for a lock
-- Obsolete distributed_recovery_connection_hold_time
-- Obsolete distributed_transactions
-- Obsolete _dlm_send_timeout
-- OK dml_locks integer dml locks - one for each table modified in a transaction
-- Obsolete drs_start
-- OK dst_upgrade_insert_conv boolean Enables/Disables internal conversions during DST upgrade
-- OK enable_ddl_logging boolean enable ddl logging
-- OK _enable_NUMA_support boolean Enable NUMA support and optimizations
-- Obsolete enqueue_resources
-- OK event string debug event control - default null string
-- OK fal_client string FAL client
-- OK fal_server string FAL server list
-- Obsolete fast_full_scan_enabled
-- Obsolete _fast_start_instance_recovery_target
-- OK fast_start_io_target integer Upper bound on recovery reads
-- OK fast_start_mttr_target integer MTTR target in seconds
-- OK fast_start_parallel_rollback string max number of parallel recovery slaves that may be used
-- OK fileio_network_adapters string Network Adapters for File I/O
-- OK file_mapping boolean enable file mapping
-- OK _file_size_increase_increment big integer Amount of file size increase increment, in bytes
-- OK filesystemio_options string IO operations on filesystem files
-- ? _fix_control See v$session_fix_control, v$system_fix_control
-- OK fixed_date string fixed SYSDATE value
-- Obsolete freeze_DB_for_fast_instance_recovery
-- Obsolete gc_defer_time
-- Obsolete gc_files_to_locks
-- Obsolete gc_latches
-- Obsolete gc_lck_procs
-- OK _gc_policy_time integer how often to make object policy decisions in minutes
-- Obsolete gc_releasable_locks
-- Obsolete gc_rollback_locks
-- OK gcs_server_processes integer number of background gcs server processes to start
-- OK _gc_undo_affinity boolean if TRUE, enable dynamic undo affinity
-- OK global_context_pool_size string Global Application Context Pool Size in Bytes
-- OK global_names boolean enforce that database links have same name as remote database
-- OK global_txn_processes integer number of background global transaction processes to start
-- OK hash_area_size integer size of in-memory hash work area
-- Obsolete hash_join_enabled
-- Obsolete hash_multiblock_io_count
-- OK hi_shared_memory_address integer SGA starting address (high order 32-bits on 64-bit platforms)
-- OK hs_autoregister boolean enable automatic server DD updates in HS agent self-registration
-- OK ifile file include file in init.ora
-- OK instance_groups string list of instance group names
-- OK instance_name string instance name supported by the instance
-- Obsolete instance_nodeset
-- OK instance_number integer instance number
-- OK instance_type string type of instance to be executed
-- OK java_jit_enabled boolean Java VM JIT enabled
-- OK java_max_sessionspace_size integer max allowed size in bytes of a Java sessionspace
-- OK java_pool_size big integer size in bytes of java pool
-- OK java_soft_sessionspace_limit integer warning limit on size in bytes of a Java sessionspace
-- Obsolete job_queue_interval
-- Obsolete job_queue_keep_connections
-- OK job_queue_processes integer maximum number of job queue slave processes
-- OK _kgl_cluster_lock_read_mostly boolean Library cache support for cluster lock read mostly optimization
-- Obsolete _kgl_latch_count
-- OK _kill_diagnostics_timeout integer timeout delay in seconds before killing enqueue blocker
-- Obsolete _kspptbl_mem_usage
-- Obsolete large_pool_min_alloc
-- OK large_pool_size big integer size in bytes of large pool
-- OK ldap_directory_access string RDBMS's LDAP access option
-- OK ldap_directory_sysauth string OID usage parameter
-- Obsolete lgwr_io_slaves
-- OK license_max_sessions integer maximum number of non-system user sessions allowed
-- OK license_max_users integer maximum number of named users that can be created in the database
-- OK license_sessions_warning integer warning level for number of non-system user sessions
-- OK listener_networks string listener registration networks
-- Obsolete _lm_direct_sends
-- Obsolete lm_locks
-- Obsolete _lm_multiple_receivers
-- Obsolete lm_procs
-- Obsolete _lm_rcv_buffer_size
-- OK _lm_rcvr_hang_allow_time integer receiver hang allow time in seconds
-- Obsolete lm_ress
-- Obsolete _lm_statistics
-- OK local_listener string local listener
-- OK lock_name_space string lock name space used for generating lock names for standby/clone database
-- OK lock_sga boolean Lock entire SGA in physical memory
-- Obsolete lock_sga_areas
-- Obsolete _log_archive_buffer_size
-- OK log_archive_config string log archive config parameter
-- OK log_archive_dest string archival destination text string
-- OK log_archive_dest_1 string archival destination #1 text string
-- OK log_archive_dest_10 string archival destination #10 text string
-- OK log_archive_dest_11 string archival destination #11 text string
-- OK log_archive_dest_12 string archival destination #12 text string
-- OK log_archive_dest_13 string archival destination #13 text string
-- OK log_archive_dest_14 string archival destination #14 text string
-- OK log_archive_dest_15 string archival destination #15 text string
-- OK log_archive_dest_16 string archival destination #16 text string
-- OK log_archive_dest_17 string archival destination #17 text string
-- OK log_archive_dest_18 string archival destination #18 text string
-- OK log_archive_dest_19 string archival destination #19 text string
-- OK log_archive_dest_2 string archival destination #2 text string
-- OK log_archive_dest_20 string archival destination #20 text string
-- OK log_archive_dest_21 string archival destination #21 text string
-- OK log_archive_dest_22 string archival destination #22 text string
-- OK log_archive_dest_23 string archival destination #23 text string
-- OK log_archive_dest_24 string archival destination #24 text string
-- OK log_archive_dest_25 string archival destination #25 text string
-- OK log_archive_dest_26 string archival destination #26 text string
-- OK log_archive_dest_27 string archival destination #27 text string
-- OK log_archive_dest_28 string archival destination #28 text string
-- OK log_archive_dest_29 string archival destination #29 text string
-- OK log_archive_dest_3 string archival destination #3 text string
-- OK log_archive_dest_30 string archival destination #30 text string
-- OK log_archive_dest_31 string archival destination #31 text string
-- OK log_archive_dest_4 string archival destination #4 text string
-- OK log_archive_dest_5 string archival destination #5 text string
-- OK log_archive_dest_6 string archival destination #6 text string
-- OK log_archive_dest_7 string archival destination #7 text string
-- OK log_archive_dest_8 string archival destination #8 text string
-- OK log_archive_dest_9 string archival destination #9 text string
-- OK log_archive_dest_state_1 string archival destination #1 state text string
-- OK log_archive_dest_state_10 string archival destination #10 state text string
-- OK log_archive_dest_state_11 string archival destination #11 state text string
-- OK log_archive_dest_state_12 string archival destination #12 state text string
-- OK log_archive_dest_state_13 string archival destination #13 state text string
-- OK log_archive_dest_state_14 string archival destination #14 state text string
-- OK log_archive_dest_state_15 string archival destination #15 state text string
-- OK log_archive_dest_state_16 string archival destination #16 state text string
-- OK log_archive_dest_state_17 string archival destination #17 state text string
-- OK log_archive_dest_state_18 string archival destination #18 state text string
-- OK log_archive_dest_state_19 string archival destination #19 state text string
-- OK log_archive_dest_state_2 string archival destination #2 state text string
-- OK log_archive_dest_state_20 string archival destination #20 state text string
-- OK log_archive_dest_state_21 string archival destination #21 state text string
-- OK log_archive_dest_state_22 string archival destination #22 state text string
-- OK log_archive_dest_state_23 string archival destination #23 state text string
-- OK log_archive_dest_state_24 string archival destination #24 state text string
-- OK log_archive_dest_state_25 string archival destination #25 state text string
-- OK log_archive_dest_state_26 string archival destination #26 state text string
-- OK log_archive_dest_state_27 string archival destination #27 state text string
-- OK log_archive_dest_state_28 string archival destination #28 state text string
-- OK log_archive_dest_state_29 string archival destination #29 state text string
-- OK log_archive_dest_state_3 string archival destination #3 state text string
-- OK log_archive_dest_state_30 string archival destination #30 state text string
-- OK log_archive_dest_state_31 string archival destination #31 state text string
-- OK log_archive_dest_state_4 string archival destination #4 state text string
-- OK log_archive_dest_state_5 string archival destination #5 state text string
-- OK log_archive_dest_state_6 string archival destination #6 state text string
-- OK log_archive_dest_state_7 string archival destination #7 state text string
-- OK log_archive_dest_state_8 string archival destination #8 state text string
-- OK log_archive_dest_state_9 string archival destination #9 state text string
-- OK log_archive_duplex_dest string duplex archival destination text string
-- OK log_archive_format string archival destination format
-- OK log_archive_local_first boolean Establish EXPEDITE attribute default value
-- OK log_archive_max_processes integer maximum number of active ARCH processes
-- OK log_archive_min_succeed_dest integer minimum number of archive destinations that must succeed
-- OK log_archive_start boolean start archival process on SGA initialization
-- OK log_archive_trace integer Establish archivelog operation tracing level
-- Obsolete log_block_checksum
-- OK log_buffer integer redo circular buffer size
-- OK log_checkpoint_interval integer # redo blocks checkpoint threshold
-- OK log_checkpoints_to_alert boolean log checkpoint begin/end to alert file
-- OK log_checkpoint_timeout integer Maximum time interval between checkpoints in seconds
-- OK log_file_name_convert string logfile name convert patterns and strings for standby/clone db
-- Obsolete log_files
-- Obsolete logmnr_max_persistent_sessions
-- Obsolete log_parallelism
-- Obsolete log_simultaneous_copies
-- Obsolete log_small_entry_max_size
-- Obsolete max_commit_propagation_delay
-- OK max_dispatchers integer max number of dispatchers
-- OK max_dump_file_size string Maximum size (in bytes) of dump file
-- OK max_enabled_roles integer max number of roles a user can have enabled
-- Obsolete max_rollback_segments
-- OK max_shared_servers integer max number of shared servers
-- Obsolete max_transaction_branches
-- OK memory_max_target big integer Max size for Memory Target
-- OK memory_target big integer Target size of Oracle SGA and PGA memory
-- Obsolete mts_circuits
-- Obsolete mts_dispatchers
-- Obsolete mts_listener_address
-- Obsolete mts_max_dispatchers
-- Obsolete mts_max_servers
-- Obsolete mts_multiple_listeners
-- Obsolete mts_servers
-- Obsolete mts_service
-- Obsolete mts_sessions
-- OK nls_calendar string NLS calendar system name
-- OK nls_comp string NLS comparison
-- OK nls_currency string NLS local currency symbol
-- OK nls_date_format string NLS Oracle date format
-- OK nls_date_language string NLS date language name
-- OK nls_dual_currency string Dual currency symbol
-- OK nls_iso_currency string NLS ISO currency territory name
-- OK nls_language string NLS language name
-- OK nls_length_semantics string create columns using byte or char semantics by default
-- OK nls_nchar_conv_excp string NLS raise an exception instead of allowing implicit conversion
-- OK nls_numeric_characters string NLS numeric characters
-- OK nls_sort string NLS linguistic definition name
-- OK nls_territory string NLS territory name
-- OK nls_time_format string time format
-- OK nls_timestamp_format string time stamp format
-- OK nls_timestamp_tz_format string timestamp with timezone format
-- OK nls_time_tz_format string time with timezone format
-- OK O7_DICTIONARY_ACCESSIBILITY boolean Version 7 Dictionary Accessibility Support
-- OK object_cache_max_size_percent integer percentage of maximum size over optimal of the user session's object cache
-- OK object_cache_optimal_size integer optimal size of the user session's object cache in bytes
-- Obsolete ogms_home
-- OK olap_page_pool_size big integer size of the olap page pool in bytes
-- OK open_cursors integer max # cursors per session
-- OK open_links integer max # open links per session
-- OK open_links_per_instance integer max # open links per instance
-- Obsolete ops_admin_group
-- Obsolete ops_interconnects
-- OK optimizer_capture_sql_plan_baselines boolean automatic capture of SQL plan baselines for repeatable statements
-- Obsolete _optimizer_choose_permutation
-- OK optimizer_dynamic_sampling integer optimizer dynamic sampling
-- OK optimizer_features_enable string optimizer plan compatibility parameter
-- OK optimizer_index_caching integer optimizer percent index caching
-- OK optimizer_index_cost_adj integer optimizer index cost adjustment
-- Obsolete optimizer_max_permutations
-- OK optimizer_mode string optimizer mode
-- Obsolete optimizer_percent_parallel
-- Obsolete optimizer_search_limit
-- OK optimizer_secure_view_merging boolean optimizer secure view merging and predicate pushdown/movearound
-- OK optimizer_use_invisible_indexes boolean Usage of invisible indexes (TRUE/FALSE)
-- OK optimizer_use_pending_statistics boolean Control whether to use optimizer pending statistics
-- OK optimizer_use_sql_plan_baselines boolean use of SQL plan baselines for captured sql statements
-- Obsolete oracle_trace_collection_name
-- Obsolete oracle_trace_collection_path
-- Obsolete oracle_trace_collection_size
-- Obsolete oracle_trace_enable
-- Obsolete _oracle_trace_events
-- Obsolete oracle_trace_facility_name
-- Obsolete oracle_trace_facility_path
-- Obsolete _oracle_trace_facility_version
-- OK os_authent_prefix string prefix for auto-logon accounts
-- OK os_roles boolean retrieve roles from the operating system
-- OK parallel_adaptive_multi_user boolean enable adaptive setting of degree for multiple user streams
-- OK parallel_automatic_tuning boolean enable intelligent defaults for parallel execution parameters
-- Obsolete parallel_broadcast_enabled
-- Obsolete parallel_default_max_instances
-- OK parallel_degree_limit string limit placed on degree of parallelism
-- OK parallel_degree_policy string policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
-- OK parallel_execution_message_size integer message buffer size for parallel execution
-- OK parallel_force_local boolean force single instance execution
-- OK parallel_instance_group string instance group to use for all parallel operations
-- OK parallel_io_cap_enabled boolean enable capping DOP by IO bandwidth
-- OK parallel_max_servers integer maximum parallel query servers per instance
-- Obsolete parallel_min_message_pool
-- OK parallel_min_percent integer minimum percent of threads required for parallel query
-- OK parallel_min_servers integer minimum parallel query servers per instance
-- OK parallel_min_time_threshold string threshold above which a plan is a candidate for parallelization (in seconds)
-- OK parallel_server boolean if TRUE startup in parallel server mode
-- Obsolete parallel_server_idle_time
-- OK parallel_server_instances integer number of instances to use for sizing OPS SGA structures
-- OK parallel_servers_target integer instance target in terms of number of parallel servers
-- OK parallel_threads_per_cpu integer number of parallel execution threads per CPU
-- Obsolete parallel_transaction_resource_timeout
-- Obsolete partition_view_enabled
-- OK permit_92_wrap_format boolean allow 9.2 or older wrap format in PL/SQL
-- OK pga_aggregate_target big integer Target size for the aggregate PGA memory consumed by the instance
-- OK plscope_settings string plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
-- OK plsql_ccflags string PL/SQL ccflags
-- OK plsql_code_type string PL/SQL code-type
-- Obsolete plsql_compiler_flags
-- Obsolete _plsql_conditional_compilation
-- OK plsql_debug boolean PL/SQL debug
-- Obsolete plsql_native_c_compiler
-- Obsolete plsql_native_library_dir
-- Obsolete plsql_native_library_subdir_count
-- Obsolete plsql_native_linker
-- Obsolete plsql_native_make_file_name
-- Obsolete plsql_native_make_utility
-- OK plsql_optimize_level integer PL/SQL optimize level
-- OK plsql_v2_compatibility boolean PL/SQL version 2.x compatibility flag
-- OK plsql_warnings string PL/SQL compiler warnings settings
-- OK pre_page_sga boolean pre-page sga for process
-- OK processes integer user processes
-- OK processor_group_name string Name of the processor group that this instance should run in.
-- Obsolete push_join_predicate
-- OK query_rewrite_enabled string allow rewrite of queries using materialized views if enabled
-- OK query_rewrite_integrity string perform rewrite using materialized views with desired integrity
-- OK rdbms_server_dn string RDBMS's Distinguished Name
-- OK read_only_open_delayed boolean if TRUE delay opening of read only files until first access
-- OK recovery_parallelism integer number of server processes to use for parallel recovery
-- OK recyclebin string recyclebin processing
-- OK redo_transport_user string Data Guard transport user when using password file
-- Obsolete remote_archive_enable
-- OK remote_dependencies_mode string remote-procedure-call dependencies mode parameter
-- OK remote_listener string remote listener
-- OK remote_login_passwordfile string password file usage parameter
-- OK remote_os_authent boolean allow non-secure remote clients to use auto-logon accounts
-- OK remote_os_roles boolean allow non-secure remote clients to use os roles
-- OK replication_dependency_tracking boolean tracking dependency for Replication parallel propagation
-- OK resource_limit boolean master switch for resource limit
-- OK resource_manager_cpu_allocation integer Resource Manager CPU allocation
-- OK resource_manager_plan string resource mgr top plan
-- OK result_cache_max_result integer maximum result size as percent of cache size
-- OK result_cache_max_size big integer maximum amount of memory to be used by the cache
-- OK result_cache_mode string result cache operator usage mode
-- OK result_cache_remote_expiration integer maximum life time (min) for any result using a remote object
-- OK resumable_timeout integer set resumable_timeout
-- OK rollback_segments string undo segment list
-- Obsolete row_cache_cursors
-- Obsolete row_locking
-- OK sec_case_sensitive_logon boolean case sensitive password enabled for logon
-- OK sec_max_failed_login_attempts integer maximum number of failed login attempts on a connection
-- OK sec_protocol_error_further_action string TTC protocol error continue action
-- OK sec_protocol_error_trace_action string TTC protocol error action
-- OK sec_return_server_release_banner boolean whether the server retruns the complete version information
-- Obsolete _seq_process_cache_const
-- Obsolete sequence_cache_entries
-- Obsolete sequence_cache_hash_buckets
-- Obsolete serializable
-- OK serial_reuse string reuse the frame segments
-- OK service_names string service names supported by the instance
-- OK session_cached_cursors integer Number of cursors to cache in a session.
-- OK session_max_open_files integer maximum number of open files allowed per session
-- OK sessions integer user and system sessions
-- OK sga_max_size big integer max total SGA size
-- OK sga_target big integer Target size of SGA
-- OK shadow_core_dump string Core Size for Shadow Processes
-- OK shared_memory_address integer SGA starting address (low order 32-bits on 64-bit platforms)
-- Obsolete shared_pool_reserved_min_alloc
-- OK shared_pool_reserved_size big integer size in bytes of reserved area of shared pool
-- OK shared_pool_size big integer size in bytes of shared pool
-- OK shared_servers integer number of shared servers to start up
-- OK shared_server_sessions integer max number of shared server sessions
-- OK skip_unusable_indexes boolean skip unusable indexes if set to TRUE
-- OK smtp_out_server string utl_smtp server and port configuration parameter
-- Obsolete snapshot_refresh_interval
-- Obsolete snapshot_refresh_keep_connections
-- Obsolete snapshot_refresh_processes
-- OK sort_area_retained_size integer size of in-memory sort work area retained between fetch calls
-- OK sort_area_size integer size of in-memory sort work area
-- Obsolete sort_direct_writes
-- Obsolete sort_multiblock_read_count
-- Obsolete sort_read_fac
-- Obsolete sort_spacemap_size
-- Obsolete sort_write_buffers
-- Obsolete sort_write_buffer_size
-- OK spfile string server parameter file
-- Obsolete spin_count
-- OK sql92_security boolean require select privilege for searched update/delete
-- OK sql_trace boolean enable SQL trace
-- OK sqltune_category string Category qualifier for applying hintsets
-- Obsolete sql_version
-- OK standby_archive_dest string standby database archivelog destination text string
-- OK standby_file_management string if auto then files are created/dropped automatically on standby
-- Obsolete standby_preserves_names
-- OK star_transformation_enabled string enable the use of star transformation
-- OK statistics_level string statistics level
-- OK streams_pool_size big integer size in bytes of the streams pool
-- OK tape_asynch_io boolean Use asynch I/O requests for tape devices
-- Obsolete temporary_table_locks
-- Obsolete text_enable
-- OK thread integer Redo thread to mount
-- OK timed_os_statistics integer internal os statistic gathering interval in seconds
-- OK timed_statistics boolean maintain internal timing statistics
-- OK trace_enabled boolean enable in memory tracing
-- OK tracefile_identifier string trace file custom identifier
-- Obsolete transaction_auditing
-- OK transactions integer max. number of concurrent active transactions
-- OK transactions_per_rollback_segment integer number of active transactions per rollback segment
-- OK undo_management string instance runs in SMU mode if TRUE, else in RBU mode
-- OK undo_retention integer undo retention in seconds
-- Obsolete undo_suppress_errors
-- OK undo_tablespace string use/switch undo tablespace
-- OK use_indirect_data_buffers boolean Enable indirect data buffers (very large SGA on 32-bit platforms)
-- Obsolete use_ism
-- OK use_large_pages string Use large pages if available (TRUE/FALSE/ONLY)
-- OK user_dump_dest string User process dump directory
-- OK utl_file_dir string utl_file accessible directories list
-- OK workarea_size_policy string policy used to size SQL working areas (MANUAL/AUTO)
-- OK xml_db_events string are XML DB events enabled