oracle参数包括隐式参数

SQL> select x.ksppinm name, y.ksppstvl value, x.ksppdesc describ
  2  from sys.x$ksppi x,sys.x$ksppcv y
  3  where x.indx = y.indx;

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_trace_files_public            FALSE                Create publicly accessible trace files
tracefile_identifier                                trace file custom identifier
_hang_analysis_num_call_stacks 3                    hang analysis num call stacks
_ior_serialize_fault           0                    inject fault in the ior serialize code
_inject_startup_fault          0                    inject fault in the startup code
_latch_recovery_alignment      998                  align latch recovery structures
_spin_count                    2000                 Amount to spin waiting for a latch
_latch_miss_stat_sid           0                    Sid of process for which to collect latch stats
_max_sleep_holding_latch       4                    max time to sleep while holding a latch
_max_exponential_sleep         0                    max sleep during exponential backoff
_other_wait_threshold          0                    threshold wait percentage for event wait class Other

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_other_wait_event_exclusion                         exclude event names from _other_wait_threshold calculations
_use_vector_post               TRUE                 use vector post
_latch_class_0                                      latch class 0
_latch_class_1                                      latch class 1
_latch_class_2                                      latch class 2
_latch_class_3                                      latch class 3
_latch_class_4                                      latch class 4
_latch_class_5                                      latch class 5
_latch_class_6                                      latch class 6
_latch_class_7                                      latch class 7
_latch_classes                                      latch classes override

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_ultrafast_latch_statistics    TRUE                 maintain fast-path statistics for ultrafast latches
_enable_reliable_latch_waits   TRUE                 Enable reliable latch waits
_wait_samples_max_time_secs    120                  Wait Samples maximum time in seconds
_wait_samples_max_sections     40                   Wait Samples maximum sections
lock_name_space                                     lock name space used for generating lock names for standby/c
                                                    lone database

processes                      800                  user processes
sessions                       885                  user and system sessions
timed_statistics               TRUE                 maintain internal timing statistics
timed_os_statistics            0                    internal os statistic gathering interval in seconds

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
resource_limit                 FALSE                master switch for resource limit
license_max_sessions           0                    maximum number of non-system user sessions allowed
license_sessions_warning       0                    warning level for number of non-system user sessions
_session_idle_bit_latches      0                    one latch per session or a latch per group of sessions
_ksu_diag_kill_time            5                    number of seconds ksuitm waits before killing diag
_ksuitm_dont_kill_dumper       FALSE                delay inst. termination to allow processes to dump
_disable_image_check           FALSE                Disable Oracle executable image checking
_num_longop_child_latches      32                   number of child latches for long op array
_longops_enabled               TRUE                 longops stats enabled
_test_ksusigskip               5                    test the function ksusigskip
_disable_kcbhxor_osd           FALSE                disable kcbh(c)xor OSD functionality

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_disable_system_state          4294967294           disable system state dump
_disable_system_state_wait_sam FALSE                Disable system state dump - wait samples
ples

_session_wait_history          10                   enable session wait history collection
_session_idle_check_interval   60                   Resource Manager session idle limit check interval in second
                                                    s

_pkt_enable                    FALSE                enable progressive kill test
_pkt_start                     FALSE                start progressive kill test instrumention
_pkt_pmon_interval             50                   PMON process clean-up interval (cs)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_dead_process_scan_interval    10                   PMON dead process scan interval
_collapse_wait_history         FALSE                collapse wait history
_short_stack_timeout_ms        30000                short stack timeout in ms
_logout_storm_rate             0                    number of processes that can logout in a second
_logout_storm_timeout          5                    timeout in centi-seconds for time to wait between retries
_logout_storm_retrycnt         600                  maximum retry count for logouts
_single_process                FALSE                run without detached processes
_disable_cpu_check             FALSE                disable cpu_count check
cpu_count                      32                   number of CPUs for this instance
_dbg_proc_startup              FALSE                debug process startup
_static_backgrounds                                 static backgrounds

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_enqueue_deadlock_time_sec     5                    requests with timeout <= this will not have deadlock detecti
                                                    on

_number_cached_attributes      10                   maximum number of cached attributes per instance
instance_groups                                     list of instance group names
event                                               debug event control - default null string
_oradebug_force                FALSE                force target processes to execute oradebug commands?
_ksdxdocmd_default_timeout_ms  30000                default timeout for internal oradebug commands
_watchpoint_on                 FALSE                is the watchpointing feature turned on?
_ksdxw_num_sgw                 10                   number of watchpoints to be shared by all processes
_ksdxw_num_pgw                 10                   number of watchpoints on a per-process basis

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_ksdxw_stack_depth             4                    number of PCs to collect in the stack when watchpoint is hit
_ksdxw_cini_flg                0                    ksdxw context initialization flag
_ksdxw_nbufs                   1000                 ksdxw number of buffers in buffered mode
sga_max_size                   16827547648          max total SGA size
_enable_shared_pool_durations  TRUE                 temporary to disable/enable kgh policy
_NUMA_pool_size                Not specified        aggregate size in bytes of NUMA pool
_enable_NUMA_optimization      FALSE                Enable NUMA specific optimizations
pre_page_sga                   FALSE                pre-page sga for process
shared_memory_address          0                    SGA starting address (low order 32-bits on 64-bit platforms)
hi_shared_memory_address       0                    SGA starting address (high order 32-bits on 64-bit platforms
                                                    )

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

use_indirect_data_buffers      FALSE                Enable indirect data buffers (very large SGA on 32-bit platf
                                                    orms)

_use_ism                       TRUE                 Enable Shared Page Tables - ISM
lock_sga                       FALSE                Lock entire SGA in physical memory
_lock_sga_areas                0                    Lock specified areas of the SGA in physical memory
_NUMA_instance_mapping         Not specified        Set of nodes that this instance should run on
_simulator_upper_bound_multipl 2                    upper bound multiple of pool size
e


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_simulator_pin_inval_maxcnt    16                   maximum count of invalid chunks on pin list
_simulator_lru_rebalance_thres 10240                LRU list rebalance threshold (count)
h

_simulator_lru_rebalance_sizth 2                    LRU list rebalance threshold (size)
r

_simulator_bucket_mindelta     8192                 LRU bucket minimum delta
_simulator_lru_scan_count      8                    LRU scan count
_simulator_internal_bound      10                   simulator internal bound percent
_simulator_reserved_obj_count  1024                 simulator reserved object count

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_simulator_reserved_heap_count 4096                 simulator reserved heap count
_simulator_sampling_factor     2                    sampling factor for the simulator
_realfree_heap_max_size        32768                minimum max total heap size, in Kbytes
_realfree_heap_pagesize_hint   65536                hint for real-free page size in bytes
_realfree_heap_mode            0                    mode flags for real-free heap
_use_realfree_heap             TRUE                 use real-free based allocator for PGA memory
_pga_large_extent_size         1048576              PGA large extent size
_uga_cga_large_extent_size     262144               UGA/CGA large extent size
_total_large_extent_memory     0                    Total memory for allocating large extents
_use_ism_for_pga               TRUE                 Use ISM for allocating large extents
_private_memory_address                             Start address of large extent memory segment

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_mem_annotation_sh_lev         0                    shared memory annotation collection level
_mem_annotation_pr_lev         0                    private memory annotation collection level
_mem_annotation_scale          1                    memory annotation pre-allocation scaling
_mem_annotation_store          FALSE                memory annotation in-memory store
_4031_dump_bitvec              67194879             bitvec to specify dumps prior to 4031 error
_4031_max_dumps                100                  Maximum number of 4031 dumps for this process
_4031_dump_interval            300                  Dump 4031 error once for each n-second interval
_4031_sga_dump_interval        3600                 Dump 4031 SGA heapdump error once for each n-second interval
_4031_sga_max_dumps            10                   Maximum number of SGA heapdumps
_4030_dump_bitvec              4095                 bitvec to specify dumps prior to 4030 error
_numa_trace_level              0                    numa trace event

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_mem_std_extent_size           4096                 standard extent size for fixed-size-extent heaps
_ksm_pre_sga_init_notif_delay_ 0                    seconds to delay instance startup at sga initialization (pre
secs                                                )

_ksm_post_sga_init_notif_delay 0                    seconds to delay instance startup at sga initialization (pos
_secs                                               t)

__shared_pool_size             939524096            Actual size in bytes of shared pool
shared_pool_size               838860800            size in bytes of shared pool
__large_pool_size              16777216             Actual size in bytes of large pool
large_pool_size                0                    size in bytes of large pool

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
__java_pool_size               16777216             Actual size in bytes of java pool
java_pool_size                 0                    size in bytes of java pool
__streams_pool_size            33554432             Actual size in bytes of streams pool
streams_pool_size              0                    size in bytes of the streams pool
_large_pool_min_alloc          65536                minimum allocation size in bytes for the large allocation po
                                                    ol

shared_pool_reserved_size      46976204             size in bytes of reserved area of shared pool
_shared_pool_reserved_pct      5                    percentage memory of the shared pool allocated for the reser
                                                    ved area


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_shared_pool_reserved_min_allo 4400                 minimum allocation size in bytes for reserved area of shared
c                                                    pool

java_soft_sessionspace_limit   0                    warning limit on size in bytes of a Java sessionspace
java_max_sessionspace_size     0                    max allowed size in bytes of a Java sessionspace
_kghdsidx_count                7                    max kghdsidx count
_test_param_1                  25                   test parmeter 1 - integer
_test_param_2                                       test parameter 2 - string
_test_param_3                                       test parameter 3 - string
_test_param_4                                       test parameter 4 - string list
_test_param_5                  25                   test parmeter 5 - deprecated integer

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_test_param_6                  0                    test parmeter 6 - size (ub8)
spfile                         /home/oracle/oracle1 server parameter file
                               0g/dbs/spfilezxin.or
                               a

instance_type                  RDBMS                type of instance to be executed
_disable_instance_params_check FALSE                disable instance type check for ksp
_parameter_table_block_size    2048                 parameter table block size
_ksb_disable_diagpid           FALSE                disable the call to ksb_diagpid
_diag_proc_stack_capture_type  1                    hung process diagnostic API stack capture type
_diag_proc_max_time_ms         30000                hung process diagnostic API max wait time in milliseconds

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_high_priority_processes       LMS*                 High Priority Process Name Mask
_os_sched_high_priority        1                    OS high priority level
_ksb_restart_clean_time        30000                process uptime for restarts
_ksb_restart_policy_times                           process restart policy times in seconds
_high_priority_process_num_yie 1000                 the number of yields performed by high priority processesbef
lds_before_sleep                                    ore they sleep

_ksd_test_param                999                  KSD test parmeter
_kse_die_timeout               60000                amount of time a dying process is spared by PMON (in centi-s
                                                    ecs)


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_stack_guard_level             0                    stack guard level
_kse_pc_table_size             256                  kse pc table cache size
_messages                      1600                 message queue resources - dependent on # processes & # buffe
                                                    rs

_enqueue_locks                 10870                locks for managed enqueues
_enqueue_resources             4112                 resources for enqueues
_enqueue_hash                  1805                 enqueue hash table length
_enqueue_debug_multi_instance  FALSE                debug enqueue multi instance
_enqueue_hash_chain_latches    32                   enqueue hash chain latches
_enqueue_deadlock_scan_secs    0                    deadlock scan interval

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_enqueue_2049_debug_level      0                    enqueue timeout ORA-02049 debug diagnostic level
_ksi_trace                                          KSI trace string of lock type(s)
trace_enabled                  TRUE                 enable KST tracing
_trace_processes               ALL                  enable KST tracing in process
_trace_archive                 FALSE                start DIAG process
_trace_events                                       trace events enabled at startup
_trace_buffers                 ALL:256              trace buffer sizes per process
_trace_flush_processes         ALL                  trace data archived by DIAG for these processes
_trace_file_size               65536                maximum size of trace file (in bytes)
_trace_options                 text,multiple        trace data flush options
_trace_buffer_wrap_timestamp   TRUE                 enable KST timestamp on trace buffer wrap

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
nls_language                   AMERICAN             NLS language name
nls_territory                  AMERICA              NLS territory name
nls_sort                                            NLS linguistic definition name
nls_date_language                                   NLS date language name
nls_date_format                                     NLS Oracle date format
nls_currency                                        NLS local currency symbol
nls_numeric_characters                              NLS numeric characters
nls_iso_currency                                    NLS ISO currency territory name
nls_calendar                                        NLS calendar system name
nls_time_format                                     time format
nls_timestamp_format                                time stamp format

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
nls_time_tz_format                                  time with timezone format
nls_timestamp_tz_format                             timestampe with timezone format
nls_dual_currency                                   Dual currency symbol
nls_comp                                            NLS comparison
nls_length_semantics           BYTE                 create columns using byte or char semantics by default
nls_nchar_conv_excp            FALSE                NLS raise an exception instead of allowing implicit conversi
                                                    on

_nchar_imp_cnv                 TRUE                 NLS allow Implicit Conversion between CHAR and NCHAR
_disable_file_locks            FALSE                disable file locks for control, data, redo log files
_ksfd_verify_write             FALSE                verify asynchronous writes issued through ksfd

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_disable_odm                   FALSE                disable odm feature
fileio_network_adapters                             Network Adapters for File I/O
_enable_list_io                FALSE                Enable List I/O
filesystemio_options           none                 IO operations on filesystem files
_omf                           enabled              enable/disable OMF
_aiowait_timeouts              100                  Number of aiowait timeouts before error is reported
_io_shared_pool_size           4194304              Size of I/O buffer pool from SGA
_db_file_direct_io_count       1048576              Sequential I/O buf size
_ioslave_issue_count           500                  IOs issued before completion check
_ioslave_batch_count           1                    Per attempt IOs picked
disk_asynch_io                 TRUE                 Use asynch I/O for random access devices

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
tape_asynch_io                 TRUE                 Use asynch I/O requests for tape devices
_io_slaves_disabled            FALSE                Do not use I/O slaves
dbwr_io_slaves                 0                    DBWR I/O slaves
_lgwr_io_slaves                0                    LGWR I/O slaves
_arch_io_slaves                0                    ARCH I/O slaves
_backup_disk_io_slaves         0                    BACKUP Disk I/O slaves
backup_tape_io_slaves          FALSE                BACKUP Tape I/O slaves
_backup_io_pool_size           1048576              memory to reserve from the large pool
_high_server_threshold         0                    high server thresholds
_low_server_threshold          0                    low server thresholds
_active_session_idle_limit     0                    active session idle limit

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_active_session_legacy_behavio FALSE                active session legacy behavior
r

resource_manager_plan                               resource mgr top plan
_yield_check_interval          100000               interval to check whether actses should yield
_resource_manager_always_on    TRUE                 enable the resource manager always
_rm_numa_simulation_pgs        0                    number of PGs for numa simulation in resource manager
_rm_numa_simulation_cpus       0                    number of cpus for numa simulation in resource manager
_rm_numa_sched_enable          TRUE                 Is Resource Manager (RM) related NUMA scheduled policy enabl
                                                    ed


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_dbrm_runchk                   0                    Resource Manager Diagnostic Running Thread Check
_dbrm_readylist_chk            1                    Resource Manager Diagnostic Ready List Check
_first_spare_parameter                              first spare parameter - integer
_second_spare_parameter                             second spare parameter - integer
_third_spare_parameter                              third spare parameter - integer
_fourth_spare_parameter                             fourth spare parameter - integer
_fifth_spare_parameter                              fifth spare parameter - integer
_sixth_spare_parameter                              sixth spare parameter - integer
_seventh_spare_parameter                            seventh spare parameter - integer
_eighth_spare_parameter                             eighth spare parameter - integer
_ninth_spare_parameter                              ninth spare parameter - integer

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_tenth_spare_parameter                              tenth spare parameter - integer
_eleventh_spare_parameter                           eleventh spare parameter - string
_twelfth_spare_parameter                            twelfth spare parameter - string
_thirteenth_spare_parameter                         thirteenth spare parameter - string
_fourteenth_spare_parameter                         fourteenth spare parameter - string
_fifteenth_spare_parameter                          fifteenth spare parameter - string
_sixteenth_spare_parameter                          sixteenth spare parameter - string list
_seventeenth_spare_parameter                        seventeenth spare parameter - string list
_eighteenth_spare_parameter                         eighteenth spare parameter - string list
_nineteenth_spare_parameter                         nineteenth spare parameter - string list
_twentieth_spare_parameter                          twentieth spare parameter - string list

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
cluster_interconnects                               interconnects for RAC use
_ksxp_send_timeout             300                  set timeout for sends queued with the inter-instance IPC
_ksxp_diagmode                 OFF                  set to OFF to disable automatic slowsend diagnostics
_skgxp_reaping                 1000                 tune skgxp OSD reaping limit
_ksxp_reaping                  20                   tune ksxp layer reaping limit
_ksxp_usemd                    1                    use skgxp md optimization
_skgxp_udp_hiwat_warn          1000                 ach hiwat mark warning interval
_skgxp_udp_ach_reaping_time    0                    time in minutes before idle ach's are reaped
_skgxp_udp_timed_wait_seconds  5                    time in seconds before timed wait is invoked
_skgxp_udp_timed_wait_bufferin 1024                 diagnostic log buffering space (in bytes) for timed wait (0
g                                                   means unbufferd

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_skgxp_udp_keep_alive_ping_tim 300                  connection idle time in seconds before keep alive is initiat
er_secs                                             ed. min: 30 sec max: 1800 sec default: 300 sec

_disable_duplex_link           TRUE                 Turn off connection duplexing
_diag_diagnostics              TRUE                 Turn off diag diagnostics
_disable_interface_checking    FALSE                disable interface checking at startup
_skgxp_udp_interface_detection 60                   time in seconds between interface detection checks
_time_secs

_skgxp_shared_port             0                    limit sockets opened by SGA regions (default: 0 = no limit)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_skgxp_udp_lmp_on              FALSE                enable UDP long message protection
_skgxp_udp_lmp_mtusize         0                    MTU size for UDP LMP testing
_ksxp_testing                  0                    KSXP test parameter
_skgxp_udp_adjust_iov          FALSE                adjust IOV for UDP long message protection
_ksxp_reporting_process        LMD0                 reporting process for KSXP
_ksxp_proto_ver                0                    ksxp proto ver
_skgxp_impl_ver                0                    skgxp impl ver
_skgxp_rel_ver                 0                    skgxp rel ver
_ksxp_compat_flags             0                    ksxp compat flags
_ksxp_dynamic_skgxp_param                           dynamic skgxp parameters
_skgxp_ctx_flags1              0                    IPC debug options flags (RAC)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_skgxp_dynamic_protocol        4096                 IPC protocol override (RAC) (0/-1=*,2=UDP,3=RDS,!0x1000=ipc_
                                                    X)

_skgxp_spare_param1                                 ipc ksxp spare parameter 1
_skgxp_spare_param2                                 ipc ksxp spare parameter 2
_skgxp_spare_param3                                 ipc ksxp spare parameter 3
_skgxp_spare_param4                                 ipc ksxp spare parameter 4
_skgxp_spare_param5                                 ipc ksxp spare parameter 5
_skgxpg_last_parameter         12                   last defined skgxpg parameter - ksxp
_ksmg_granule_size             16777216             granule size in bytes
_ksmg_granule_locking_status   1                    granule locking status

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_ksmg_lock_check_interval                           timeout action interval in minutes
_ksmg_lock_reacquire_count     5                    repeat count for acquisition of locks
file_mapping                   FALSE                enable file mapping
_filemap_dir                                        FILEMAP directory
_object_statistics             TRUE                 enable the object level statistics collection
_disable_objstat_del_broadcast TRUE                 disable the object level delete statistics broadcast
_ignored_tbs_list                                   ignored tablespace list
_enable_rlb                    TRUE                 enable RLB metrics processing
_disable_health_check          FALSE                Disable Health Check
_accept_versions                                    List of parameters for rolling operation
_hang_detection                0                    Hang Management detection interval

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_diag_daemon                   TRUE                 start DIAG daemon
_dump_system_state_scope       local                scope of sysstate dump during instance termination
_dump_trace_scope              global               scope of trace dump during a process crash
_dump_interval_limit           120                  trace dump time interval limit (in seconds)
_dump_max_limit                5                    max number of dump within dump interval
_diag_dump_timeout             30                   timeout parameter for SYNC dump
_trace_navigation_scope        global               enabling trace navigation linking
_max_protocol_support          10000                Max occurrence protocols supported in a process
_lm_lms                        0                    number of background gcs server processes to start
gcs_server_processes           0                    number of background gcs server processes to start
_lm_dynamic_lms                FALSE                dynamic lms invocation

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_max_lms                    0                    max. number of background global cache server processes
_lm_min_lms                    0                    min. number of background global cache server processes
_lm_activate_lms_threshold     100                  threshold value to activate an additional lms
_lm_lmd_waittime               8                    default wait time for lmd in centiseconds
_lm_lms_waittime               8                    default wait time for lms in centiseconds
_lm_procs                      320                  number of client processes configured for cluster database
_lm_ress                       6000                 number of resources configured for cluster database
_lm_locks                      12000                number of enqueues configured for cluster database
_lm_master_weight              1                    master resource weight for this instance
active_instance_count                               number of active instances in the cluster database
_active_standby_fast_reconfigu TRUE                 if TRUE optimize dlm reconfiguration for active/standby OPS

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
ration

_lm_enq_rcfg                   TRUE                 if TRUE enables enqueue reconfiguration
_lm_dynamic_remastering        FALSE                if TRUE enables dynamic remastering
_lm_xids                       352                  number of transaction IDs configured for cluster database
_lm_res_part                   128                  number of resource partition configured for gcs
_lm_drm_window                 0                    dynamic remastering bucket window size
_lm_drm_max_requests           100                  dynamic remastering maximum affinity requests processed toge
                                                    ther

_lm_drm_xlatch                 0                    dynamic remastering forced exclusive latches

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_drm_disable                0                    disable drm in different level
_lm_contiguous_res_count       128                  number of contiguous blocks that will hash to the same HV bu
                                                    cket

_lm_num_pt_buckets             4096                 number of buckets in the object affinity hash table
_lm_num_pt_latches             128                  number of latches in the object affinity hash table
_lm_num_pcmhv_latches          0                    number of latches covering the PCM HV buckets in cgs
_lm_node_join_opt              FALSE                cluster database node join optimization in reconfig
_lm_non_fault_tolerant         FALSE                disable cluster database fault-tolerance mode
_lm_cache_res_cleanup          25                   percentage of cached resources should be cleanup
_lm_cache_res_type             TMHWDI               cache resource: string of lock types(s)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_cache_lvl0_cleanup         0                    how often to cleanup level 0 cache res (in sec)
_lm_send_buffers               10000                number of cluster database send buffers
_lm_rcv_buffer_size            32768                the size of receive buffer
_lm_preregister_css_restype    CF                   enqueue type that requires pre-registration to css
_inquiry_retry_interval        3                    if greater than 0 enables inquiry retry after specified inte
                                                    rval

_lm_drm_object_scan            TRUE                 enable/disable object scan to force full table scan always
_gcs_testing                   0                    GCS testing parameter
_ogms_home                                          GMS home directory
_lm_sync_timeout                                    Synchronization timeout for DLM reconfiguration steps

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_ticket_active_sendback                          Flow control ticket active sendback threshold
_lm_rcfg_timeout               180000               Reconfiguration timeout
_lm_enq_lock_freelist                               Number of ges enqueue element freelist
_lm_enqueue_freelist           3                    Number of enqueue freelist
_lm_dd_interval                60                   dd time interval in seconds
_lm_dd_scan_interval           5                    dd scan interval in seconds
_lm_dd_search_cnt              3                    number of dd search per token get
_lm_dd_max_search_time         180                  max dd search time per token
_lm_dd_maxdump                 50                   max number of locks to be dumped during dd validation
_dlmtrace                                           Trace string of global enqueue type(s)
_lm_tx_delta                   16                   TX lock localization delta

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_proc_freeze_timeout        300                  reconfiguration: process freeze timeout
_lm_validate_resource_type     FALSE                if TRUE enables resource name validation
_lm_file_affinity                                   mapping between file id and master instance number
_lm_share_lock_opt             FALSE                if TRUE enables share lock optimization
_lm_res_hash_bucket            0                    number of resource hash buckets
_ges_diagnostics               TRUE                 if TRUE enables GES diagnostics
_fair_remote_cvt               FALSE                if TRUE enables fair remote convert
_dlm_send_timeout              30000                DLM send timeout value
_lm_rcvr_hang_check_frequency  60                   receiver hang check frequency in seconds
_lm_rcvr_hang_allow_time       200                  receiver hang allow time in seconds
_lm_rcvr_hang_kill             TRUE                 to kill receiver hang

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_ges_dd_debug                  1                    if 1 or higher enables GES deadlock detection debug diagnost
                                                    ics

_lm_global_posts               TRUE                 if TRUE deliver global posts to remote nodes
_rcfg_parallel_replay          TRUE                 if TRUE enables parallel replay and cleanup at reconfigurati
                                                    on

_parallel_replay_msg_limit     4000                 Number of messages for each round of parallel replay
_rcfg_parallel_fixwrite        TRUE                 if TRUE enables parallel fixwrite at reconfiguration
_parallel_fixwrite_bucket      1000                 Number of buckets for each round of fix write
_rcfg_parallel_verify          TRUE                 if TRUE enables parallel verify at reconfiguration

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_rcfg_disable_verify           FALSE                if TRUE disables verify at reconfiguration
_dump_rcvr_ipc                 TRUE                 if TRUE enables IPC dump at instance eviction time
_ges_health_check              1                    if greater than 0 enables GES system health check
_kill_enqueue_blocker          3                    if greater than 0 enables killing enqueue blocker
_gcs_pkey_history              4000                 number of pkey remastering history
_lm_better_ddvictim            TRUE                 GES better deadlock victim
_lm_msg_batch_size             0                    GES batch message size
_lm_tickets                    1000                 GES messaging tickets
_lm_msg_cache_thresholds                            GES message buffer caching threshold
_lm_msg_cleanup_interval       3000                 GES message buffer cleanup interval time
_lm_send_mode                  auto                 GES send mode

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_postevent_buffer_size      256                  postevent buffer size
_lm_send_queue_length          5000                 GES send queue maximum length
_lm_send_queue_batching        TRUE                 GES send queue message batching
_lm_process_batching           TRUE                 GES implicit process batching for IPC messages
_lm_sq_batch_factor            2                    GES send queue minimum batching factor
_lm_sq_batch_type              auto                 GES send queue batching mechanism
_lm_sq_batch_waittick          3                    GES send queue batching waittime in tick
_lm_sendproxy_reserve          25                   GES percentage of send proxy reserve of send tickets
_lm_checksum_batch_msg         FALSE                GES checksum batch messages
_abort_recovery_on_join        FALSE                if TRUE, abort recovery on join reconfigurations
_send_ast_to_foreground        TRUE                 if TRUE, send ast message to foreground

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_reliable_block_sends          FALSE                if TRUE, block sends across interconnect are reliable
_blocks_per_cache_server       128                  number of consecutive blocks per global cache server
_object_reuse_bast             2                    if 1 or higher, handle object reuse
_send_close_with_block         TRUE                 if TRUE, send close with block even with direct sends
_gcs_fast_reconfig             TRUE                 if TRUE, enable fast reconfiguration for gcs locks
_cr_grant_global_role          TRUE                 if TRUE, grant lock for CR requests when block is in global
                                                    role

_cr_grant_local_role           AUTO                 turn 3-way CR grants off, make it automatic, or turn it on
_skip_assume_msg               TRUE                 if TRUE, skip assume message for consigns at the master
_gcs_resources                                      number of gcs resources to be allocated

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_gcs_latches                   0                    number of gcs resource hash latches to be allocated per LMS
                                                    process

_gcs_process_in_recovery       TRUE                 if TRUE, process gcs requests during instance recovery
_scatter_gcs_resources         FALSE                if TRUE, gcs resources are scattered uniformly across sub po
                                                    ols

_gcs_shadow_locks                                   number of pcm shadow locks to be allocated
_scatter_gcs_shadows           FALSE                if TRUE, gcs shadows are scattered uniformly across sub pool
                                                    s


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_async_object_flush            TRUE                 if FALSE, disable asychronous object flush
_side_channel_batch_size       200                  number of messages to batch in a side channel message (DFS)
_side_channel_batch_timeout    6                    timeout before shipping out the batched side channelmessages
                                                     in seconds

_side_channel_batch_timeout_ms 500                  timeout before shipping out the batched side channelmessages
                                                     in milliseconds

_broadcast_scn_wait_timeout    10                   broadcast-on-commit scn wait timeout in centiseconds
_master_direct_sends           31                   direct sends for messages from master (DFS)
_cgs_send_timeout              300                  CGS send timeout value

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_imr_active                    TRUE                 Activate Instance Membership Recovery feature
_imr_max_reconfig_delay        300                  Maximum Reconfiguration delay (seconds)
_imr_splitbrain_res_wait       600                  Maximum wait for split-brain resolution (seconds)
_imr_disk_voting_interval      3                    Maximum wait for IMR disk voting (seconds)
_imr_systemload_check          TRUE                 Perform. the system load check during IMR
_imr_highload_threshold                             IMR system highload threshold
_imr_testing                   0                    IMR internal testing parameter
_cluster_library               clss                 cluster library selection
_cgs_reconfig_timeout          120                  CGS reconfiguration timeout interval
_lm_dynamic_load               TRUE                 dynamic load adjustment
_notify_crs                    FALSE                notify cluster ready services of startup and shutdown

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_kill_diagnostics_timeout      60                   timeout delay in seconds before killing enqueue blocker
_lm_rac_spare_p1               0                    rac parameter p1
_lm_rac_spare_p2               0                    rac parameter p2
_lm_rac_spare_p3               0                    rac parameter p3
_lm_rac_spare_p4               0                    rac parameter p4
_lm_rac_spare_p5               0                    rac parameter p5
_lm_rac_spare_p6                                    rac parameter p6
_lm_rac_spare_p7                                    rac parameter p7
_lm_rac_spare_p8                                    rac parameter p8
_lm_rac_spare_p9                                    rac parameter p9
_lm_rac_spare_p10                                   rac parameter p10

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_lm_rac_spare_dp1              0                    rac parameter dp1
_lm_rac_spare_dp2              0                    rac parameter dp2
_lm_rac_spare_dp3              0                    rac parameter dp3
_lm_rac_spare_dp4              0                    rac parameter dp4
_lm_rac_spare_dp5              0                    rac parameter dp5
_lm_rac_spare_dp6                                   rac parameter dp6
_lm_rac_spare_dp7                                   rac parameter dp7
_lm_rac_spare_dp8                                   rac parameter dp8
_lm_rac_spare_dp9                                   rac parameter dp9
_lm_rac_spare_dp10                                  rac parameter dp10
sga_target                     16827547648          Target size of SGA

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_shared_pool_max_size          0                    shared pool maximum size when auto SGA enabled
_shared_pool_minsize_on        FALSE                shared pool minimum size when auto SGA enabled
_streams_pool_max_size         0                    streams pool maximum size when auto SGA enabled
_disable_streams_pool_auto_tun FALSE                disable streams pool auto tuning
ing

_memory_management_tracing     0                    trace memory management activity
_memory_mgmt_immreq_timeout    150                  time in seconds to time out immediate mode request
_memory_sanity_check           0                    partial granule sanity check
_init_granule_interval         10                   number of granules to process for deferred cache
_memory_broker_stat_interval   30                   memory broker statistics gathering interval

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_memory_broker_shrink_heaps    15                   memory broker allow policy to shrink shared pool
_memory_broker_shrink_java_hea 900                  memory broker allow policy to shrink java pool
ps

_memory_broker_shrink_streams_ 900                  memory broker allow policy to shrink streams pool
pool

_memory_broker_shrink_timeout  60000000             memory broker policy to timeout shrink shared/java pool
_memory_broker_log_stat_entrie 5                    memory broker num stat entries
s


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_memory_broker_marginal_utilit 4                    Marginal Utility threshold pct for sp
y_sp

_memory_broker_marginal_utilit 10                   Marginal Utility threshold pct for bc
y_bc

_disable_latch_free_SCN_writes FALSE                disable latch-free SCN writes using 32-bit compare & swap
_via_32cas

_disable_latch_free_SCN_writes FALSE                disable latch-free SCN writes using 64-bit compare & swap
_via_64cas

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

control_files                  /zxindata/oracle/con control file names list
                               trol/control01.ctl,
                               /zxindata/oracle/con
                               trol/control02.ctl,
                               /zxindata/oracle/con
                               trol/control03.ctl

_controlfile_enqueue_timeout   900                  control file enqueue timeout in seconds
_controlfile_enqueue_holding_t 120                  control file enqueue max holding time in seconds
ime

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_controlfile_update_check      OFF                  controlfile update sanity check
_controlfile_enqueue_dump      FALSE                dump the system states after controlfile enqueue timeout
_controlfile_block_size        0                    control file block size in bytes
_controlfile_section_init_size                      control file initial section size
_controlfile_section_max_expan                      control file max expansion rate
d

db_file_name_convert                                datafile name convert patterns and strings for standby/clone
                                                     db


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
log_file_name_convert                               logfile name convert patterns and strings for standby/clone
                                                    db

control_file_record_keep_time  7                    control file record keep time in days
_kill_controlfile_enqueue_bloc TRUE                 enable killing controlfile enqueue blocker on timeout
ker

db_block_buffers               0                    Number of database blocks cached in memory
_db_block_buffers              1864218              Number of database blocks cached in memory: hidden parameter
_db_block_cache_protect        FALSE                protect database blocks (true only when debugging)
_db_block_cache_protect_intern 0                    protect database blocks (for strictly internal use only)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
al

db_block_checksum              TRUE                 store checksum in db blocks and check during reads
db_block_size                  8192                 Size of database block in bytes
_dbwr_tracing                  0                    Enable dbwriter tracing
_disable_multiple_block_sizes  FALSE                disable multiple block size support (for debugging)
_db_fast_obj_truncate          TRUE                 enable fast object truncate
_db_fast_obj_ckpt              TRUE                 enable fast object checkpoint
_db_obj_enable_ksr             TRUE                 enable ksr in object checkpoint/reuse
_small_table_threshold         37284                threshold level of table size for direct reads
_db_block_cache_num_umap       0                    number of unmapped buffers (for tracking swap calls on block

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    s)

_dbwr_async_io                 TRUE                 Enable dbwriter asynchronous writes
_recovery_percentage           50                   recovery buffer cache percentage
_db_lost_write_checking        FALSE                Enable scn based lost write detection mechanism
__db_cache_size                15804137472          Actual size of DEFAULT buffer pool for standard block size b
                                                    uffers

db_cache_size                  15753805824          Size of DEFAULT buffer pool for standard block size buffers
_db_block_numa                 1                    Number of NUMA nodes
db_2k_cache_size               0                    Size of cache for 2K buffers

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
db_4k_cache_size               0                    Size of cache for 4K buffers
db_8k_cache_size               0                    Size of cache for 8K buffers
db_16k_cache_size              0                    Size of cache for 16K buffers
db_32k_cache_size              0                    Size of cache for 32K buffers
db_keep_cache_size             0                    Size of KEEP buffer pool for standard block size buffers
db_recycle_cache_size          0                    Size of RECYCLE buffer pool for standard block size buffers
_clear_buffer_before_reuse     FALSE                Always zero-out buffer before reuse for security
_db_block_lru_latches          128                  number of lru latches
_db_percpu_create_cachesize    2                    size of cache created per cpu in deferred cache create
_db_todefer_cache_create       TRUE                 buffer cache deferred create
db_writer_processes            4                    number of background database writer  processes to start

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_block_known_clean_pct      2                    Initial Percentage of buffers to maintain known clean
_db_block_max_scan_pct         40                   Percentage of buffers to inspect when looking for free
_db_large_dirty_queue          25                   Number of buffers which force dirty queue to be written
_db_writer_max_writes          0                    Max number of outstanding DB Writer IOs
_db_writer_chunk_writes        0                    Number of writes DBWR should wait for
_db_block_med_priority_batch_s 0                    Fraction of writes for medium priority reasons
ize

_db_block_hi_priority_batch_si 0                    Fraction of writes for high priority reasons
ze


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_writer_histogram_statistic FALSE                maintain dbwr histogram statistics in x$kcbbhs
s

_dbwr_scan_interval            300                  dbwriter scan interval
_db_writer_flush_imu           TRUE                 If FALSE, DBWR will not downgrade IMU txns for AGING
_db_writer_coalesce_write_limi 131072               Limit on size of coalesced write
t

_db_writer_coalesce_area_size  1048576              Size of memory allocated to dbwriter for coalescing writes
_selftune_checkpoint_write_pct 3                    Percentage of total physical i/os for self-tune ckpt
_db_writer_verify_writes       FALSE                Enable lost write detection mechanism

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_block_prefetch_quota       10                   Prefetch quota as a percent of cache size
_db_block_prefetch_limit       0                    Prefetch limit in blocks
_db_cache_pre_warm             TRUE                 Buffer Cache Pre-Warm Enabled : hidden parameter
buffer_pool_keep                                    Number of database blocks/latches in keep buffer pool
buffer_pool_recycle                                 Number of database blocks/latches in recycle buffer pool
_db_percent_hot_default        50                   Percent of default buffer pool considered hot
_db_percent_hot_keep           0                    Percent of keep buffer pool considered hot
_db_percent_hot_recycle        0                    Percent of recycle buffer pool considered hot
_db_aging_hot_criteria         2                    Touch count which sends a buffer to head of replacement list
_db_aging_stay_count           0                    Touch count set when buffer moved to head of replacement lis
                                                    t

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_db_aging_cool_count           1                    Touch count set when buffer cooled
_db_aging_touch_time           3                    Touch count which sends a buffer to head of replacement list
_db_aging_freeze_cr            FALSE                Make CR buffers always be too cold to keep in cache
_db_block_hash_buckets         4194304              Number of database block hash buckets
_db_block_hash_latches         131072               Number of database block hash latches
_db_blocks_per_hash_latch                           Number of blocks per hash latch
_db_handles                    4000                 System-wide simultaneous buffer operations
_db_handles_cached             5                    Buffer handles cached each process
_wait_for_sync                 TRUE                 wait for sync on commit MUST BE ALWAYS TRUE
_db_block_vlm_check            FALSE                check of rvlm mapping leaks (for debugging)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_block_vlm_leak_threshold   3                    Threshold for allowable vlm leaks
_db_block_cache_clone          FALSE                Always clone data blocks on get (for debugging)
_db_block_trace_protect        FALSE                trace buffer protect calls
_db_cache_miss_check_les       FALSE                check LEs after cache miss
_db_block_max_cr_dba           6                    Maximum Allowed Number of CR buffers per dba
_trace_buffer_flushes          FALSE                trace buffer flushes if otrace cacheIO event is set
_trace_multi_block_reads       FALSE                trace multi_block reads if otrace cacheIO event is set
_trace_cr_buffer_creates       FALSE                trace cr buffer creates if otrace cacheIO event is set
_write_clones                  3                    write clones flag
_trace_buffer_gets             FALSE                trace kcb buffer gets if otrace cacheIO event is set
_check_block_after_checksum    TRUE                 perform. block check after checksum if both are turned on

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_trace_pin_time                0                    trace how long a current pin is held
_db_fast_obj_check             FALSE                enable fast object drop sanity check
_db_block_temp_redo            FALSE                generate redo for temp blocks
_db_block_adjchk_level         0                    adjacent cache buffer check level
_db_block_adjcheck             TRUE                 adjacent cache buffer checks - low blkchk overwrite paramete
                                                    r

_db_required_percent_fairshare 10                   percent of fairshare a processor group should always use
_usage

_db_block_check_objtyp         TRUE                 check objd and typ on cache disk read

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_block_do_full_mbreads      FALSE                do full block read even if some blocks are in cache
_trace_buffer_wait_timeouts    0                    trace buffer busy wait timeouts
_buffer_busy_wait_timeout      100                  buffer busy wait time in centiseconds
_db_cache_crx_check            FALSE                check for costly crx examination functions
_db_hot_block_tracking         FALSE                track hot blocks for hash latch contention
_db_block_cache_history        0                    buffer header tracing (non-zero only when debugging)
_db_block_cache_history_level  2                    buffer header tracing level
_db_block_table_scan_buffer_si 4194304              Size of shared table scan read buffer
ze

_db_obj_ckpt_ordered           FALSE                fast object checkpoint ordered by lrba

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_cache_process_cr_pin_max                        maximum number of cr pins a process may have
db_cache_advice                ON                   Buffer cache sizing advisory
_db_cache_advice_sample_factor 4                    cache advisory sampling factor
_db_cache_advice_max_size_fact 2                    cache advisory maximum multiple of current size to similate
or

_db_mttr_advice                ON                   MTTR advisory
_db_mttr_sim_target                                 MTTR simulation targets
_db_mttr_sample_factor         64                   MTTR simulation sampling factor
_db_mttr_partitions            0                    number of partitions for MTTR advisory
_db_mttr_sim_trace_size        256                  MTTR simulation trace size

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_db_mttr_trace_to_alert        FALSE                dump trace entries to alert file
_immediate_commit_propagation  TRUE                 if TRUE, propagate commit SCN immediately
max_commit_propagation_delay   0                    Max age of new snapshot in .01 seconds
_minimum_giga_scn              0                    Minimum SCN to start with in 2^30 units
compatible                     10.2.0.1.0           Database will be completely compatible with this software ve
                                                    rsion

_redo_compatibility_check      FALSE                general and redo/undo compatibility sanity check
_db_block_check_for_debug      FALSE                Check more and dump block before image for debugging
_db_always_check_system_ts     TRUE                 Always perform. block check and checksum for System tablespac
                                                    e

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_log_checkpoint_recovery_check 0                    # redo blocks to verify after checkpoint
_two_pass                      TRUE                 enable two-pass thread recovery
_recovery_verify_writes        FALSE                enable thread recovery write verify
_disable_recovery_read_skip    FALSE                Disable the read optimization during media recovery
_log_archive_security_enabled  TRUE                 log archive security enabled
_log_archive_avoid_memcpy      TRUE                 log archive avoid memcpy
_log_archive_prot_auto_demote  FALSE                log archive protection auto demotion
remote_archive_enable          true                 remote archival enable setting
log_archive_config                                  log archive config parameter
_log_archive_compress_enable   FALSE                Bypass database rules for enabling archivelog compression

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
log_archive_start              FALSE                start archival process on SGA initialization
_real_time_apply_arch_delay    0                    Archival delay with real time apply
_real_time_apply_sim           0                    Simulation value with real time apply
_log_archive_buffers           10                   Number of buffers to allocate for archiving
_log_archive_buffer_size       2048                 Size of each archival buffer in log file blocks
_log_archive_callout                                archival callout
log_archive_dest                                    archival destination text string
log_archive_duplex_dest                             duplex archival destination text string
log_archive_dest_1             location=/zxinbak/ar archival destination #1 text string
                               ch reopen=30


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
log_archive_dest_2                                  archival destination #2 text string
log_archive_dest_3                                  archival destination #3 text string
log_archive_dest_4                                  archival destination #4 text string
log_archive_dest_5                                  archival destination #5 text string
log_archive_dest_6                                  archival destination #6 text string
log_archive_dest_7                                  archival destination #7 text string
log_archive_dest_8                                  archival destination #8 text string
log_archive_dest_9                                  archival destination #9 text string
log_archive_dest_10                                 archival destination #10 text string
log_archive_dest_state_1       enable               archival destination #1 state text string
log_archive_dest_state_2       enable               archival destination #2 state text string

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
log_archive_dest_state_3       enable               archival destination #3 state text string
log_archive_dest_state_4       enable               archival destination #4 state text string
log_archive_dest_state_5       enable               archival destination #5 state text string
log_archive_dest_state_6       enable               archival destination #6 state text string
log_archive_dest_state_7       enable               archival destination #7 state text string
log_archive_dest_state_8       enable               archival destination #8 state text string
log_archive_dest_state_9       enable               archival destination #9 state text string
log_archive_dest_state_10      enable               archival destination #10 state text string
log_archive_max_processes      2                    maximum number of active ARCH processes
_log_archive_net_timeout       0                    maximum network wait time in seconds when SYNC=PARALLEL
_log_archive_delta_sync_wait   0                    iterative sleep time in centiseconds seconds when SYNC=PARAL

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    LEL

log_archive_min_succeed_dest   1                    minimum number of archive destinations that must succeed
standby_archive_dest           ?/dbs/arch           standby database archivelog destination text string
log_archive_trace              0                    Establish archivelog operation tracing level
log_archive_local_first        TRUE                 Establish EXPEDITE attribute default value
log_archive_format             %t_%s_%r.dbf         archival destination format
_max_rfs_connections           0                    maximum number of connections used for remote archival
_lgwr_max_ns_wt                1                    Maximum wait time for lgwr to allow NetServer to progress
_max_arch_lns_wait             120                  Maximum wait by ARCH to allow NetServer to complete archival
_max_lns_shutdown_archival_tim 30                   Maximum time spent by LNS to archive last log during shutdow

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
e                                                   n

_ta_lns_wait_for_arch_log      20                   LNS Wait time for arhcived version of online log
_ns_max_flush_wt               1                    Flush wait time for NetServer to flush oustanding writes
_ns_max_send_delay             15                   Data Loss Time Bound for NetServer
_lgwr_ta_sim_err               0                    Variable to simulate errors lgwr true async
_lgwr_ns_sim_err               0                    Variable to simulate errors lgwrns
_lgwr_ns_nl_min                500                  Variable to simulate network latency or buffer threshold
_lgwr_ns_nl_max                1000                 Variable to simulate network latency or buffer threshold
_arch_corrupted_redo_log       0                    Variable to simulate corruption errors during archivals
_log_archive_network_redo_size 10                   Log archive network redo buffer size used by ARCH

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
fal_client                                          FAL client
fal_server                                          FAL server list
_lgwr_async_io                 FALSE                LGWR Asynchronous IO enabling boolean flag
_lgwr_async_broadcasts         TRUE                 LGWR Asynchronous Broadcasts enabling boolean flag
_lgwr_delay_write              FALSE                LGWR write delay for debugging
log_buffer                     14206976             redo circular buffer size
_log_io_size                   0                    automatically initiate log write if this many redo blocks in
                                                     buffer

_log_event_queues              0                    number of the log writer event queues
log_checkpoint_interval        0                    # redo blocks checkpoint threshold

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
log_checkpoint_timeout         1800                 Maximum time interval between checkpoints in seconds
_log_switch_timeout            0                    Maximum number of seconds redos in the current log could spa
                                                    n

archive_lag_target             0                    Maximum number of seconds of redos the standby could lose
_log_buffers_debug             FALSE                debug redo buffers (slows things down)
_log_buffers_corrupt           FALSE                corrupt redo buffers before write
_log_debug_multi_instance      FALSE                debug redo multi instance code
_log_simultaneous_copies       64                   number of simultaneous copies into redo buffer(# of copy lat
                                                    ches)


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_log_parallelism               1                    Number of log buffer strands
_log_parallelism_max           2                    Maximum number of log buffer strands
_log_parallelism_dynamic       TRUE                 Enable dynamic strands
_log_private_parallelism       FALSE                Number of private log buffer strands for zero-copy redo
_log_private_parallelism_mul   10                   Active sessions multiplier to deduce number of private stran
                                                    ds

_log_private_mul               5                    Private strand multiplier for log space preallocation
_lightweight_hdrs              TRUE                 Lightweight headers for redo
_mirror_redo_buffers           FALSE                Save buffers for debugging redo corruptions
_disable_logging               FALSE                Disable logging

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_fg_sync_sleep_usecs           0                    Log file sync via usleep
_log_file_sync_timeout         10                   Log file sync timeout (centiseconds)
db_files                       200                  max allowable # db files
db_file_multiblock_read_count  16                   db block to be read each IO
_db_file_exec_read_count       16                   multiblock read count for regular clients
_db_file_optimizer_read_count  16                   multiblock read count for regular clients
_db_file_noncontig_mblock_read 11                   number of noncontiguous db blocks to be prefetched
_count

read_only_open_delayed         FALSE                if TRUE delay opening of read only files until first access
cluster_database               FALSE                if TRUE startup in cluster database mode

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
parallel_server                FALSE                if TRUE startup in parallel server mode
parallel_server_instances      1                    number of instances to use for sizing OPS SGA structures
cluster_database_instances     1                    number of instances to use for sizing cluster db SGA structu
                                                    res

db_create_file_dest                                 default database location
db_create_online_log_dest_1                         online log/controlfile destination #1
db_create_online_log_dest_2                         online log/controlfile destination #2
db_create_online_log_dest_3                         online log/controlfile destination #3
db_create_online_log_dest_4                         online log/controlfile destination #4
db_create_online_log_dest_5                         online log/controlfile  destination #5

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
db_recovery_file_dest                               default database recovery file location
db_recovery_file_dest_size     0                    database recovery files size limit
_db_recovery_temporal_file_des                      default database recovery temporal file location
t

standby_file_management        MANUAL               if auto then files are created/dropped automatically on stan
                                                    dby

_hard_protection               FALSE                if TRUE enable H.A.R.D specific format changes
_allow_error_simulation        FALSE                Allow error simulation for testing
_db_file_format_io_buffers     4                    Block formatting I/O buf count

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
gc_files_to_locks                                   mapping between file numbers and global cache locks
_gc_use_cr                     TRUE                 if TRUE, allow CR pins on PI and WRITING buffers
_gc_undo_affinity              TRUE                 if TRUE, enable dynamic undo affinity
_gc_affinity_time              10                   if non zero, enable dynamic object affinity
_gc_affinity_limit             50                   dynamic affinity limit
_gc_affinity_minimum           6000                 dynamic affinity minimum activity per minute
_recovery_asserts              FALSE                if TRUE, enable expensive integrity checks
_gc_integrity_checks           1                    set the integrity check level
_gc_vector_read                TRUE                 if TRUE, vector read current buffers
_gc_element_percent            103                  global cache element percent
_gc_latches                    8                    number of latches per LMS process

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_gc_defer_time                 3                    how long to defer down converts for hot buffers
_kcl_debug                     TRUE                 if TRUE, record le history
_kcl_index_split               TRUE                 if TRUE, reject pings on blocks in middle of a split
_kcl_commit                    TRUE                 if TRUE, call kjbcommit
_fairness_threshold            4                    number of times to CR serve before downgrading lock
_interconnect_checksum         TRUE                 if TRUE, checksum interconnect blocks
_cr_server_log_flush           TRUE                 if TRUE, flush redo log before serving a CR buffer
_ping_level                    3                    fusion ping level
_async_recovery_reads          TRUE                 if TRUE, issue recovery reads asynchronously
_async_recovery_claims         TRUE                 if TRUE, issue recovery claims asynchronously
_avoid_prepare                 TRUE                 if TRUE, do not prepare a buffer when the master is local

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_bwr_for_flushed_pi            TRUE                 if TRUE, generate a BWR for a flushed PI
_send_requests_to_pi           TRUE                 if TRUE, try to send CR requests to PI buffers
_kcl_undo_locks                128                  number of locks per undo segment
_kcl_undo_grouping             32                   grouping for undo block locks
_kcl_conservative_log_flush    FALSE                if TRUE, conservatively log flush before CR serving
_gc_statistics                 TRUE                 if TRUE, kcl statistics are maintained
_gc_check_bscn                 TRUE                 if TRUE, check for stale blocks
_gc_global_lru                 AUTO                 turn global lru off, make it automatic, or turn it on
_gc_dynamic_affinity_locks     TRUE                 if TRUE, get dynamic affinity locks
_gc_undo_affinity_locks        TRUE                 if TRUE, get affinity locks for undo
_gc_tsn_undo_affinity          TRUE                 if TRUE, use TSN undo affinity

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_gc_coalesce_recovery_reads    TRUE                 if TRUE, coalesce recovery reads
_gc_keep_recovery_buffers      TRUE                 if TRUE, make recovery buffers current
_gc_maximum_bids               0                    maximum number of bids which can be prepared
_gc_async_memcpy               FALSE                if TRUE, use async memcpy
_gc_dissolve_undo_affinity     FALSE                if TRUE, dissolve undo affinity after an offline
_gc_initiate_undo_affinity     TRUE                 if TRUE, initiate undo affinity after an online
_adaptive_direct_read          TRUE                 Adaptive Direct Read
_db_block_align_direct_read    TRUE                 Align Direct Reads
_direct_io_skip_cur_slot_on_er TRUE                 Skip current slot on error
ror


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
thread                         0                    Redo thread to mount
_disable_incremental_checkpoin FALSE                Disable incremental checkpoints for thread recovery
ts

_fast_start_instance_recovery_ 0                    instance recovery target time in RAC environment
target

_disable_selftune_checkpointin FALSE                Disable self-tune checkpointing
g

_selftune_checkpointing_lag    300                  Self-tune checkpointing lag the tail of the redo log

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_target_rba_max_lag_percentage 90                   target rba max log lag percentage
_no_recovery_through_resetlogs FALSE                no recovery through this resetlogs operation
fast_start_io_target           0                    Upper bound on recovery reads
fast_start_mttr_target         0                    MTTR target in seconds
_log_blocks_during_backup      TRUE                 log block images when changed during backup
_allow_resetlogs_corruption    FALSE                allow resetlogs even if it will cause corruption
_allow_terminal_recovery_corru FALSE                Finish terminal recovery even if it may cause corruption
ption

_allow_read_only_corruption    FALSE                allow read-only open even if database is corrupt
_recovery_skip_cfseq_check     FALSE                allow media recovery even if controlfile seq check fails

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
log_checkpoints_to_alert       FALSE                log checkpoint begin/end to alert file
recovery_parallelism           0                    number of server processes to use for parallel recovery
_serial_recovery               FALSE                force serial recovery or parallel recovery
_coord_message_buffer          0                    parallel recovery coordinator side extra message buffer size
_multiple_instance_recovery    FALSE                use multiple instances for media recovery
_backup_kgc_bufsz              0                    specifies buffer size to be used for kgc compression
_backup_kgc_type               0                    specifies compression type used for kgc compression
_backup_kgc_niters             0                    specifies number of iterations used for kgc compression
_backup_ksfq_bufsz             0                    size of the ksfq buffer used for backup/restore
_backup_ksfq_bufcnt            0                    number of the ksfq buffers used for backup/restore
_backup_max_gap_size           4294967294           largest gap in an incremental/optimized backup buffer, in by

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    tes

_unused_block_compression      TRUE                 enable unused block compression
_restore_spfile                                     restore spfile to this location
_dummy_instance                FALSE                dummy instance started by RMAN
_rman_io_priority              3                    priority at which rman backup i/o's are done
logmnr_max_persistent_sessions 1                    maximum number of threads to mine
_tts_allow_charset_mismatch    FALSE                allow plugging in a tablespace with an incompatible characte
                                                    r set

_xtts_allow_pre10              FALSE                allow cross platform. for pre10 compatible tablespace

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xtts_set_platform_info        FALSE                set cross platform. info during file header read
_bypass_xplatform_error        FALSE                bypass datafile header cross-platform-compliance errors
_disable_recoverable_recovery  FALSE                Disable the new recoverable recovery mechanism
_recoverable_recovery_batch_pe 50                   Recoverable recovery batch size (percentage of buffer cache)
rcent

_disable_incremental_recovery_ FALSE                Disable incremental recovery checkpoint mechanism
ckpt

_incremental_recovery_ckpt_min 300                  Minimum number of writes for incremental recovery ckpt every
_batch                                               3 sec

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_log_max_optimize_threads      128                  maximum number of threads to which log scan optimization is
                                                    applied

_reduce_sby_log_scan           TRUE                 enable stabdby log scan optimization
_media_recovery_read_batch     128                  media recovery block read batch
_media_recovery_reap_time      3                    media recovery reap time
_bct_public_dba_buffer_size    0                    total size of all public change tracking dba buffers, in byt
                                                    es

_bct_initial_private_dba_buffe 0                    initial number of entries in the private change tracking dba

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
r_size                                               buffers

_bct_bitmaps_per_file          8                    number of bitmaps to store for each datafile
_bct_file_block_size           0                    block size of change tracking file, in bytes
_bct_file_extent_size          0                    extent size of change tracking file, in bytes
_bct_chunk_size                0                    change tracking datafile chunk size, in bytes
_bct_crash_reserve_size        262144               change tracking reserved crash recovery SGA space, in bytes
_bct_buffer_allocation_size    2097152              size of one change tracking buffer allocation, in bytes
_bct_buffer_allocation_max     104857600            maximum size of all change tracking buffer allocations, in b
                                                    ytes


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_bct_buffer_allocation_min_ext 1                    mininum number of extents to allocate per buffer allocation
ents

_bct_fixtab_file                                    change tracking file for fixed tables
_block_change_tracking         TRUE                 change tracking possible
_log_deletion_policy           mandatory            archivelog deletion policy for mandatory/all destination
db_flashback_retention_target  1440                 Maximum Flashback Database log retention time in minutes.
_validate_flashback_database   FALSE                Scan database to validate result of flashback database
_flashback_allow_noarchivelog  FALSE                Allow enabling flashback on noarchivelog database
_verify_flashback_redo         TRUE                 Verify that the redo logs needed for flashback are available
_flashback_verbose_info        FALSE                Print verbose information about flashback database

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_flashback_marker_cache_size   328                  Size of flashback database marker cache
_flashback_marker_cache_enable TRUE                 Enable flashback database marker cache
d

_flashback_logfile_enqueue_tim 600                  flashback logfile enqueue timeout for opens
eout

_flashback_barrier_interval    1800                 Flashback barrier interval in seconds
_flashback_standby_barrier_int 1800                 Flashback standby barrier interval in seconds
erval


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_flashback_fuzzy_barrier       TRUE                 Use flashback fuzzy barrier
_disable_flashback_wait_callba FALSE                Disable flashback wait callback
ck

_minimum_db_flashback_retentio 60                   Minimum flashback retention
n

_flashback_log_size            1000                 Flashback log size
_flashback_log_min_size        100                  Minimum flashback log size
_flashback_copy_latches        10                   Number of flashback copy latches
_flashback_n_log_per_thread    128                  Desired number of flashback logs per flashback thread

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_flashback_max_n_log_per_threa 2048                 Maximum number of flashback logs per flashback thread
d

_flashback_generation_buffer_s 134217728            flashback generation buffer size
ize

_flashback_max_log_size        0                    Maximum flashback log size in bytes (OS limit)
_flashback_log_io_error_behavi 0                    Specify Flashback log I/O error behavior
or

_flashback_hint_barrier_percen 20                   Flashback hint barrier percent

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
t

_percent_flashback_buf_partial 50                   Percent of flashback buffer filled to be considered partial
_full                                               full

_flashback_write_size_qm       4                    Desired flashback write size in quarter MB
_tdb_debug_mode                16                   set debug mode for testing transportable database
dml_locks                      3892                 dml locks - one for each table modified in a transaction
ddl_wait_for_locks             FALSE                Disable NOWAIT DML lock acquisitions
_row_locking                   always               row-locking
_serializable                  FALSE                serializable

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
replication_dependency_trackin TRUE                 tracking dependency for Replication parallel propagation
g

_log_committime_block_cleanout FALSE                Log commit-time block cleanout
_ktc_latches                   0                    number of ktc latches
_prescomm                      FALSE                presume commit of IMU transactions
_recursive_imu_transactions    FALSE                recursive transactions may be IMU
_ktc_debug                     0                    for ktc debug
instance_number                0                    instance number
_allocate_creation_order       FALSE                should files be examined in creation order during allocation
_log_space_errors              TRUE                 should we report space errors to alert log

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_bump_highwater_mark_count     0                    how many blocks should we allocate per free list on advancin
                                                    g HWM

_assm_default                  TRUE                 ASSM default
_enable_hwm_sync               TRUE                 enable HWM synchronization
_hwm_sync_threshold            10                   HWM synchronization threshold in percentage
_enable_check_truncate         TRUE                 enable checking of corruption caused by canceled truncate
_enable_tablespace_alerts      TRUE                 enable tablespace alerts
_disable_temp_tablespace_alert FALSE                disable tablespace alerts for TEMPORARY tablespaces
s


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_disable_undo_tablespace_alert FALSE                disable tablespace alerts for UNDO tablespaces
s

_last_allocation_period        5                    period over which an instance can retain an active level1 bi
                                                    tmap

_inst_locking_period           5                    period an instance can retain a newly acquired level1 bitmap
_allocation_update_interval    3                    interval at which successful search in L1 should be updated
_minimum_blocks_to_shrink      0                    minimum number freeable blocks for shrink to be present
_minimum_extents_to_shrink     1                    minimum number freeable extents for shrink to be present
_ktspsrch_maxsc                32                   maximum segments supported by space search cache

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_max_shrink_obj_stats          0                    number of segments for which shrink stats will be maintained
_check_ts_threshold            0                    check tablespace thresholds
_async_ts_threshold            1                    check tablespace thresholds asynchronously
transactions                   973                  max. number of concurrent active transactions
transactions_per_rollback_segm 5                    number of active transactions per rollback segment
ent

_ktu_latches                   0                    number of KTU latches
rollback_segments                                   undo segment list
_rollback_segment_initial      1                    starting undo segment number
_rollback_segment_count        0                    number of undo segments

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_offline_rollback_segments                          offline undo segment list
_corrupted_rollback_segments                        corrupted undo segment list
_transaction_auditing          TRUE                 transaction auditing records generated in the redo log
_enable_block_level_transactio TRUE                 enable block level recovery
n_recovery

_cleanup_rollback_entries      100                  no. of undo entries to apply per transaction cleanup
undo_management                AUTO                 instance runs in SMU mode if TRUE, else in RBU mode
undo_tablespace                UNDOTBS1             use/switch undo tablespace
_smu_error_simulation_site     0                    site ID of error simulation in KTU code
_smu_error_simulation_type     0                    error type for error simulation in KTU code

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_collect_undo_stats            TRUE                 Collect Statistics v$undostat
_smu_timeouts                                       comma-separated *AND double-quoted* list of AUM timeouts: mq
                                                    l, tur, sess_exprn, qry_exprn, slot_intvl

_smu_debug_mode                0                    - set debug event for testing SMU operations
_undo_debug_mode               0                    debug flag for undo related operations
_verify_undo_quota             FALSE                TRUE - verify consistency of undo quota statistics
_discrete_transactions_enabled FALSE                enable OLTP mode
_in_memory_undo                TRUE                 Make in memory undo for top level transactions
_imu_pools                     3                    in memory undo pools
_row_cr                        TRUE                 enable row cr for all sql

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_undo_autotune                 TRUE                 enable auto tuning of undo_retention
_highthreshold_undoretention   4294967294           high threshold undo_retention in seconds
undo_retention                 900                  undo retention in seconds
_rollback_stopat               0                    stop at -position to step rollback
_smon_internal_errlimit        100                  limit of SMON internal errors
_smon_undo_seg_rescan_limit    10                   limit of SMON continous undo segments re-scan
_transaction_recovery_servers  0                    max number of parallel recovery slaves that may be used
fast_start_parallel_rollback   LOW                  max number of parallel recovery slaves that may be used
_parallel_recovery_stopat      32767                stop at -position- to step through SMON
resumable_timeout              0                    set resumable_timeout
_max_cr_rollbacks              0                    Maximum number of CR  rollbacks per block (LMS)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_disable_txn_alert             0                    disable txn layer alert
_undo_debug_usage              0                    invoke undo usage functions for testing
_db_change_notification_enable TRUE                 enable db change notification
_db_row_overlap_checking       TRUE                 row overlap checking override parameter for data/index block
                                                    s

_db_index_block_checking       TRUE                 index block checking override parameter
db_block_checking              FALSE                header checking and data and index block checking
recyclebin                     on                   recyclebin processing
_alternate_iot_leaf_block_spli TRUE                 enable alternate index-organized table leaf-block split-poin
t_points                                            ts

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_release_insert_threshold      5                    maximum number of unusable blocks to unlink from freelist
_walk_insert_threshold         0                    maximum number of unusable blocks to walk across freelist
_enable_hash_overflow          FALSE                TRUE - enable hash cluster overflow based on SIZE
_kdtgsp_retries                5                    max number of retries in kdtgsp if space returns same block
_minfree_plus                  0                    max percentage of block space + minfree before we mark block
                                                     full

_use_seq_process_cache         TRUE                 whether to use process local seq cache
_reuse_index_loop              5                    number of blocks being examine for index block reuse
_kdis_reject_limit             5                    #block rejections in space reclamation before segment extens

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    ion

_kdis_reject_level             24                   b+tree level to enable rejection limit
_kdis_reject_ops               FALSE                enable rejection heuristic for branch splits
_kdbl_enable_post_allocation   FALSE                allocate dbas after populating data buffers
_ldr_io_size                   262144               size of write IOs used during a load operation
_ignore_desc_in_index          FALSE                ignore DESC in indexes, sort those columns ascending anyhow
_keep_remote_column_size       FALSE                remote column size does not get modified
_row_cache_cursors             20                   number of cached cursors for row cache management
_kgl_multi_instance_lock       TRUE                 whether KGL to support multi-instance locks
_kgl_multi_instance_pin        TRUE                 whether KGL to support multi-instance pins

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_kgl_multi_instance_invalidati TRUE                 whether KGL to support multi-instance invalidations
on

_kgl_latch_count               0                    number of library cache latches
_kgl_heap_size                 1024                 extent size for library cache heap 0
_kgl_fixed_extents             TRUE                 fixed extent size for library cache memory allocations
_kgl_session_cached_objects    10                   maximum length of the KGL object cache lru
_kgl_keep_cache_pct            30                   KGL keep cache minimum threshold
_kgl_keep_cache_retain_pct     20                   KGL keep cache retain threshold
_kgl_bucket_count              9                    index to the bucket count array
_library_cache_advice          TRUE                 whether KGL advice should be turned on

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_kglsim_maxmem_percent         5                    max percentage of shared pool size to be used for KGL advice
_kgl_hash_collision            FALSE                whether KGL hash collision is possible
_kgl_time_to_wait_for_locks    15                   time to wait for locks and pins before timing out
_kgl_large_heap_warning_thresh 52428800             maximum heap size before KGL writes warnings to the alert lo
old                                                 g

_synonym_repoint_tracing       FALSE                whether to trace metadata comparisons for synonym repointing
create_stored_outlines                              create stored outlines for DML statements
_kkdlgon_max_iter              20000                kkdlgon maximum number of iterations
serial_reuse                   disable              reuse the frame. segments
_cursor_cache_frame_bind_memor FALSE                frame. & bind buffer caching

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
y

_cursor_features_enabled       2                    Shared cursor features enabled bits.
_kgx_latches                   512                  # of mutex latches if CAS is not supported.
_kks_use_mutex_pin             TRUE                 Turning on this will make KKS use mutex for cursor pins.
_kgx_spin_count                255                  third spare parameter - integer
_cursor_stats_bucket           15                   Hash table buckets for cursor stats (2^).
_cursor_stats_heap             4                    Heaps/latches for cursor stats.
ldap_directory_access          NONE                 RDBMS's LDAP access option
os_roles                       FALSE                retrieve roles from the operating system
rdbms_server_dn                                     RDBMS's Distinguished Name

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
max_enabled_roles              150                  max number of roles a user can have enabled
remote_os_authent              FALSE                allow non-secure remote clients to use auto-logon accounts
remote_os_roles                FALSE                allow non-secure remote clients to use os roles
O7_DICTIONARY_ACCESSIBILITY    FALSE                Version 7 Dictionary Accessibility Support
_passwordfile_enqueue_timeout  900                  password file enqueue timeout in seconds
remote_login_passwordfile      NONE                 password file usage parameter
license_max_users              0                    maximum number of named users that can be created in the dat
                                                    abase

_dynamic_rls_policies          TRUE                 rls policies are dynamic
_app_ctx_vers                  FALSE                enable app ctx versioning

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_session_context_size          10000                session app context size
audit_sys_operations           FALSE                enable sys auditing
_default_encrypt_alg           0                    default encryption algorithm
_ols_cleanup_task              TRUE                 Clean up unnecessary entries in OLS sessinfo table
global_context_pool_size                            Global Application Context Pool Size in Bytes
db_domain                                           directory part of global database name stored with CREATE DA
                                                    TABASE

global_names                   FALSE                enforce that database links have same name as remote databas
                                                    e


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
distributed_lock_timeout       60                   number of seconds a distributed transaction waits for a lock
_distributed_recovery_connecti 200                  number of seconds RECO holds outbound connections open
on_hold_time

commit_point_strength          1                    Bias this node has toward not preparing in a two-phase commi
                                                    t

instance_name                  zxin                 instance name supported by the instance
service_names                  zxin                 service names supported by the instance
__dg_broker_service_names      zxin_XPT             service names for broker use
dispatchers                                         specifications of dispatchers

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
shared_servers                 0                    number of shared servers to start up
max_shared_servers                                  max number of shared servers
max_dispatchers                                     max number of dispatchers
circuits                                            max number of circuits
shared_server_sessions                              max number of shared server sessions
local_listener                                      local listener
remote_listener                                     remote listener
_pmon_load_constants           300,192,64,3,10,10,0 server load balancing constants (S,P,D,I,L,C,M)
                               ,0

_dispatcher_rate_ttl                                time-to-live for rate statistic (100ths of a second)

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_dispatcher_rate_scale                              scale to display rate statistic (100ths of a second)
_shared_server_spare_param1                         _shared_server_spare_param1
_shared_server_spare_param2                         _shared_server_spare_param2
_shared_server_spare_param3                         _shared_server_spare_param3
_kernel_message_network_driver FALSE                kernel message network driver
_dedicated_server_poll_count   10                   dedicated server poll count
_dedicated_server_post_wait_ca FALSE                dedicated server post/wait call
ll

_dedicated_server_post_wait    FALSE                dedicated server post/wait
_fast_cursor_reexecute         FALSE                use more memory in order to get faster execution

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
cursor_space_for_time          FALSE                use more memory in order to get faster execution
session_cached_cursors         20                   Number of cursors to cache in a session.
_session_kept_cursor_pins      0                    Number of cursors pins to keep in a session
_dump_qbc_tree                 0                    dump top level query parse tree to trace
remote_dependencies_mode       TIMESTAMP            remote-procedure-call dependencies mode parameter
utl_file_dir                   /home/oracle         utl_file accessible directories list
smtp_out_server                                     utl_smtp server and port configuration parameter
_plsql_dump_buffer_events                           conditions upon which the PL/SQL circular buffer is dumped
plsql_v2_compatibility         FALSE                PL/SQL version 2.x compatibility flag
plsql_compiler_flags           INTERPRETED, NON_DEB PL/SQL compiler flags
                               UG

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

plsql_native_library_dir                            plsql native library dir
plsql_native_library_subdir_co 0                    plsql native library number of subdirectories
unt

plsql_warnings                 DISABLE:ALL          PL/SQL compiler warnings settings
plsql_code_type                INTERPRETED          PL/SQL code-type
_plsql_anon_block_code_type    INTERPRETED          PL/SQL anonymous block code-type
plsql_debug                    FALSE                PL/SQL debug
plsql_optimize_level           2                    PL/SQL optimize level
plsql_ccflags                                       PL/SQL ccflags

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_inline_sql_in_plsql           FALSE                inline SQL in PL/SQL
_plsql_native_frame_threshold  4294967294           Allocate PL/SQL native frames on the heap if size exceeds th
                                                    is value

_plsql_nvl_optimize            FALSE                PL/SQL NVL optimize
_plsql_max_stack_size          0                    PL/SQL maximum stack size
permit_92_wrap                 TRUE                 allow old-style. wrap-files in PL/SQL
job_queue_processes            10                   number of job queue slave processes
_job_queue_interval            5                    Wakeup interval in seconds for job queue co-ordinator
parallel_min_percent           0                    minimum percent of threads required for parallel query
_parallel_default_max_instance 1                    default maximum number of instances for parallel query

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
s

_system_trig_enabled           TRUE                 are system triggers enabled
create_bitmap_area_size        8388608              size of create bitmap buffer for bitmap index
bitmap_merge_area_size         1048576              maximum memory allow for BITMAP MERGE
_kkfi_trace                    FALSE                trace expression substitution
cursor_sharing                 EXACT                cursor sharing mode
_adjust_literal_replacement    FALSE                If TRUE, we will adjust the SQL/PLUS output
_kolfuseslf                    FALSE                allow kolf to use slffopen
_session_cached_instantiations 60                   Number of pl/sql instantiations to cache in a session.
_px_trace                      none                 px trace parameter

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xt_trace                      none                 external tables trace parameter
_xt_coverage                   none                 external tables code coverage parameter
_ku_trace                      none                 datapump trace parameter
_optimizer_trace               none                 optimizer trace parameter
parallel_min_servers           0                    minimum parallel query servers per instance
parallel_max_servers           100                  maximum parallel query servers per instance
_parallel_server_idle_time     30000                idle time before parallel query server dies (in 1/100 sec)
_parallel_server_sleep_time    10                   sleep time between dequeue timeouts (in 1/100ths)
_px_send_timeout               300                  IPC message  send timeout value in seconds
_dynamic_stats_threshold       30                   delay threshold (in seconds) between sending statistics mess
                                                    ages

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

parallel_instance_group                             instance group to use for all parallel operations
_parallel_fake_class_pct       0                    fake db-scheduler percent used for testing
_px_load_publish_interval      200                  interval at which LMON will check whether to publish PX load
parallel_execution_message_siz 2152                 message buffer size for parallel execution
e

_parallel_execution_message_al FALSE                Alignment of PX buffers to OS page boundary
ign

_PX_use_large_pool             FALSE                Use Large Pool as source of PX buffers

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_parallel_min_message_pool     1076000              minimum size of shared pool memory to reserve for pq servers
_px_buffer_ttl                 30                   ttl for px mesg buffers in seconds
_tq_dump_period                0                    time period for duping of TQ statistics (s)
_affinity_on                   TRUE                 enable/disable affinity at run time
_enable_default_affinity       0                    to enable default implementation of affinity osds
_dss_cache_flush               FALSE                enable full cache flush for parallel execution
_hash_join_enabled             TRUE                 enable/disable hash join
hash_area_size                 131072               size of in-memory hash work area
_hash_multiblock_io_count      0                    number of blocks hash join will read/write at once
_cursor_db_buffers_pinned      2328                 additional number of buffers a cursor can pin at once
_old_connect_by_enabled        FALSE                enable/disable old connect by

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_table_lookup_prefetch_size    40                   table lookup prefetch vector size
_multi_join_key_table_lookup   TRUE                 TRUE iff multi-join-key table lookup prefetch is enabled
_table_lookup_prefetch_thresh  2                    table lookup prefetch threshold
_adaptive_fetch_enabled        TRUE                 enable/disable adaptive fetch in parallel group by
_query_execution_cache_max_siz 65536                max size of query execution cache
e

_fast_dual_enabled             TRUE                 enable/disable fast dual
_newsort_enabled               TRUE                 controls whether new sorts can be used as system sort
_newsort_type                  0                    specifies options for the new sort algorithm
_newsort_ordered_pct           63                   controls when new sort avoids sorting ordered input

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_fix_control                                        bug fix control parameter
shadow_core_dump               partial              Core Size for Shadow Processes
background_core_dump           partial              Core Size for Background Processes
background_dump_dest           /home/oracle/zxindbf Detached process dump directory
                               /admin/zxin/bdump

user_dump_dest                 /home/oracle/zxindbf User process dump directory
                               /admin/zxin/udump

max_dump_file_size             512M                 Maximum size (blocks) of dump file
core_dump_dest                 /home/oracle/zxindbf Core dump directory

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                               /admin/zxin/cdump

_oradbg_pathname                                    path of oradbg script
_vendor_lib_loc                                     Vendor library search root directory
_disable_sun_rsm               TRUE                 Disable IPC OSD support for Sun RSMAPI
_ipc_test_failover             0                    Test transparent cluster network failover
_ipc_test_mult_nets            0                    simulate multiple cluster networks
_ipc_fail_network              0                    Simulate cluster network failer
audit_file_dest                /home/oracle/zxindbf Directory in which auditing files are to reside
                               /admin/zxin/adump


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
audit_syslog_level                                  Syslog facility and level
object_cache_optimal_size      102400               optimal size of the user session's object cache in bytes
object_cache_max_size_percent  10                   percentage of maximum size over optimal of the user session'
                                                    s object cache

_no_objects                    FALSE                no object features are used
session_max_open_files         10                   maximum number of open files allowed per session
_domain_index_batch_size       2000                 maximum number of rows from one call to domain index fetch r
                                                    outine

_domain_index_dml_batch_size   200                  maximum number of rows for one call to domain index dml rout

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    ines

_nchar_imp_conv                TRUE                 should implicit conversion bewteen clob and nclob be allowed
_insert_enable_hwm_brokered    TRUE                 during parallel inserts high water marks are brokered
open_links                     4                    max # open links per session
open_links_per_instance        4                    max # open links per instance
_all_shared_dblinks                                 treat all dblinks as shared
_close_cached_open_cursors     FALSE                close cursors cached by PL/SQL at each commit
_disable_savepoint_reset       FALSE                disable the fix for bug 1402161
commit_write                                        transaction commit log write behaviour
_init_sql_file                 ?/rdbms/admin/sql.bs File containing SQL statements to execute upon database crea

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                               q                    tion

optimizer_features_enable      10.2.0.5             optimizer plan compatibility parameter
fixed_date                                          fixed SYSDATE value
audit_trail                    NONE                 enable system auditing
sort_area_size                 65536                size of in-memory sort work area
sort_area_retained_size        0                    size of in-memory sort work area retained between fetch call
                                                    s

_sort_multiblock_read_count    2                    multi-block read count for sort
_shrunk_aggs_enabled           TRUE                 enable use of variable sized buffers for non-distinct aggreg

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    ates

_shrunk_aggs_disable_threshold 60                   percentage of exceptions at which to switch to full length a
                                                    ggs

_gby_onekey_enabled            TRUE                 enable use of one comparison of all group by keys
db_name                        zxin                 database name specified in CREATE DATABASE
db_unique_name                 zxin                 Database Unique Name
open_cursors                   500                  max # cursors per session
ifile                                               include file in init.ora
sql_trace                      FALSE                enable SQL trace

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
os_authent_prefix              ops$                 prefix for auto-logon accounts
_sql_connect_capability_table                       SQL Connect Capability Table (testing only)
optimizer_mode                 ALL_ROWS             optimizer mode
_optimizer_mode_force          TRUE                 force setting of optimizer mode for user recursive SQL also
_explain_rewrite_mode          FALSE                allow additional messages to be generated during explain rew
                                                    rite

_query_rewrite_or_error        FALSE                allow query rewrite, if referenced tables are not dataless
_sort_elimination_cost_ratio   0                    cost ratio for sort eimination under first_rows mode
sql92_security                 FALSE                require select privilege for searched update/delete
_sql_connect_capability_overri 0                    SQL Connect Capability Table Override

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
de

blank_trimming                 FALSE                blank trimming semantics parameter
_always_anti_join              CHOOSE               always use this method for anti-join when possible
_partition_view_enabled        TRUE                 enable/disable partitioned views
_always_star_transformation    FALSE                always favor use of star transformation
_b_tree_bitmap_plans           TRUE                 enable the use of bitmap plans for tables w. only B-tree ind
                                                    exes

star_transformation_enabled    FALSE                enable the use of star transformation
_column_elimination_off        FALSE                turn off predicate-only column elimination

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_cpu_to_io                     0                    divisor for converting CPU cost to I/O cost
_optimizer_extended_cursor_sha UDO                  optimizer extended cursor sharing
ring

_optimizer_cost_model          CHOOSE               optimizer cost model
_optimizer_undo_cost_change    10.2.0.5             optimizer undo cost change
_optimizer_system_stats_usage  TRUE                 system statistics usage
_optimizer_cache_stats         FALSE                cost with cache statistics
_new_sort_cost_estimate        TRUE                 enables the use of new cost estimate for sort
_complex_view_merging          TRUE                 enable complex view merging
_simple_view_merging           TRUE                 control simple view merging performed by the optimizer

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_unnest_subquery               TRUE                 enables unnesting of correlated subqueries
_eliminate_common_subexpr      TRUE                 enables elimination of common sub-expressions
_pred_move_around              TRUE                 enables predicate move-around
_convert_set_to_join           FALSE                enables conversion of set operator to join
_px_ual_serial_input           TRUE                 enables new pq for UNION operators
_px_bind_peek_sharing          TRUE                 enables sharing of px cursors that were built using bind pee
                                                    king

_px_minus_intersect            TRUE                 enables pq for minus/interect operators
_remove_aggr_subquery          TRUE                 enables removal of subsumed aggregated subquery
_distinct_view_unnesting       FALSE                enables unnesting of in subquery into distinct view

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_optimizer_push_down_distinct  0                    push down distinct from query block to table
_optimizer_cost_based_transfor LINEAR               enables cost-based query transformation
mation

_optimizer_squ_bottomup        TRUE                 enables unnesting of subquery in a bottom-up manner
_optimizer_cbqt_factor         50                   cost factor for cost-based query transformation
_push_join_predicate           TRUE                 enable pushing join predicate inside a view
_push_join_union_view          TRUE                 enable pushing join predicate inside a union all view
_push_join_union_view2         TRUE                 enable pushing join predicate inside a union view
_fast_full_scan_enabled        TRUE                 enable/disable index fast full scan
_optimizer_skip_scan_enabled   TRUE                 enable/disable index skip scan

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_optimizer_join_sel_sanity_che TRUE                 enable/disable sanity check for multi-column join selectivit
ck                                                  y

_optim_enhance_nnull_detection TRUE                 TRUE to enable index [fast] full scan more often
_idl_conventional_index_mainte TRUE                 enable conventional index maintenance for insert direct load
nance

_enable_cscn_caching           FALSE                enable commit SCN caching for all transactions
_parallel_broadcast_enabled    TRUE                 enable broadcasting of small inputs to hash and sort merge j
                                                    oins


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_px_broadcast_fudge_factor     100                  set the tq broadcasting fudge factor percentage
_px_kxib_tracing               0                    turn on kxib tracing
_px_granule_size               100000               default size of a rowid range granule (in KB)
_px_xtgranule_size             10000                default size of a external table granule (in KB)
_xtbuffer_size                 0                    buffer size in KB needed for populate/query operation
_px_async_getgranule           FALSE                asynchronous get granule in the slave
_px_min_granules_per_slave     13                   minimum number of rowid range granules to generate per slave
_px_max_granules_per_slave     100                  maximum number of rowid range granules to generate per slave
_px_no_stealing                FALSE                prevent parallel granule stealing in shared nothing environm
                                                    ent


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_px_no_granule_sort            FALSE                prevent parallel partition granules to be sorted on size
_px_proc_constrain             TRUE                 reduce parallel_max_servers if greater than (processes - fud
                                                    ge)

parallel_adaptive_multi_user   TRUE                 enable adaptive setting of degree for multiple user streams
parallel_threads_per_cpu       2                    number of parallel execution threads per CPU
parallel_automatic_tuning      FALSE                enable intelligent defaults for parallel execution parameter
                                                    s

_parallel_adaptive_max_users   2                    maximum number of users running with default DOP
_parallel_load_balancing       TRUE                 parallel execution load balanced slave allocation

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_parallel_load_bal_unit        0                    number of threads to allocate per instance
_parallel_slave_acquisition_wa 1                    time(in seconds) to wait before retrying slave acquisition
it

_pdml_slaves_diff_part         TRUE                 slaves start on different partition when doing index maint
_pdml_gim_sampling             5000                 control separation of global index maintenance for PDML
_pdml_gim_staggered            FALSE                slaves start on different index when doing index maint
_px_dynamic_opt                TRUE                 turn off/on restartable qerpx dynamic optimization
_px_dynamic_sample_size        50                   num of samples for restartable qerpx dynamic optimization
_px_rownum_pd                  TRUE                 turn off/on parallel rownum pushdown optimization
_predicate_elimination_enabled TRUE                 allow predicate elimination if set to TRUE

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_groupby_nopushdown_cut_ratio  3                    groupby nopushdown cut ratio
_groupby_orderby_combine       5000                 groupby/orderby don't combine threshold
_temp_tran_block_threshold     100                  number of blocks for a dimension before we temp transform
_temp_tran_cache               TRUE                 determines if temp table is created with cache option
_ordered_semijoin              TRUE                 enable ordered semi-join subquery
_always_semi_join              CHOOSE               always use this method for semi-join when possible
_ordered_nested_loop           TRUE                 enable ordered nested loop costing
_nested_loop_fudge             100                  nested loop fudge
_project_view_columns          TRUE                 enable projecting out unreferenced columns of a view
_no_or_expansion               FALSE                OR expansion during optimization disabled
_optimizer_max_permutations    2000                 optimizer maximum join permutations per query block

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
optimizer_index_cost_adj       100                  optimizer index cost adjustment
optimizer_index_caching        0                    optimizer percent index caching
_system_index_caching          0                    optimizer percent system index caching
_serial_direct_read            FALSE                enable direct read in serial
_disable_datalayer_sampling    FALSE                disable datalayer sampling
_disable_sample_io_optim       FALSE                disable row sampling IO optimization
_sample_rows_per_block         4                    number of rows per block used for sampling IO optimization
_ncmb_readahead_enabled        0                    enable multi-block readahead for an index scan
_ncmb_readahead_tracing        0                    turn on multi-block readahead tracing
_index_prefetch_factor         100                  index prefetching factor
query_rewrite_enabled          TRUE                 allow rewrite of queries using materialized views if enabled

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
query_rewrite_integrity        enforced             perform. rewrite using materialized views with desired integr
                                                    ity

_query_cost_rewrite            TRUE                 perform. the cost based rewrite with materialized views
_query_rewrite_2               TRUE                 perform. query rewrite before&after or only after view mergin
                                                    g

_query_rewrite_1               TRUE                 perform. query rewrite before&after or only before view mergi
                                                    ng

_query_rewrite_fudge           90                   cost based query rewrite with MVs fudge factor

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_query_rewrite_expression      TRUE                 rewrite with cannonical form. for expressions
_query_rewrite_jgmigrate       TRUE                 mv rewrite with jg migration
_query_rewrite_fpc             TRUE                 mv rewrite fresh partition containment
_query_rewrite_drj             TRUE                 mv rewrite and drop redundant joins
_query_rewrite_maxdisjunct     257                  query rewrite max disjuncts
_query_rewrite_vop_cleanup     TRUE                 prune frocol chain before rewrite after view-merging
_mmv_query_rewrite_enabled     TRUE                 allow rewrites with multiple MVs and/or base tables
_bt_mmv_query_rewrite_enabled  TRUE                 allow rewrites with multiple MVs and base tables
_add_stale_mv_to_dependency_li TRUE                 add stale mv to dependency list
st


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_full_pwise_join_enabled       TRUE                 enable full partition-wise join when TRUE
_partial_pwise_join_enabled    TRUE                 enable partial partition-wise join when TRUE
_slave_mapping_enabled         TRUE                 enable slave mapping when TRUE
_slave_mapping_group_size      0                    force the number of slave group in a slave mapper
_local_communication_costing_e TRUE                 enable local communication costing when TRUE
nabled

_local_communication_ratio     50                   set the ratio between global and local communication (0..100
                                                    )

_parallelism_cost_fudge_factor 350                  set the parallelism cost fudge factor

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_left_nested_loops_random      TRUE                 enable random distribution method for left of nestedloops
_improved_row_length_enabled   TRUE                 enable the improvements for computing the average row length
_px_index_sampling             200                  parallel query sampling for index create (100000 = 100%)
_index_join_enabled            TRUE                 enable the use of index joins
_use_nosegment_indexes         FALSE                use nosegment indexes in explain plan
_enable_type_dep_selectivity   TRUE                 enable type dependent selectivity estimates
_sqlexec_progression_cost      1000                 sql execution progression monitoring cost threshold
_improved_outerjoin_card       TRUE                 improved outer-join cardinality calculation
_optimizer_adjust_for_nulls    TRUE                 adjust selectivity for null values
_optimizer_degree              0                    force the optimizer to use the same degree of parallelism
sql_version                    NATIVE               sql language version parameter for compatibility issues

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_use_column_stats_for_function TRUE                 enable the use of column statistics for DDP functions
_subquery_pruning_cost_factor  20                   subquery pruning cost factor
_subquery_pruning_reduction    50                   subquery pruning reduction factor
_subquery_pruning_enabled      TRUE                 enable the use of subquery predicates to perform. pruning
_subquery_pruning_mv_enabled   FALSE                enable the use of subquery predicates with MVs to perform. pr
                                                    uning

_parallel_txn_global           FALSE                enable parallel_txn hint with updates and deletes
_or_expand_nvl_predicate       TRUE                 enable OR expanded plan for NVL/DECODE predicate
_like_with_bind_as_equality    FALSE                treat LIKE predicate with bind as an equality predicate
_table_scan_cost_plus_one      TRUE                 bump estimated full table scan and index ffs cost by one

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_cost_equality_semi_join       TRUE                 enables costing of equality semi-join
_default_non_equality_sel_chec TRUE                 sanity check on default selectivity for like/range predicate
k

_new_initial_join_orders       TRUE                 enable initial join orders based on new ordering heuristics
_oneside_colstat_for_equijoins TRUE                 sanity check on default selectivity for like/range predicate
_column_tracking_level         1                    column usage tracking
_optim_peek_user_binds         TRUE                 enable peeking of user binds
_mv_refresh_selections         TRUE                 create materialized views with selections and fast refresh
_cursor_plan_enabled           TRUE                 enable collection and display of cursor plans
_minimal_stats_aggregation     TRUE                 prohibit stats aggregation at compile/partition maintenance

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    time

_mv_refresh_eut                TRUE                 refresh materialized views using EUT(partition)-based algori
                                                    thm

_mav_refresh_consistent_read   TRUE                 refresh materialized views using consistent read snapshot
_mav_refresh_opt               0                    optimizations during refresh of materialized views
_mav_refresh_unionall_tables   3                    # tables for union all expansion during materialized view re
                                                    fresh

_mv_refresh_delta_fraction     10                   delta mv as fractional percentage of size of mv

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_force_temptables_for_gsets    FALSE                executes concatenation of rollups using temp tables
pga_aggregate_target           8413773824           Target size for the aggregate PGA memory consumed by the ins
                                                    tance

_pga_max_size                  1682739200           Maximum size of the PGA memory for one process
workarea_size_policy           AUTO                 policy used to size SQL working areas (MANUAL/AUTO)
_smm_auto_min_io_size          56                   Minimum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_max_io_size          248                  Maximum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_cost_enabled         TRUE                 if TRUE, use the AUTO size policy cost functions
_smm_control                   0                    provides controls on the memory manager
_smm_trace                     0                    Turn on/off tracing for SQL memory manager

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_smm_min_size                  1024                 minimum work area size in auto mode
_smm_max_size                  821650               maximum work area size in auto mode (serial)
_smm_px_max_size               4108288              maximum work area size in auto mode (global)
_smm_retain_size               0                    work area retain size in SGA for shared server sessions (0 f
                                                    or AUTO)

_smm_bound                     0                    overwrites memory manager automatically computed bound
_smm_advice_log_size           0                    overwrites default size of the PGA advice workarea history l
                                                    og

_smm_advice_enabled            TRUE                 if TRUE, enable v$pga_advice

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_gs_anti_semi_join_allowed     TRUE                 enable anti/semi join for the GS query
_mv_refresh_use_stats          FALSE                pass cardinality hints to refresh queries
_mv_refresh_use_no_merge       TRUE                 use no_merge hint in queries
_optim_new_default_join_sel    TRUE                 improves the way default equijoin selectivity are computed
_optimizer_dyn_smp_blks        32                   number of blocks for optimizer dynamic sampling
optimizer_dynamic_sampling     2                    optimizer dynamic sampling
_pre_rewrite_push_pred         TRUE                 push predicates into views before rewrite
_optimizer_new_join_card_compu TRUE                 compute join cardinality using non-rounded input values
tation

_mav_refresh_double_count_prev FALSE                materialized view MAV refreshes avoid double counting

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
ented

_pct_refresh_double_count_prev TRUE                 materialized view PCT refreshes avoid double counting
ented

_mv_refresh_new_setup_disabled FALSE                materialized view MV refresh new setup disabling
_load_without_compile          NONE                 Load PL/SQL or Database objects without compilation
_precompute_gid_values         TRUE                 precompute gid values and copy them before returning a row
_union_rewrite_for_gs          YES_GSET_MVS         expand queries with GSets into UNIONs for rewrite
_nested_mav_fast_oncommit_enab TRUE                 nested MAV refresh fast on commit allowed
led

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_generalized_pruning_enabled   TRUE                 controls extensions to partition pruning for general predica
                                                    tes

_rowsource_execution_statistic FALSE                if TRUE, Oracle will collect rowsource statistics
s

_rowsource_statistics_sampfreq 128                  frequency of rowsource statistic sampling (must be a power o
                                                    f 2)

_bitmap_or_improvement_enabled TRUE                 controls extensions to partition pruning for general predica

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
                                                    tes

_intrapart_pdml_enabled        TRUE                 Enable intra-partition updates/deletes
_ctas_hwm_brokered_loads       TRUE                 Enable HWM brokered CTAS
_intrapart_pdml_randomlocal_en TRUE                 Enable intra-partition updates/deletes with random local dis
abled                                               t

_optim_adjust_for_part_skews   TRUE                 adjust stats for skews across partitions
_optimizer_compute_index_stats TRUE                 force index stats collection on index creation/rebuild
_optimizer_autostats_job       TRUE                 enable/disable auto stats collection job
_optimizer_push_pred_cost_base TRUE                 use cost-based query transformation for push pred optimizati

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
d                                                   on

_optimizer_filter_pred_pullup  TRUE                 use cost-based flter predicate pull up transformation
_optimizer_connect_by_cost_bas TRUE                 use cost-based transformation for connect by
ed

_optimizer_connect_by_combine_ TRUE                 combine no filtering connect by and start with
sw

_force_datefold_trunc          FALSE                force use of trunc for datefolding rewrite
statistics_level               TYPICAL              statistics level

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_array_update_vector_read_enab FALSE                Enable array update vector read
led

_two_pass_reverse_polish_enabl TRUE                 uses two-pass reverse polish alg. to generate canonical form
ed                                                  s

_expand_aggregates             TRUE                 expand aggregates
_dump_common_subexpressions    FALSE                dump common subexpressions
_spr_use_hash_table            FALSE                use hash table for spreadsheet
_spr_use_AW_AS                 TRUE                 enable AW for hash table in spreadsheet
_dump_connect_by_loop_data     FALSE                dump connect by loop error message into trc file

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_column_compression_factor     0                    Column compression ratio
_dml_monitoring_enabled        TRUE                 enable modification monitoring
_px_slaves_share_cursors       0                    slaves share cursors with QC
_fic_algorithm_set             automatic            Set Frequent Itemset Counting Algorithm
_fic_area_size                 131072               size of Frequent Itemset Counting work area
_fic_max_length                20                   Frequent Itemset Counting Maximum Itemset Length
_fic_min_bmsize                1024                 Frequent Itemset Counting Minimum BITMAP Size
_dtree_area_size               131072               size of Decision Tree Classification work area
_dtree_pruning_enabled         TRUE                 Decision Tree Pruning Enabled
_dtree_compressbmp_enabled     TRUE                 Decision Tree Using Compressed Bitmaps Enabled
_dtree_binning_enabled         TRUE                 Decision Tree Binning Enabled

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_dtree_max_surrogates          1                    maximum number of surrogates
_dtree_bintest_id              0                    Decision Tree Binning Test ID
_right_outer_hash_enable       TRUE                 Right Outer/Semi/Anti Hash Enabled
_optimizer_mjc_enabled         TRUE                 enable merge join cartesian
_optimizer_sortmerge_join_enab TRUE                 enable/disable sort-merge join method
led

_cursor_bind_capture_area_size 400                  maximum size of the cursor bind capture area
_cursor_bind_capture_interval  900                  interval (in seconds) between two bind capture for a cursor
_dump_cursor_heap_sizes        FALSE                dump comp/exec heap sizes to tryace file
_projection_pushdown           TRUE                 projection pushdown

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_projection_pushdown_debug     0                    level for projection pushdown debugging
_px_compilation_debug          0                    debug level for parallel compilation
_px_compilation_trace          0                    tracing level for parallel compilation
_fic_outofmem_candidates       FALSE                Frequent Itemset Counting Out Of Memory Candidates Generatio
                                                    n

_print_refresh_schedule        false                enable dbms_output of materialized view refresh schedule
_optimizer_undo_changes        FALSE                undo changes to query optimizer
_optimizer_percent_parallel    101                  optimizer percent parallel
_optimizer_search_limit        5                    optimizer search limit
skip_unusable_indexes          TRUE                 skip unusable indexes if set to TRUE

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_mv_refresh_costing            rule                 refresh decision based on cost or on rules
_mv_refresh_ana                0                    what percent to analyze after complete/PCT refresh
_cache_stats_monitor           FALSE                if TRUE, enable cache stats monitoring
_stn_trace                     0                    SQL tracing parameter
_sta_control                   0                    SQL Tuning Advisory control parameter
_sql_analyze_enable_auto_txn   FALSE                SQL Analyze Autonomous Transaction control parameter
_ds_enable_auto_txn            FALSE                Dynamic Sampling Service Autonomous Transaction control para
                                                    meter

_sql_analyze_parse_model       2                    SQL Analyze Parse Model control parameter
_ds_parse_model                2                    Dynamic Sampling Service Parse Model control parameter

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_ds_iocount_iosize             6553664              Dynamic Sampling Service defaults: #IOs and IO Size
_mv_refsched_timeincr          300000               proportionality constant for dop vs. time in MV refresh
_spr_push_pred_refspr          TRUE                 push predicates through reference spreadsheet
_optimizer_block_size          8192                 standard block size used by optimizer
_spr_max_rules                 10000                maximum number of rules in sql spreadsheet
_idxrb_rowincr                 100000000            proportionality constant for dop vs. rows in index rebuild
_hj_bit_filter_threshold       50                   hash-join bit filtering threshold (0 always enabled)
_optimizer_save_stats          TRUE                 enable/disable saving old versions of optimizer stats
_optimizer_cost_filter_pred    FALSE                enables  costing of filter predicates in IO cost model
_optimizer_correct_sq_selectiv TRUE                 force correct computation of subquery selectivity
ity

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_allow_commutativity           TRUE                 allow for commutativity of +, * when comparing expressions
_mv_refresh_rebuild_percentage 10                   minimum percentage change required in MV to force an index r
                                                    ebuild

_qa_control                    0                    Oracle internal parameter to control QA
_qa_lrg_type                   0                    Oracle internal parameter to specify QA lrg type
_mv_refresh_force_parallel_que 0                    force materialized view refreshes to use parallel query
ry

_enable_fast_ref_after_mv_tbs  FALSE                enable fast refresh after move tablespace

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_optim_dict_stats_at_db_cr_upg TRUE                 enable/disable dictionary stats gathering at db create/upgra
                                                    de

_optimizer_dim_subq_join_sel   TRUE                 use join selectivity in choosing star transformation dimensi
                                                    ons

_optimizer_disable_strans_sani 0                    disable star transformation sanity checks
ty_checks

_allow_level_without_connect_b FALSE                allow level without connect by
y

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_optimizer_ignore_hints        FALSE                enables the embedded hints to be ignored
_optimizer_random_plan         0                    optimizer seed value for random plans
_optimizer_ceil_cost           TRUE                 CEIL cost in CBO
_delay_index_maintain          TRUE                 delays index maintenance until after MV is refreshed
_query_rewrite_setopgrw_enable TRUE                 perform. general rewrite using set operator summaries
_cursor_plan_hash_version      1                    version of cursor plan hash value
_disable_function_based_index  FALSE                disable function-based index matching
_optimizer_invalidation_period 18000                time window for invalidation of cursors of analyzed objects
_px_net_msg_cost               10000                CPU cost to send a PX message over the internconnect
_px_loc_msg_cost               1000                 CPU cost to send a PX message via shared memory

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_smm_freeable_retain           5120                 value in KB of the instance freeable PGA memory to retain
_cursor_plan_unparse_enabled   TRUE                 enables/disables using unparse to build projection/predicate
                                                    s

_kill_java_threads_on_eoc      FALSE                Kill Java threads and do sessionspace migration at end of ca
                                                    ll

_optimizer_join_order_control  3                    controls the optimizer join order search algorithm
_px_nss_planb                  TRUE                 enables or disables NSS Plan B reparse with outline
_bloom_filter_enabled          TRUE                 enables or disables bloom filter
_bloom_filter_debug            0                    debug level for bloom filtering

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_enable_refresh_schedule       TRUE                 enable or disable MV refresh scheduling (revert to 9.2 behav
                                                    ior)

_optimizer_cartesian_enabled   TRUE                 optimizer cartesian join enabled
_optimizer_starplan_enabled    TRUE                 optimizer star plan enabled
_optimizer_join_elimination_en TRUE                 optimizer join elimination enabled
abled

_gby_hash_aggregation_enabled  TRUE                 enable group-by and aggregation using hash scheme
_extended_pruning_enabled      TRUE                 do runtime pruning in iterator if set to TRUE
_globalindex_pnum_filter_enabl TRUE                 enables filter for global index with partition extended synt

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
ed                                                  ax

_sql_model_unfold_forloops     RUN_TIME             specifies compile-time unfolding of sql model forloops
_enable_dml_lock_escalation    TRUE                 enable dml lock escalation against partitioned tables if TRU
                                                    E

_plsql_cache_enable            TRUE                 PL/SQL Function Cache Enabled
_disable_fast_aggregation      FALSE                fast aggregation
_disable_adaptive_shrunk_aggre FALSE                adaptive shrunk aggregation
gation


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_plsql_minimum_cache_hit_perce 20                   plsql minimum cache hit percentage required to keep caching
nt                                                  active

_plan_outline_data             TRUE                 explain plan outline data enabled
_outline_bitmap_tree           TRUE                 BITMAP_TREE hint enabled in outline
_drop_table_optimization_enabl TRUE                 reduce SGA memory use during drop of a partitioned table
ed

_very_large_partitioned_table  1024                 very_large_partitioned_table
_drop_table_granule            256                  drop_table_granule
_xpl_trace                     0                    Explain Plan tracing parameter

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_dm_max_shared_pool_pct        1                    max percentage of the shared pool to use for a mining model
_optimizer_multiple_cenv                            generate and run plans using several compilation environment
                                                    s

_kql_subheap_trace             0                    tracing level for library cache subheap level pins
_optimizer_cost_hjsmj_multimat TRUE                 add cost of generating result set when #rows per key > 1
ch

_optimizer_transitivity_retain TRUE                 retain equi-join pred upon transitive equality pred generati
                                                    on


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
optimizer_secure_view_merging  TRUE                 optimizer secure view merging and predicate pushdown/movearo
                                                    und

_px_pwg_enabled                TRUE                 parallel partition wise group by enabled
_sql_hash_debug                0                    Hash value of the SQL statement to debug
_mv_rolling_inv                FALSE                create/alter mv uses rolling cursor invalidation instead of
                                                    immediate

_smm_isort_cap                 102400               maximum work area for insertion sort(v1)
_optimizer_cbqt_no_size_restri TRUE                 disable cost based transformation query size restriction
ction

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_windowfunc_optimization_setti 0                    settings for window function optimizations
ngs

_truncate_optimization_enabled TRUE                 do truncate optimization if set to TRUE
_optimizer_enhanced_filter_pus TRUE                 push filters before trying cost-based query transformation
h

_compilation_call_heap_extent_ 16384                Size of the compilation call heaps extents
size


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xpl_peeked_binds_log_size     8192                 maximum bytes for logging peeked bind values for V$SQL_PLAN
                                                    (0 = OFF)

_rowsrc_trace_level            0                    Row source tree tracing level
_optimizer_rownum_pred_based_f TRUE                 enable the use of first K rows due to rownum predicate
kr

_optimizer_better_inlist_costi ALL                  enable improved costing of index access using in-list(s)
ng

_optimizer_self_induced_cache_ FALSE                account for self-induced caching

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
cost

_optimizer_min_cache_blocks    10                   set minimum cached blocks
_enable_exchange_validation_us TRUE                 use check constraints on the table for validation
ing_check

_optimizer_or_expansion        DEPTH                control or expansion approach used
_optimizer_outer_to_anti_enabl TRUE                 Enable transformation of outer-join to anti-join if possible
ed

_optimizer_order_by_eliminatio TRUE                 Eliminates order bys from views before query transformation

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
n_enabled

_optimizer_star_tran_in_with_c TRUE                 enable/disable star transformation in with clause queries
lause

_selfjoin_mv_duplicates        TRUE                 control rewrite self-join algorithm
_dimension_skip_null           TRUE                 control dimension skip when null feature
_force_rewrite_enable          FALSE                control new query rewrite features
_optimizer_complex_pred_select TRUE                 enable selectivity estimation for builtin functions
ivity


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_build_deferred_mv_skipping_mv FALSE                DEFERRED MV creation skipping MV log setup update
log_update

_row_shipping_threshold        80                   row shipping column selection threshold
_row_shipping_explain          FALSE                enable row shipping explain plan support
_optimizer_skip_scan_guess     FALSE                consider index skip scan for predicates with guessed selecti
                                                    vity

_enable_row_shipping           FALSE                use the row shipping optimization for wide table selects
_optimizer_rownum_bind_default 10                   Default value to use for rownum bind
_first_k_rows_dynamic_proratio TRUE                 enable the use of dynamic proration of join cardinalities

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
n

_kks_free_cursor_stat_pct      10                   percentage of cursor stats buckets to scan on each load, in
                                                    1/10th of a percent

_cvw_enable_weak_checking      TRUE                 enable weak view checking
_optimizer_native_full_outer_j off                  execute full outer join using native implementaion
oin

_optimizer_star_trans_min_cost 0                    optimizer star transformation minimum cost
_optimizer_star_trans_min_rati 0                    optimizer star transformation minimum ratio

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
o

_optimizer_fkr_index_cost_bias 10                   Optimizer index bias over FTS/IFFS under first K rows mode
_optimizer_use_subheap         TRUE                 Enables physical optimizer subheap
_optimizer_or_expansion_subhea TRUE                 Use subheap for optimizer or-expansion
p

_optimizer_sortmerge_join_ineq TRUE                 enable/disable sort-merge join using inequality predicates
uality

_optimizer_use_histograms      TRUE                 Controls whether to use histograms

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_optimizer_enable_density_impr FALSE                use improved density computation for selectivity estimation
ovements

_insert_ctas_dependency        FALSE                determines if ctas cursors insert a dependency on the base t
                                                    able

_mv_generalized_oj_refresh_opt TRUE                 enable/disable new algorithm for MJV with generalized outer
                                                    joins

_with_subquery                 OPTIMIZER            WITH subquery transformation
_create_table_in_any_cluster   FALSE                allow creation of table in a cluster not owned by the user

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_block_sample_readahead_prob_t 10                   controls readahead value during block sampling
hreshold

_add_trim_for_nlssort          TRUE                 add trimming for fixed char semantics
_optimizer_connect_by_cb_whr_o FALSE                use cost-based transformation for whr clause in connect by
nly

_dml_batch_error_limit         0                    number or error handles allocated for DML in batch mode
_tsm_connect_string                                 TSM test connect string
_tsm_disable_auto_cleanup      1                    Disable TSM auto cleanup actions
_enable_nativenet_tcpip        FALSE                Enable skgxp driver usage for native net

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_close_deq_by_cond_curs        FALSE                Close Dequeue By Condition Cursors
_deq_maxwait_time              0                    Change wait times between dequeue calls
aq_tm_processes                0                    number of AQ Time Managers to start
_aq_tm_scanlimit               0                    scan limit for Time Managers to clean up IOT
_bufq_stop_flow_control        FALSE                Stop enforcing flow control for buffered queues
_capture_publisher_flow_contro 0                    Flow control threshold for capture publishers
l_threshold

_buffered_publisher_flow_contr 0                    Flow control threshold for buffered publishers except captur
ol_threshold                                        e


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_bufq_flow_control_thrsh       0                    flow control threshold value
_bufq_max_msg_sz               0                    maximum size of the message allowed in memory
_buffered_message_spill_age    300                  Buffered message spill age
hs_autoregister                TRUE                 enable automatic server DD updates in HS agent self-registra
                                                    tion

dg_broker_start                FALSE                start Data Guard broker framework (DMON process)
drs_start                      FALSE                start DG Broker monitor (DMON process)
dg_broker_config_file1         /home/oracle/oracle1 data guard broker configuration file #1
                               0g/dbs/dr1zxin.dat


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
dg_broker_config_file2         /home/oracle/oracle1 data guard broker configuration file #2
                               0g/dbs/dr2zxin.dat

_olapi_history_retention       FALSE                enable olapi history retention
_olapi_session_history         300                  enable olapi session history collection
_olapi_session_history_retenti FALSE                enable olapi session history retention
on

_olapi_iface_object_history    1000                 enable olapi interface object history collection
_olapi_iface_object_history_re FALSE                enable olapi interface object history retention
tention

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_olapi_interface_operation_his 1000                 enable olapi interface operation history collection
tory

_olapi_iface_operation_history FALSE                enable olapi interface operation history retention
_retention

_olapi_memory_operation_histor 1000                 enable olapi memory alloc/free history collection
y

_olapi_memory_operation_histor FALSE                enable olapi memory operation history retention

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
y_retention

_olapi_memory_operation_histor 0                    enable olapi memory alloc/free history collection pausing
y_pause_at_seqno

olap_page_pool_size            0                    size of the olap page pool in bytes
_olap_continuous_trace_file    FALSE                Specify TRUE to enable continuous OLAP tracing - otherwise o
                                                    nly exceptional events will be logged

_olap_table_function_statistic FALSE                Specify TRUE to output OLAP table function timed statistics
s                                                   trace

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_olap_parallel_update_threshol 1000                 OLAP parallel update threshold in pages
d

_olap_parallel_update_small_th 1000                 OLAP parallel update threshold for number of small pagespace
reshold                                             s

_olap_parallel_update_small_gr 400                  OLAP parallel update pagespace by group
oup

_olap_aggregate_buffer_size    1048576              OLAP Aggregate max buffer size

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_olap_aggregate_min_buffer_siz 1024                 OLAP Aggregate min buffer size
e

_olap_aggregate_work_per_threa 1024                 OLAP Aggregate max work parents
d

_olap_aggregate_min_thread_sta 64                   OLAP Aggregate minimum cardinality of dimensions for thread
tus

_olap_aggregate_statlen_thresh 1024                 OLAP Aggregate status array usage threshold
_olap_aggregate_worklist_max   5000                 OLAP Aggregate max worklists generated at once

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_olap_aggregate_max_thread_tup 5000                 OLAP Aggregate max thread tuples creation
les

_olap_aggregate_store_probabil 100                  OLAP Aggregate function storeback probability
ity

_olap_aggregate_function_merge 529                  OLAP Aggregate function merge threshold
_threshold

_olap_aggregate_function_cache TRUE                 OLAP Aggregate function cache enabler
_enabled

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_olap_aggregate_multipath_hier FALSE                OLAP Aggregate Multi-path Hierarhies enabled
_olap_aggregate_flags          0                    OLAP Aggregate debug flags
_olap_allocate_errorlog_header Dim      Source   Ba OLAP Allocate Errorlog Header format
                               sis
                               %-8d %-8s %-8b Descr
                               iption
                               -------- -------- --
                               ------ -----------

_olap_allocate_errorlog_format %8p %8y %8z %e (%n)  OLAP Allocate Errorlog Format

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_olap_poutlog_echo_to_eventlog FALSE                OLAP POutLog copy output to event log (tracefile)
_olap_dbgoutfile_echo_to_event FALSE                OLAP DbgOutfile copy output to event log (tracefile)
log

_olap_eif_export_lob_size      2147483647           OLAP EIF Export BLOB size
_olap_sort_buffer_size         262144               OLAP Sort Buffer Size
_olap_sesscache_enabled        TRUE                 OLAP Session Cache knob
_olap_object_hash_class        2                    OLAP Object Hash Table Class
_olap_dimension_corehash_max   10000                OLAP Dimension In-Core Hash Table Maximum Size
_olap_dimension_corehash_class 1                    OLAP Dimension In-Core Hash Table Class
_olap_page_pool_low            262144               OLAP Page Pool Low Watermark

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_olap_page_pool_hi             50                   OLAP Page Pool High Watermark
_olap_page_pool_expand_rate    20                   OLAP Page Pool Expand Rate
_olap_page_pool_shrink_rate    50                   OLAP Page Pool Shrink Rate
_olap_page_pool_hit_target     100                  OLAP Page Pool Hit Target
_olap_page_pool_pressure       90                   OLAP Page Pool Pressure Threshold
_olap_statbool_threshold       8100                 OLAP Status Boolean CBM threshold
_olap_statbool_corebits        20000000             OLAP Status Boolean max incore bits
_olap_lmgen_dim_size           100                  Limitmap generator dimension column size
_olap_lmgen_meas_size          1000                 Limitmap generator measure column size
_olap_wrap_errors              FALSE                Wrap error messages to OLAP outfile
_xsolapi_fetch_type            PARTIAL              OLAP API fetch type

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xsolapi_dimension_group_creat OVERFETCH            OLAP API symmetric overfetch
ion

_xsolapi_sql_auto_measure_hint TRUE                 OLAP API enable automatic measure hints
s

_xsolapi_sql_auto_dimension_hi FALSE                OLAP API enable automatic dimension hints
nts

_xsolapi_sql_hints                                  OLAP API generic hints
_xsolapi_sql_measure_hints                          OLAP API measure hints

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xsolapi_sql_dimension_hints                        OLAP API dimension hints
_xsolapi_sql_top_measure_hints                      OLAP API top measure hints
_xsolapi_sql_top_dimension_hin                      OLAP API top dimension hints
ts

_xsolapi_sql_all_non_base_hint                      OLAP API non-base hints
s

_xsolapi_sql_all_multi_join_no                      OLAP API multi-join non-base hints
n_base_hints


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xsolapi_densify_cubes         TABULAR              OLAP API cube densification
_xsolapi_sql_optimize          TRUE                 OLAP API enable optimization
_xsolapi_sql_remove_columns    TRUE                 OLAP API enable remove unused columns optimizations
_xsolapi_sql_symmetric_predica TRUE                 OLAP API enable symmetric predicate for dimension groups
te

_xsolapi_sql_use_bind_variable TRUE                 OLAP API enable bind variables optimization
s

_xsolapi_sql_prepare_stmt_cach 16                   OLAP API prepare statement cache size
e_size

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_xsolapi_sql_result_set_cache_ 32                   OLAP API result set cache size
size

_xsolapi_sql_minus_threshold   1000                 OLAP API SQL MINUS threshold
_xsolapi_debug_output                               OLAP API debug output disposition
_xsolapi_materialize_sources   TRUE                 OLAP API Enable source materialization
_xsolapi_load_at_process_start NEVER                When to load OLAP API library at server process start
_xsolapi_auto_materialization_ PRED_AND_RC          OLAP API behavior. for auto materialization
type


NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xsolapi_auto_materialization_ 20                   OLAP API lower bound for auto materialization.
bound

_xsolapi_materialization_rowca 1                    OLAP API min number of rows required to use rowcache in quer
che_min_rows_for_use                                y materialization

_xsolapi_source_trace          FALSE                OLAP API output Source definitions to trace file
_xsolapi_metadata_reader_mode  ALL                  OLAP API metadata reader mode
_xsolapi_odbo_mode             FALSE                OLAP API uses ODBO mode?
_xsolapi_set_nls               TRUE                 OLAP API sets NLS?
_xsolapi_stringify_order_level FALSE                OLAP API stringifies order levels?

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
s

_xsolapi_suppression_chunk_siz 4000                 OLAP API suppression chunk size
e

_xsolapi_suppression_aw_mask_t 1000                 OLAP API suppression AW mask threshold
hreshold

_xsolapi_share_executors       TRUE                 OLAP API share executors?
_xsolapi_hierarchy_value_type  unique               OLAP API hierarchy value type
_xsolapi_use_models            TRUE                 OLAP API uses models?

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_xsolapi_use_olap_dml          TRUE                 OLAP API uses OLAP DML?
_xsolapi_use_olap_dml_for_rank FALSE                OLAP API uses OLAP DML for rank?
_xsolapi_remove_columns_for_ma TRUE                 OLAP API removes columns for materialization?
terialization

_xsolapi_precompute_subquery   TRUE                 OLAP API precomputes subqueries?
_xsolapi_optimize_suppression  TRUE                 OLAP API optimizes suppressions?
_xsolapi_generate_with_clause  FALSE                OLAP API generates WITH clause?
_xsolapi_sql_enable_aw_join    TRUE                 OLAP API enables AW join?
_xsolapi_sql_enable_aw_qdr_mer TRUE                 OLAP API enables AW QDR merge?
ge

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_asm_instlock_quota            0                    ASM Instance Lock Quota
asm_diskstring                                      disk set locations for discovery
_asm_disk_repair_time          14400                seconds to wait before dropping a failing disk
_kffmap_hash_size              1024                 size of kffmap_hash table
_kffmop_hash_size              2048                 size of kffmop_hash table
asm_diskgroups                                      disk groups to mount automatically
asm_power_limit                1                    number of processes for disk rebalancing
_disable_rebalance_space_check FALSE                disable space usage checks for storage reconfiguration
_asm_ausize                    1048576              allocation unit size
_asm_blksize                   4096                 metadata block size

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_asm_acd_chunks                1                    initial ACD chunks created
_asm_libraries                 ufs                  library search order for discovery
_asm_maxio                     1048576              Maximum size of individual I/O request
_asm_allow_only_raw_disks      TRUE                 Discovery only raw devices
_asm_fob_tac_frequency         3                    Timeout frequency for FOB cleanup
_asmlib_test                   0                    Osmlib test event
_asm_allow_resilver_corruption FALSE                Enable disk resilvering for external redundancy
_asmsid                        asm                  ASM instance id
_asm_wait_time                 18                   Max/imum time to wait before asmb exits
_asm_skip_resize_check         FALSE                skip the checking of the clients for s/w compatibility for r
                                                    esize

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

_asm_direct_con_expire_time    120                  Expire time for idle direct connection to ASM instance
_asm_stripewidth               8                    ASM file stripe width
_asm_stripesize                131072               ASM file stripe size
_asm_droptimeout               60                   timeout before offlined disks get dropped (in 3s ticks)
_asm_emulmax                   10000                max number of concurrent disks to emulate I/O errors
_asm_emultimeout               0                    timeout before emulation begins (in 3s ticks)
_asm_kfdpevent                 0                    KFDP event
_alert_expiration              604800               seconds before an alert message is moved to exception queue
_alert_message_cleanup         1                    Enable Alert Message Cleanup
_alert_message_purge           1                    Enable Alert Message Purge

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_alert_post_background         1                    Enable Background Alert Posting
_swrf_test_action              0                    test action parameter for SWRF
_sysaux_test_param             1                    test parameter for SYSAUX
_swrf_mmon_flush               TRUE                 Enable/disable SWRF MMON FLushing
_awr_corrupt_mode              FALSE                AWR Corrupt Mode
_awr_restrict_mode             FALSE                AWR Restrict Mode
_swrf_mmon_metrics             TRUE                 Enable/disable SWRF MMON Metrics Collection
_swrf_metric_frequent_mode     FALSE                Enable/disable SWRF Metric Frequent Mode Collection
_awr_flush_threshold_metrics   FALSE                Enable/Disable Flushing AWR Workload Metrics
_awr_flush_workload_metrics    FALSE                Enable/Disable Flushing AWR Workload Metrics
_awr_disabled_flush_tables                          Disable flushing of specified AWR tables

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_swrf_on_disk_enabled          TRUE                 Parameter to enable/disable SWRF
_swrf_mmon_dbfus               TRUE                 Enable/disable SWRF MMON DB Feature Usage
_awr_mmon_cpuusage             TRUE                 Enable/disable AWR MMON CPU Usage Tracking
_swrf_test_dbfus               FALSE                Enable/disable DB Feature Usage Testing
_mwin_schedule                 TRUE                 Enable/disable Maintenance Window Schedules
_awr_sql_child_limit           200                  Setting for AWR SQL Child Limit
_awr_mmon_deep_purge_enabled   FALSE                Enable/disable AWR deep purge
_awr_mmon_deep_purge_interval  7                    Set interval for deep purge of AWR contents
_awr_mmon_deep_purge_extent    7                    Set extent of rows to check each deep purge run
_awr_mmon_deep_purge_numrows   5000                 Set max number of rows per table to delete each deep purge r
                                                    un

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------

sqltune_category               DEFAULT              Category qualifier for applying hintsets
_sqltune_category_parsed       DEFAULT              Parsed category qualifier for applying hintsets
_ash_sampling_interval         1000                 Time interval between two successive Active Session samples
                                                    in millisecs

_ash_size                      1048618              To set the size of the in-memory Active Session History buff
                                                    ers

_ash_enable                    TRUE                 To enable or disable Active Session sampling and flushing
_ash_disk_write_enable         TRUE                 To enable or disable Active Session History flushing

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_ash_disk_filter_ratio         10                   Ratio of the number of in-memory samples to the number of sa
                                                    mples actually written to disk

_ash_eflush_trigger            66                   The percentage above which if the in-memory ASH is full the
                                                    emergency flusher will be triggered

_ash_sample_all                FALSE                To enable or disable sampling every connected session includ
                                                    ing ones waiting for idle waits

_ash_dummy_test_param          0                    Oracle internal dummy ASH parameter used ONLY for testing!
_threshold_alerts_enable       1                    if 1, issue threshold-based alerts

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_enable_default_undo_threshold TRUE                 Enable Default Tablespace Utilization Threshold for TEMPORAR
                                                    Y Tablespaces

_enable_default_temp_threshold TRUE                 Enable Default Tablespace Utilization Threshold for UNDO Tab
                                                    lespaces

_addm_auto_enable              TRUE                 governs whether ADDM gets run automatically after every AWR
                                                    snapshot

_addm_version_check            TRUE                 governs whether ADDM checks the input AWR snapshot version
_addm_skiprules                                     comma-separated list of ADDM nodes to skip

NAME                           VALUE                DESCRIB
------------------------------ -------------------- ------------------------------------------------------------
_wcr_control                   0                    Oracle internal test WCR parameter used ONLY for testing!
pre_11g_enable_capture         FALSE                To enable capture of DB Replay
_capture_buffer_size           65536                To set the size of the PGA I/O recording buffers

1620 rows selected.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27573546/viewspace-740773/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/27573546/viewspace-740773/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值