Validation of Sort Sizes in an Oracle10g Database


Undocumented Initialization Parameters



Download 3.53 Mb.
Page4/17
Date28.05.2018
Size3.53 Mb.
#50899
1   2   3   4   5   6   7   8   9   ...   17

Undocumented Initialization Parameters


In the interest of full disclosure, here is the complete list of undocumented parameters at the start of the test.

Mon Sep 05 page 1

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_4031_dump_bitvec bitvec to specify 20479 20479

dumps prior to 4031

error

_4031_dump_interval Dump 4031 error once 300 300



for each n-second

interval

_4031_max_dumps Maximum number of 100 100

4031 dumps for this

process

_4031_sga_dump_interval Dump 4031 SGA 3600 3600

heapdump error once

for each n-second

interval

_4031_sga_max_dumps Maximum number of 10 10

SGA heapdumps

_NUMA_instance_mapping Set of nodes that Not specified Not specified

this instance should

run on


_NUMA_pool_size aggregate size in Not specified Not specified

bytes of NUMA pool

_PX_use_large_pool Use Large Pool as FALSE FALSE

source of PX buffers

__db_cache_size Actual size of 717225984 717225984

DEFAULT buffer pool

for standard block

size buffers

__java_pool_size Actual size in bytes 8388608 8388608

of java pool

__large_pool_size Actual size in bytes 4194304 4194304

of large pool

__shared_pool_size Actual size in bytes 234881024 234881024

of shared pool

_abort_recovery_on_join if TRUE, abort FALSE FALSE

recovery on join

reconfigurations

_active_standby_fast_reconfiguration if TRUE optimize dlm TRUE TRUE

reconfiguration for

Mon Sep 05 page 2

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

active/standby OPS

_adaptive_direct_read Adaptive Direct Read TRUE TRUE

_adaptive_fetch_enabled enable/disable TRUE TRUE

adaptive fetch in

parallel group by

_add_stale_mv_to_dependency_list add stale mv to TRUE TRUE

dependency list

_addm_auto_enable governs whether ADDM TRUE TRUE

gets run

automatically after

every AWR snapshot

_addm_skiprules comma-separated list

of ADDM nodes to

skip


_affinity_on enable/disable TRUE TRUE

affinity at run time

_aiowait_timeouts Number of aiowait 100 100

timeouts before

error is reported

_alert_expiration seconds before an 604800 604800

alert message is

moved to exception

queue

_all_shared_dblinks treat all dblinks as



shared

_allocate_creation_order should files be FALSE FALSE

examined in creation

order during

allocation

_allocation_update_interval interval at which 3 3

successful search in

L1 should be updated

_allow_commutativity allow for TRUE TRUE

commutativity of +,

* when comparing

expressions

_allow_error_simulation Allow error FALSE FALSE

simulation for

Mon Sep 05 page 3

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

testing

_allow_level_without_connect_by allow level without FALSE FALSE

connect by

_allow_read_only_corruption allow read-only open FALSE FALSE

even if database is

corrupt


_allow_resetlogs_corruption allow resetlogs even FALSE FALSE

if it will cause

corruption

_allow_terminal_recovery_corruption Finish terminal FALSE FALSE

recovery even if it

may cause corruption

_always_anti_join always use this CHOOSE CHOOSE

method for anti-join

when possible

_always_semi_join always use this CHOOSE CHOOSE

method for semi-join

when possible

_always_star_transformation always favor use of FALSE FALSE

star transformation

_app_ctx_vers enable app ctx FALSE FALSE

versioning

_aq_tm_scanlimit scan limit for Time 0 0

Managers to clean up

IOT

_arch_io_slaves ARCH I/O slaves 0 0



_array_update_vector_read_enabled Enable array update FALSE FALSE

vector read

_ash_disk_filter_ratio Ratio of the number 10 10

of in-memory samples

to the number of

samples actually

written to disk

_ash_disk_write_enable To enable or disable TRUE TRUE

Active Session

History flushing

_ash_dummy_test_param Oracle internal 0 0

Mon Sep 05 page 4

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

dummy ASH parameter

used ONLY for

testing!

_ash_eflush_trigger The percentage above 66 66

which if the

in-memory ASH is

full the emergency

flusher will be

triggered

_ash_enable To enable or disable TRUE TRUE

Active Session

sampling and

flushing

_ash_sample_all To enable or disable FALSE FALSE

sampling every

connected session

including ones

waiting for idle

waits

_ash_sampling_interval Time interval 1000 1000



between two

successive Active

Session samples in

millisecs

_ash_size To set the size of 1048618 1048618

the in-memory Active

Session History

buffers


_asm_acd_chunks initial ACD chunks 1 1

created


_asm_allow_only_raw_disks Discovery only raw TRUE TRUE

devices


_asm_ausize allocation unit size 1048576 1048576

_asm_blksize metadata block size 4096 4096

_asm_disk_repair_time seconds to wait 14400 14400

before dropping a

failing disk

_asm_libraries library search order ufs ufs

for discovery

_asm_maxio Maximum size of 1048576 1048576

Mon Sep 05 page 5

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

individual I/O

request


_asm_stripesize ASM file stripe size 131072 131072

_asm_stripewidth ASM file stripe 8 8

width

_asm_wait_time Max/imum time to 18 18



wait before asmb

exits


_asmlib_test Osmlib test event 0 0

_asmsid ASM instance id asm asm

_async_recovery_claims if TRUE, issue TRUE TRUE

recovery claims

asynchronously (DFS)

_async_recovery_reads if TRUE, issue TRUE TRUE

recovery reads

asynchronously (DFS)

_avoid_prepare if TRUE, do not TRUE TRUE

prepare a buffer

when the master is

local (DFS)

_awr_corrupt_mode AWR Corrupt Mode FALSE FALSE

_awr_restrict_mode AWR Restrict Mode FALSE FALSE

_b_tree_bitmap_plans enable the use of TRUE TRUE

bitmap plans for

tables w. only

B-tree indexes

_backup_disk_io_slaves BACKUP Disk I/O 0 0

slaves


_backup_io_pool_size memory to reserve 1048576 1048576

from the large pool

_backup_kgc_bufsz specifies buffer 0 0

size to be used for

kgc compression

_backup_kgc_niters specifies number of 0 0

iterations used for

kgc compression

_backup_kgc_type specifies 0 0

compression type

used for kgc

Mon Sep 05 page 6

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

compression

_backup_ksfq_bufcnt number of the ksfq 0 0

buffers used for

backup/restore

_backup_ksfq_bufsz size of the ksfq 0 0

buffer used for

backup/restore

_bct_bitmaps_per_file number of bitmaps to 8 8

store for each

datafile

_bct_buffer_allocation_max maximum size of all 104857600 104857600

change tracking

buffer allocations,

in bytes

_bct_buffer_allocation_min_extents mininum number of 1 1

extents to allocate

per buffer

allocation

_bct_buffer_allocation_size size of one change 2097152 2097152

tracking buffer

allocation, in bytes

_bct_chunk_size change tracking 0 0

datafile chunk size,

in bytes

_bct_crash_reserve_size change tracking 262144 262144

reserved crash

recovery SGA space,

in bytes

_bct_file_block_size block size of change 0 0

tracking file, in

bytes

_bct_file_extent_size extent size of 0 0



change tracking

file, in bytes

_bct_initial_private_dba_buffer_size initial number of 0 0

entries in the

private change

tracking dba buffers

Mon Sep 05 page 7

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_bct_public_dba_buffer_size total size of all 0 0

public change

tracking dba

buffers, in bytes

_bitmap_or_improvement_enabled controls extensions TRUE TRUE

to partition pruning

for general

predicates

_block_change_tracking change tracking TRUE TRUE

possible

_blocks_per_cache_server number of 128 128

consecutive blocks

per global cache

server


_bt_mmv_query_rewrite_enabled allow rewrites with TRUE TRUE

multiple MVs and

base tables

_buffer_busy_wait_timeout buffer busy wait 100 100

time in centiseconds

_bufq_stop_flow_control Stop enforcing flow FALSE FALSE

control for buffered

queues


_bump_highwater_mark_count how many blocks 0 0

should we allocate

per free list on

advancing HWM

_bwr_for_flushed_pi if TRUE, generate a TRUE TRUE

BWR for a flushed PI

(DFS)

_cache_stats_monitor if TRUE, enable TRUE TRUE



cache stats

monitoring

_cgs_send_timeout CGS send timeout 300 300

value


_check_block_after_checksum perform block check TRUE TRUE

after checksum if

both are turned on

_check_ts_threshold check tablespace 0 0

Mon Sep 05 page 8

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

thresholds

_cleanup_rollback_entries no. of undo entries 100 100

to apply per

transaction cleanup

_close_cached_open_cursors close cursors cached FALSE FALSE

by PL/SQL at each

commit

_cluster_library cluster library clss clss



selection

_collapse_wait_history collapse wait FALSE FALSE

history

_collect_undo_stats Collect Statistics TRUE TRUE

v$undostat

_column_compression_factor Column compression 0 0

ratio

_column_elimination_off turn off FALSE FALSE



predicate-only

column elimination

_column_tracking_level column usage 1 1

tracking

_complex_view_merging enable complex view TRUE TRUE

merging


_controlfile_block_size control file block 0 0

size in bytes

_controlfile_enqueue_dump dump the system FALSE FALSE

states after

controlfile enqueue

timeout


_controlfile_enqueue_timeout control file enqueue 900 900

timeout in seconds

_controlfile_update_check controlfile update OFF OFF

sanity check

_convert_set_to_join enables conversion FALSE FALSE

of set operator to

join

Mon Sep 05 page 9



Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_coord_message_buffer parallel recovery 0 0

coordinator side

extra message buffer

size


_corrupted_rollback_segments corrupted undo

segment list

_cost_equality_semi_join enables costing of TRUE TRUE

equality semi-join

_cpu_to_io divisor for 0 0

converting CPU cost

to I/O cost

_cr_grant_global_role if TRUE, grant lock TRUE TRUE

for CR requests when

block is in global

role

_cr_grant_local_role if TRUE, grant lock FALSE FALSE



for CR using 3way

ping when block in

local role

_cr_server_log_flush if TRUE, flush redo TRUE TRUE

log before serving a

CR buffer (DFS)

_cursor_bind_capture_area_size maximum size of the 400 400

cursor bind capture

area

_cursor_bind_capture_interval interval (in 900 900



seconds) between two

bind capture for a

cursor

_cursor_cache_frame_bind_memory frame & bind buffer FALSE FALSE



caching

_cursor_db_buffers_pinned additional number of 140 140

buffers a cursor can

pin at once

_cursor_plan_enabled enable collection TRUE TRUE

and display of

cursor plans

_cursor_plan_hash_version version of cursor 1 1

Mon Sep 05 page 10

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

plan hash value

_cursor_plan_unparse_enabled enables/disables TRUE TRUE

using unparse to

build


projection/predicate

s

_db_aging_cool_count Touch count set when 1 1



buffer cooled

_db_aging_freeze_cr Make CR buffers FALSE FALSE

always be too cold

to keep in cache

_db_aging_hot_criteria Touch count which 2 2

sends a buffer to

head of replacement

list


_db_aging_stay_count Touch count set when 0 0

buffer moved to head

of replacement list

_db_aging_touch_time Touch count which 3 3

sends a buffer to

head of replacement

list

_db_always_check_system_ts Always perform block TRUE TRUE



check and checksum

for System

tablespace

_db_block_buffers Number of database 85671 85671

blocks cached in

memory: hidden

parameter

_db_block_cache_clone Always clone data FALSE FALSE

blocks on get (for

debugging)

_db_block_cache_history buffer header 0 0

tracing (non-zero

only when debugging)

_db_block_cache_num_umap number of unmapped 0 0

buffers (for

tracking swap calls

Mon Sep 05 page 11

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

on blocks)

_db_block_cache_protect protect database FALSE FALSE

blocks (true only

when debugging)

_db_block_check_for_debug Check more and dump FALSE FALSE

block before image

for debugging

_db_block_granule_interval number of granules 10 10

to process

_db_block_hash_buckets Number of database 262144 262144

block hash buckets

_db_block_hash_latches Number of database 1024 1024

block hash latches

_db_block_hi_priority_batch_size Fraction of writes 0 0

for high priority

reasons


_db_block_known_clean_pct Initial Percentage 2 2

of buffers to

maintain known clean

_db_block_lru_latches number of lru 56 56

latches

_db_block_max_cr_dba Maximum Allowed 6 6

Number of CR buffers

per dba


_db_block_max_scan_pct Percentage of 40 40

buffers to inspect

when looking for

free


_db_block_med_priority_batch_size Fraction of writes 0 0

for medium priority

reasons

_db_block_numa Number of NUMA nodes 1 1

_db_block_prefetch_limit Prefetch limit in 0 0

blocks


_db_block_prefetch_quota Prefetch quota as a 10 10

percent of cache

size

Mon Sep 05 page 12



Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_db_block_trace_protect trace buffer protect FALSE FALSE

calls


_db_cache_advice_batch_size cache advisory 128 128

simulation batch

size

_db_cache_advice_sample_factor cache advisory 4 4



sampling factor

_db_cache_crx_check check for costly crx FALSE FALSE

examination

functions

_db_cache_pre_warm Buffer Cache TRUE TRUE

Pre-Warm Enabled :

hidden parameter

_db_fast_obj_check enable fast object FALSE FALSE

drop sanity check

_db_fast_obj_truncate enable fast object TRUE TRUE

truncate

_db_file_direct_io_count Sequential I/O buf 1048576 1048576

size

_db_file_format_io_buffers Block formatting I/O 4 4



buf count

_db_file_noncontig_mblock_read_count number of 11 11

noncontiguous db

blocks to be

prefetched

_db_handles System-wide 3000 3000

simultaneous buffer

operations

_db_handles_cached Buffer handles 5 5

cached each process

_db_large_dirty_queue Number of buffers 25 25

which force dirty

queue to be written

_db_mttr_advice MTTR advisory ON ON

_db_mttr_partitions number of partitions 0 0

for MTTR advisory

Mon Sep 05 page 13

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_db_mttr_sample_factor MTTR simulation 64 64

sampling factor

_db_mttr_sim_target MTTR simulation

targets


_db_mttr_sim_trace_size MTTR simulation 256 256

trace size

_db_mttr_trace_to_alert dump trace entries FALSE FALSE

to alert file

_db_percent_hot_default Percent of default 50 50

buffer pool

considered hot

_db_percent_hot_keep Percent of keep 0 0

buffer pool

considered hot

_db_percent_hot_recycle Percent of recycle 0 0

buffer pool

considered hot

_db_percpu_create_cachesize size of cache 2 2

created per cpu in

deferred cache

create

_db_recovery_temporal_file_dest default database



recovery temporal

file location

_db_todefer_cache_create buffer cache FALSE FALSE

deferred create

_db_writer_chunk_writes Number of writes 0 0

DBWR should wait for

_db_writer_coalesce_area_size Size of memory 1048576 1048576

allocated to

dbwriter for

coalescing writes

_db_writer_coalesce_write_limit Limit on size of 131072 131072

coalesced write

_db_writer_flush_imu If FALSE, DBWR will TRUE TRUE

not downgrade IMU

Mon Sep 05 page 14

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

txns for AGING

_db_writer_histogram_statistics maintain dbwr FALSE FALSE

histogram statistics

in x$kcbbhs

_db_writer_max_writes Max number of 0 0

outstanding DB

Writer IOs

_db_writer_scan_depth_pct Percentage of LRU 25 25

buffers for dbwr to

scan when looking

for dirty

_dbg_proc_startup debug process FALSE FALSE

startup

_dbwr_async_io Enable dbwriter TRUE TRUE

asynchronous writes

_dbwr_scan_interval dbwriter scan 300 300

interval

_dbwr_tracing Enable dbwriter 0 0

tracing

_dedicated_server_post_wait dedicated server FALSE FALSE

post/wait

_dedicated_server_post_wait_call dedicated server FALSE FALSE

post/wait call

_default_non_equality_sel_check sanity check on TRUE TRUE

default selectivity

for like/range

predicate

_delay_index_maintain delays index TRUE TRUE

maintenance until

after MV is

refreshed

_diag_daemon start DIAG daemon TRUE TRUE

_disable_datalayer_sampling disable datalayer FALSE FALSE

sampling

_disable_file_locks disable file locks FALSE FALSE

for control, data,

redo log files

Mon Sep 05 page 15

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_disable_function_based_index disable FALSE FALSE

function-based index

matching

_disable_health_check Disable Health Check FALSE FALSE

_disable_image_check Disable Oracle FALSE FALSE

executable image

checking

_disable_incremental_checkpoints Disable incremental FALSE FALSE

checkpoints for

thread recovery

_disable_kcbhxor_osd disable kcbh(c)xor FALSE FALSE

OSD functionality

_disable_latch_free_SCN_writes_via_32 disable latch-free FALSE FALSE

cas SCN writes using

32-bit compare &

swap


_disable_latch_free_SCN_writes_via_64 disable latch-free FALSE FALSE

cas SCN writes using

64-bit compare &

swap


_disable_logging Disable logging FALSE FALSE

_disable_multiple_block_sizes disable multiple FALSE FALSE

block size support

(for debugging)

_disable_odm disable odm feature FALSE FALSE

_disable_recoverable_recovery Disable the new FALSE FALSE

recoverable recovery

mechanism

_disable_sample_io_optim disable row sampling FALSE FALSE

IO optimization

_disable_savepoint_reset disable the fix for FALSE FALSE

bug 1402161

_disable_selftune_checkpointing Disable self-tune FALSE FALSE

checkpointing

_disable_sun_rsm Disable IPC OSD TRUE TRUE

support for Sun

RSMAPI

Mon Sep 05 page 16



Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_disable_system_state disable system state FALSE FALSE

dump


_disable_txn_alert disable txn layer 0 0

alert


_discrete_transactions_enabled enable OLTP mode FALSE FALSE

_dispatcher_rate_scale scale to display

rate statistic

(100ths of a second)

_dispatcher_rate_ttl time-to-live for

rate statistic

(100ths of a second)

_distinct_view_unnesting enables unnesting of FALSE FALSE

in subquery into

distinct view

_distributed_recovery_connection_hold number of seconds 200 200

_time RECO holds outbound

connections open

_dlm_send_timeout DLM send timeout 30000 30000

value

_dlmtrace Trace string of



global enqueue

type(s)


_dml_monitoring_enabled enable modification TRUE TRUE

monitoring

_domain_index_batch_size maximum number of 2000 2000

rows from one call

to domain index

fetch routine

_domain_index_dml_batch_size maximum number of 200 200

rows for one call to

domain index dml

routines

_ds_iocount_iosize Dynamic Sampling 6553664 6553664

Service defaults:

#IOs and IO Size

_dss_cache_flush enable full cache FALSE FALSE

flush for parallel

execution

Mon Sep 05 page 17

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_dump_common_subexpressions dump common FALSE FALSE

subexpressions

_dump_connect_by_loop_data dump connect by loop FALSE FALSE

error message into

trc file

_dump_cursor_heap_sizes dump comp/exec heap FALSE FALSE

sizes to tryace file

_dump_interval_limit trace dump time 120 120

interval limit (in

seconds)

_dump_max_limit max number of dump 5 5

within dump interval

_dump_system_state_scope scope of sysstate local local

dump during instance

termination

_dump_trace_scope scope of trace dump global global

during a process

crash


_dynamic_rls_policies rls policies are TRUE TRUE

dynamic


_dynamic_stats_threshold delay threshold (in 30 30

seconds) between

sending statistics

messages

_eliminate_common_subexpr enables elimination TRUE TRUE

of common

sub-expressions

_enable_NUMA_optimization Enable NUMA specific TRUE TRUE

optimizations

_enable_block_level_transaction_recov enable block level TRUE TRUE

ery recovery

_enable_cscn_caching enable commit SCN FALSE FALSE

caching for all

transactions

_enable_default_affinity to enable default 0 0

implementation of

Mon Sep 05 page 18

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

affinity osds

_enable_fast_ref_after_mv_tbs enable fast refresh FALSE FALSE

after move

tablespace

_enable_hash_overflow TRUE - enable hash FALSE FALSE

cluster overflow

based on SIZE

_enable_kgh_policy temporary to FALSE FALSE

disable/enable kgh

policy


_enable_list_io Enable List I/O FALSE FALSE

_enable_nativenet_tcpip Enable skgxp driver FALSE FALSE

usage for native net

_enable_refresh_schedule enable or disable MV TRUE TRUE

refresh scheduling

(revert to 9.2

behavior)

_enable_tablespace_alerts enable tablespace TRUE TRUE

alerts

_enable_type_dep_selectivity enable type TRUE TRUE



dependent

selectivity

estimates

_enqueue_debug_multi_instance debug enqueue multi FALSE FALSE

instance

_enqueue_hash enqueue hash table 1365 1365

length

_enqueue_hash_chain_latches enqueue hash chain 2 2



latches

_enqueue_locks locks for managed 8150 8150

enqueues

_expand_aggregates expand aggregates TRUE TRUE

_explain_rewrite_mode allow additional FALSE FALSE

messages to be

generated during

explain rewrite

_fair_remote_cvt if TRUE enables fair FALSE FALSE

Mon Sep 05 page 19

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

remote convert

_fairness_threshold number of times to 4 4

CR serve before

downgrading lock

(DFS)

_fast_dual_enabled enable/disable fast TRUE TRUE



dual

_fast_full_scan_enabled enable/disable index TRUE TRUE

fast full scan

_fast_start_instance_recovery_target cluster availability 0 0

target time in RAC

environment

_fic_algorithm_set Set Frequent Itemset automatic automatic

Counting Algorithm

_fic_area_size size of Frequent 131072 131072

Itemset Counting

work area

_fic_max_length Frequent Itemset 20 20

Counting Maximum

Itemset Length

_fic_outofmem_candidates Frequent Itemset FALSE FALSE

Counting Out Of

Memory Candidates

Generation

_fifth_spare_parameter fifth spare

parameter - string

_first_spare_parameter first spare

parameter - integer

_flashback_allow_noarchivelog Allow enabling FALSE FALSE

flashback on

noarchivelog

database

_flashback_barrier_interval Flashback barrier 1800 1800

interval in seconds

_flashback_copy_latches Number of flashback 10 10

copy latches

Mon Sep 05 page 20

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_flashback_fuzzy_barrier Use flashback fuzzy TRUE TRUE

barrier


_flashback_generation_buffer_size flashback generation 2097152 2097152

buffer size

_flashback_hint_barrier_percent Flashback hint 20 20

barrier percent

_flashback_log_min_size Minimum flashback 100 100

log size

_flashback_log_size Flashback log size 1000 1000

_flashback_logfile_enqueue_timeout flashback logfile 600 600

enqueue timeout for

opens


_flashback_max_log_size Maximum flashback 0 0

log size in bytes

(OS limit)

_flashback_n_log_per_thread Desired number of 128 128

flashback logs per

flashback thread

_flashback_standby_barrier_interval Flashback standby 1800 1800

barrier interval in

seconds

_flashback_verbose_info Print verbose FALSE FALSE

information about

flashback database

_flashback_write_size_qm Desired flashback 4 4

write size in

quarter MB

_force_datefold_trunc force use of trunc FALSE FALSE

for datefolding

rewrite


_force_temptables_for_gsets executes FALSE FALSE

concatenation of

rollups using temp

tables


_fourth_spare_parameter fourth spare

parameter - string

_full_pwise_join_enabled enable full TRUE TRUE

Mon Sep 05 page 21

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

partition-wise join

when TRUE

_gby_onekey_enabled enable use of one TRUE TRUE

comparison of all

group by keys

_gc_affinity_limit dynamic affinity 50 50

limit (DFS)

_gc_affinity_minimum dynamic affinity 1200 1200

minimum activity per

minute (DFS)

_gc_affinity_time how often in minutes 10 10

to check affinity

(DFS)

_gc_check_bscn if TRUE, check for TRUE TRUE



stale blocks (DFS)

_gc_defer_time how long to defer 3 3

down converts for

hot buffers (DFS)

_gc_element_percent global cache element 103 103

percent (DFS)

_gc_global_lru if TRUE, enable FALSE FALSE

global lru (DFS)

_gc_integrity_checks if TRUE, enable TRUE TRUE

expensive integrity

checks (DFS)

_gc_keep_recovery_buffers if TRUE, make FALSE FALSE

recovery buffers

current (DFS)

_gc_latches number of latches 5 5

per LMS process

(DFS)

_gc_statistics if TRUE, kcl TRUE TRUE



statistics are

maintained (DFS)

_gc_use_cr if TRUE, allow CR TRUE TRUE

pins on PI and

WRITING buffers

Mon Sep 05 page 22

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

(DFS)

_gc_vector_read if TRUE, vector read TRUE TRUE



current buffers

(DFS)


_gcs_fast_reconfig if TRUE, enable fast TRUE TRUE

reconfiguration for

gcs locks

_gcs_latches number of gcs 0 0

resource hash

latches to be

allocated per LMS

process


_gcs_process_in_recovery if TRUE, process gcs TRUE TRUE

requests during

instance recovery

_gcs_resources number of gcs

resources to be

allocated

_gcs_shadow_locks number of pcm shadow

locks to be

allocated

_generalized_pruning_enabled controls extensions TRUE TRUE

to partition pruning

for general

predicates

_ges_dd_debug if TRUE enables GES FALSE FALSE

deadlock detection

debug diagnostics

_ges_diagnostics if TRUE enables GES TRUE TRUE

diagnostics

_ges_trace if TRUE enables TRUE TRUE

GES/GCS debug traces

_groupby_nopushdown_cut_ratio groupby nopushdown 3 3

cut ratio

_groupby_orderby_combine groupby/orderby 5000 5000

don't combine

threshold

Mon Sep 05 page 23

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_gs_anti_semi_join_allowed enable anti/semi TRUE TRUE

join for the GS

query

_hang_detection Hang Management 0 0



detection interval

_hard_protection if TRUE enable FALSE FALSE

H.A.R.D specific

format changes

_hash_join_enabled enable/disable hash TRUE TRUE

join


_hash_multiblock_io_count number of blocks 0 0

hash join will

read/write at once

_high_server_threshold high server 0 0

thresholds

_hj_bit_filter_threshold hash-join bit 50 50

filtering threshold

(0 always enabled)

_idl_conventional_index_maintenance enable conventional TRUE TRUE

index maintenance

for insert direct

load


_idxrb_rowincr proportionality 100000000 100000000

constant for dop vs.

rows in index

rebuild


_ignore_desc_in_index ignore DESC in FALSE FALSE

indexes, sort those

columns ascending

anyhow


_improved_outerjoin_card improved outer-join TRUE TRUE

cardinality

calculation

_improved_row_length_enabled enable the TRUE TRUE

improvements for

computing the

average row length

_imr_active Activate Instance TRUE TRUE

Mon Sep 05 page 24

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

Membership Recovery

feature


_imr_max_reconfig_delay Maximum 300 300

Reconfiguration

delay (seconds)

_imr_splitbrain_res_wait Maximum wait for 600 600

split-brain

resolution (seconds)

_imu_pools in memory undo pools 3 3

_in_memory_undo Make in memory undo TRUE TRUE

for top level

transactions

_index_join_enabled enable the use of TRUE TRUE

index joins

_index_prefetch_factor index prefetching 100 100

factor


_init_sql_file File containing SQL ?/rdbms/admin ?/rdbms/admin/s

statements to /sql.bsq ql.bsq

execute upon

database creation

_init_tempfile_on_open if TRUE re-init FALSE FALSE

tempfile bitmaps on

db open whenever

possible

_insert_enable_hwm_brokered during parallel TRUE TRUE

inserts high water

marks are brokered

_inst_locking_period period an instance 5 5

can retain a newly

acquired level1

bitmap

_interconnect_checksum if TRUE, checksum TRUE TRUE



interconnect blocks

(DFS)


_intrapart_pdml_enabled Enable TRUE TRUE

intra-partition

updates/deletes

_intrapart_pdml_randomlocal_enabled Enable TRUE TRUE

Mon Sep 05 page 25

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

intra-partition

updates/deletes with

random local dist

_io_slaves_disabled Do not use I/O FALSE FALSE

slaves

_ioslave_batch_count Per attempt IOs 1 1



picked

_ioslave_issue_count IOs issued before 500 500

completion check

_ipc_fail_network Simulate cluster 0 0

network failer

_ipc_test_failover Test transparent 0 0

cluster network

failover

_ipc_test_mult_nets simulate multiple 0 0

cluster networks

_job_queue_interval Wakeup interval in 5 5

seconds for job

queue co-ordinator

_kcl_commit if TRUE, call TRUE TRUE

kjbcommit (DFS)

_kcl_conservative_log_flush if TRUE, FALSE FALSE

conservatively log

flush before CR

serving (DFS)

_kcl_debug if TRUE, record le TRUE TRUE

history (DFS)

_kcl_index_split if TRUE, reject TRUE TRUE

pings on blocks in

middle of a split

(DFS)

_kcl_undo_grouping grouping for undo 32 32



block locks (DFS)

_kcl_undo_locks number of locks per 128 128

undo segment (DFS)

_kdbl_enable_post_allocation allocate dbas after FALSE FALSE

Mon Sep 05 page 26

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

populating data

buffers


_keep_remote_column_size remote column size FALSE FALSE

does not get

modified

_kernel_message_network_driver kernel message FALSE FALSE

network driver

_kffmap_hash_size size of kffmap_hash 1024 1024

table

_kffmop_hash_size size of kffmop_hash 2048 2048



table

_kghdsidx_count max kghdsidx count 1 1

_kgl_bucket_count index to the bucket 9 9

count array

_kgl_hash_collision whether KGL hash FALSE FALSE

collision is

possible

_kgl_keep_cache_pct KGL keep cache 30 30

minimum threshold

_kgl_keep_cache_retain_pct KGL keep cache 20 20

retain threshold

_kgl_latch_count number of library 0 0

cache latches

_kgl_multi_instance_invalidation whether KGL to TRUE TRUE

support

multi-instance

invalidations

_kgl_multi_instance_lock whether KGL to TRUE TRUE

support

multi-instance locks

_kgl_multi_instance_pin whether KGL to TRUE TRUE

support


multi-instance pins

_kgl_session_cached_objects maximum length of 10 10

the KGL object cache

lru


Mon Sep 05 page 27

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_kgl_time_to_wait_for_locks time to wait for 15 15

locks and pins

before timing out

_kglsim_maxmem_percent max percentage of 5 5

shared pool size to

be used for KGL

advice

_kill_java_threads_on_eoc Kill Java threads FALSE FALSE



and do sessionspace

migration at end of

call

_kkfi_trace trace expression FALSE FALSE



substitution

_kolfuseslf allow kolf to use FALSE FALSE

slffopen

_ksdxw_cini_flg ksdxw context 0 0

initialization flag

_ksdxw_nbufs ksdxw number of 1000 1000

buffers in buffered

mode


_ksdxw_num_pgw number of 10 10

watchpoints on a

per-process basis

_ksdxw_num_sgw number of 10 10

watchpoints to be

shared by all

processes

_ksdxw_stack_depth number of PCs to 4 4

collect in the stack

when watchpoint is

hit

_kse_die_timeout amount of time a 60000 60000



dying process is

spared by PMON (in

centi-secs)

_ksi_trace KSI trace string of

lock type(s)

_ksmg_granule_locking_status granule locking 1 1

Mon Sep 05 page 28

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

status

_ksmg_granule_size granule size in 4194304 4194304



bytes

_ksmg_lock_check_interval timeout action

interval in minutes

_ksmg_lock_reacquire_count repeat count for 5 5

acquisition of locks

_kspptbl_mem_usage amount of memory 1556016 1556016

used for unused

session parameter

tables

_ksu_diag_kill_time number of seconds 5 5



ksuitm waits before

killing diag

_ktc_debug for ktc debug 0 0

_ktc_latches number of ktc 0 0

latches

_ktu_latches number of KTU 0 0

latches

_ku_trace datapump trace none none

parameter

_large_pool_min_alloc minimum allocation 3 3

size in bytes for

the large allocation

pool

_last_allocation_period period over which an 5 5



instance can retain

an active level1

bitmap

_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

Mon Sep 05 page 29

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_latch_miss_stat_sid Sid of process for 0 0

which to collect

latch stats

_latch_recovery_alignment align latch recovery 998 998

structures

_ldr_io_size size of write IOs 262144 262144

used during a load

operation

_left_nested_loops_random enable random TRUE TRUE

distribution method

for left of

nestedloops

_lgwr_async_broadcasts LGWR Asynchronous TRUE TRUE

Broadcasts enabling

boolean flag

_lgwr_async_io LGWR Asynchronous IO FALSE FALSE

enabling boolean

flag


_lgwr_delay_write LGWR write delay for FALSE FALSE

debugging

_lgwr_io_slaves LGWR I/O slaves 0 0

_lgwr_max_ns_wt Maximum wait time 1 1

for lgwr to allow

NetServer to

progress

_lgwr_ns_nl_max Variable to simulate 1000 1000

network latency or

buffer threshold

_lgwr_ns_nl_min Variable to simulate 500 500

network latency or

buffer threshold

_lgwr_ns_sim_err Variable to simulate 0 0

errors lgwrns

_library_cache_advice whether KGL advice TRUE TRUE

should be turned on

_lightweight_hdrs Lightweight headers TRUE TRUE

for redo

Mon Sep 05 page 30

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_like_with_bind_as_equality treat LIKE predicate FALSE FALSE

with bind as an

equality predicate

_lm_activate_lms_threshold threshold value to 100 100

activate an

additional lms

_lm_cache_lvl0_cleanup how often to cleanup 0 0

level 0 cache res

(in sec)

_lm_cache_res_cleanup percentage of cached 25 25

resources should be

cleanup


_lm_cache_res_type cache resource: TMHW TMHW

string of lock

types(s)

_lm_dd_interval dd time interval in 60 60

seconds

_lm_drm_max_requests dynamic remastering 100 100

maximum affinity

requests processed

together

_lm_drm_window dynamic remastering 0 0

bucket window size

_lm_dynamic_lms dynamic lms FALSE FALSE

invocation

_lm_dynamic_load dynamic load TRUE TRUE

adjustment

_lm_dynamic_remastering if TRUE enables FALSE FALSE

dynamic remastering

_lm_enq_lock_freelist Number of ges

enqueue element

freelist

_lm_enq_rcfg if TRUE enables TRUE TRUE

enqueue


reconfiguration

_lm_enqueue_freelist Number of enqueue 3 3

Mon Sep 05 page 31

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

freelist

_lm_file_affinity mapping between file

id and master

instance number

_lm_global_posts if TRUE deliver TRUE TRUE

global posts to

remote nodes

_lm_lmd_waittime default wait time 8 8

for lmd in

centiseconds

_lm_lms number of background 0 0

gcs server processes

to start

_lm_lms_waittime default wait time 8 8

for lms in

centiseconds

_lm_locks number of enqueues 12000 12000

configured for

cluster database

_lm_master_weight master resource 1 1

weight for this

instance

_lm_max_lms max. number of 0 0

background global

cache server

processes

_lm_min_lms min. number of 0 0

background global

cache server

processes

_lm_msg_batch_size GES batch message 0 0

size


_lm_msg_cache_thresholds GES message buffer

caching threshold

_lm_msg_cleanup_interval GES message buffer 3000 3000

cleanup interval

time

Mon Sep 05 page 32



Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_lm_node_join_opt cluster database FALSE FALSE

node join

optimization in

reconfig

_lm_non_fault_tolerant disable cluster FALSE FALSE

database

fault-tolerance mode

_lm_num_pcmhv_latches number of latches 0 0

covering the PCM HV

buckets in cgs

_lm_proc_freeze_timeout reconfiguration: 300 300

process freeze

timeout

_lm_process_batching GES implicit process TRUE TRUE

batching for IPC

messages

_lm_procs number of client 127 127

processes configured

for cluster database

_lm_rcfg_timeout Reconfiguration 180000 180000

timeout

_lm_rcv_buffer_size the size of receive 32768 32768

buffer

_lm_res_hash_bucket number of resource 0 0



hash buckets

_lm_res_part number of resource 1289 1289

partition configured

for gcs


_lm_ress number of resources 6000 6000

configured for

cluster database

_lm_send_buffers number of cluster 10000 10000

database send

buffers


_lm_send_mode GES send mode auto auto

_lm_send_queue_batching GES send queue TRUE TRUE

message batching

Mon Sep 05 page 33

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_lm_send_queue_length GES send queue 5000 5000

maximum length

_lm_sendproxy_reserve GES percentage of 25 25

send proxy reserve

of send tickets

_lm_share_lock_opt if TRUE enables FALSE FALSE

share lock

optimization

_lm_sq_batch_factor GES send queue 2 2

minimum batching

factor

_lm_sq_batch_type GES send queue auto auto



batching mechanism

_lm_sq_batch_waittick GES send queue 3 3

batching waittime in

tick


_lm_sync_timeout Synchronization

timeout for DLM

reconfiguration

steps


_lm_ticket_active_sendback Flow control ticket

active sendback

threshold

_lm_tickets GES messaging 1000 1000

tickets

_lm_tx_delta TX lock localization 16 16

delta

_lm_validate_resource_type if TRUE enables FALSE FALSE



resource name

validation

_lm_xids number of 139 139

transaction IDs

configured for

cluster database

_load_without_compile Load PL/SQL or none none

Database objects

without compilation

Mon Sep 05 page 34

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_local_communication_costing_enabled enable local TRUE TRUE

communication

costing when TRUE

_local_communication_ratio set the ratio 50 50

between global and

local communication

(0..100)

_lock_sga_areas Lock specified areas 0 0

of the SGA in

physical memory

_log_archive_buffer_size Size of each 2048 2048

archival buffer in

log file blocks

_log_archive_buffers Number of buffers to 10 10

allocate for

archiving

_log_archive_callout archival callout

_log_archive_compress_enable Bypass database FALSE FALSE

rules for enabling

archivelog

compression

_log_archive_delta_sync_wait iterative sleep time 0 0

in centiseconds

seconds when

SYNC=PARALLEL

_log_archive_net_timeout maximum network wait 0 0

time in seconds when

SYNC=PARALLEL

_log_archive_prot_auto_demote log archive FALSE FALSE

protection auto

demotion

_log_archive_security_enabled log archive security TRUE TRUE

enabled

_log_blocks_during_backup log block images TRUE TRUE

when changed during

backup


_log_buffers_corrupt corrupt redo buffers FALSE FALSE

before write

Mon Sep 05 page 35

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_log_buffers_debug debug redo buffers FALSE FALSE

(slows things down)

_log_checkpoint_recovery_check # redo blocks to 0 0

verify after

checkpoint

_log_committime_block_cleanout Log commit-time FALSE FALSE

block cleanout

_log_debug_multi_instance debug redo multi FALSE FALSE

instance code

_log_deletion_policy archivelog deletion mandatory mandatory

policy for

mandatory/all

destination

_log_io_size automatically 0 0

initiate log write

if this many redo

blocks in buffer

_log_parallelism Number of log buffer 1 1

strands

_log_parallelism_dynamic Enable dynamic TRUE TRUE

strands

_log_parallelism_max Maximum number of 2 2

log buffer strands

_log_private_mul Private strand 5 5

multiplier for log

space preallocation

_log_private_parallelism Number of private FALSE FALSE

log buffer strands

for zero-copy redo

_log_private_parallelism_mul Active sessions 10 10

multiplier to deduce

number of private

strands

_log_simultaneous_copies number of 4 4

simultaneous copies

into redo buffer(#

of copy latches)

Mon Sep 05 page 36

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_log_space_errors should we report TRUE TRUE

space errors to

alert log

_log_switch_timeout Maximum number of 0 0

seconds redos in the

current log could

span

_longops_enabled longops stats TRUE TRUE



enabled

_low_server_threshold low server 0 0

thresholds

_master_direct_sends direct sends for 31 31

messages from master

(DFS)


_mav_refresh_consistent_read refresh materialized TRUE TRUE

views using

consistent read

snapshot

_mav_refresh_double_count_prevented materialized view FALSE FALSE

MAV refreshes avoid

double counting

_mav_refresh_opt optimizations during 0 0

refresh of

materialized views

_mav_refresh_unionall_tables # tables for union 3 3

all expansion during

materialized view

refresh


_max_exponential_sleep max sleep during 0 0

exponential backoff

_max_protocol_support Max occurrence 10000 10000

protocols supported

in a process

_max_shrink_obj_stats number of segments 0 0

for which shrink

stats will be

maintained

_max_sleep_holding_latch max time to sleep 4 4

Mon Sep 05 page 37

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

while holding a

latch


_media_recovery_read_batch media recovery block 128 128

read batch

_mem_annotation_pr_lev private memory 0 0

annotation

collection level

_mem_annotation_scale memory annotation 1 1

pre-allocation

scaling


_mem_annotation_sh_lev shared memory 0 0

annotation

collection level

_mem_annotation_store memory annotation FALSE FALSE

in-memory store

_memory_broker_log_stat_entries memory broker num 9 9

stat entries

_memory_broker_shrink_heaps memory broker allow 0 0

policy to shrink

shared pool

_memory_broker_shrink_java_heaps memory broker allow 900 900

policy to shrink

java pool

_memory_broker_shrink_timeout memory broker allow 60000000 60000000

policy to shrink

shared/java pool

_memory_broker_stat_interval memory broker 300 300

statistics gathering

interval

_memory_management_tracing trace memory 0 0

management activity

_messages message queue 1200 1200

resources -

dependent on #

processes & #

buffers


_minimal_stats_aggregation prohibit stats TRUE TRUE

Mon Sep 05 page 38

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

aggregation at

compile/partition

maintenance time

_minimum_blocks_to_shrink minimum number 0 0

freeable blocks for

shrink to be present

_minimum_extents_to_shrink minimum number 1 1

freeable extents for

shrink to be present

_minimum_giga_scn Minimum SCN to start 0 0

with in 2^30 units

_mirror_redo_buffers Save buffers for FALSE FALSE

debugging redo

corruptions

_mmv_query_rewrite_enabled allow rewrites with FALSE FALSE

multiple MVs and/or

base tables

_multi_join_key_table_lookup TRUE iff TRUE TRUE

multi-join-key table

lookup prefetch is

enabled

_multiple_instance_recovery use multiple FALSE FALSE

instances for media

recovery

_mv_refresh_ana what percent to 0 0

analyze after

complete/PCT refresh

_mv_refresh_costing refresh decision rule rule

based on cost or on

rules


_mv_refresh_delta_fraction delta mv as 10 10

fractional

percentage of size

of mv


_mv_refresh_eut refresh materialized TRUE TRUE

views using

EUT(partition)-based

algorithm

Mon Sep 05 page 39

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_mv_refresh_force_parallel_query force materialized 0 0

view refreshes to

use parallel query

_mv_refresh_new_setup_disabled materialized view MV FALSE FALSE

refresh new setup

disabling

_mv_refresh_rebuild_percentage minimum percentage 10 10

change required in

MV to force an index

rebuild


_mv_refresh_selections create materialized TRUE TRUE

views with

selections and fast

refresh


_mv_refresh_use_stats pass cardinality TRUE TRUE

hints to refresh

queries

_mv_refsched_timeincr proportionality 300000 300000

constant for dop vs.

time in MV refresh

_mwin_schedule Enable/disable TRUE TRUE

Maintenance Window

Schedules

_nchar_imp_cnv NLS allow Implicit TRUE TRUE

Conversion between

CHAR and NCHAR

_nchar_imp_conv should implicit TRUE TRUE

conversion bewteen

clob and nclob be

allowed


_ncmb_readahead_enabled enable multi-block 0 0

readahead for an

index scan

_ncmb_readahead_tracing turn on multi-block 0 0

readahead tracing

_nested_loop_fudge nested loop fudge 100 100

_nested_mav_fast_oncommit_enabled nested MAV refresh TRUE TRUE

fast on commit

allowed

Mon Sep 05 page 40

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_new_initial_join_orders enable initial join TRUE TRUE

orders based on new

ordering heuristics

_new_sort_cost_estimate enables the use of TRUE TRUE

new cost estimate

for sort

_no_objects no object features FALSE FALSE

are used

_no_or_expansion OR expansion during FALSE FALSE

optimization

disabled

_notify_crs notify cluster ready FALSE FALSE

services of startup

and shutdown

_ns_max_flush_wt Flush wait time for 1 1

NetServer to flush

oustanding writes

_num_longop_child_latches number of child 2 2

latches for long op

array


_number_cached_attributes maximum number of 10 10

cached attributes

per instance

_object_statistics enable the object TRUE TRUE

level statistics

collection

_offline_rollback_segments offline undo segment

list


_ogms_home GMS home directory

_olap_aggregate_buffer_size OLAP Aggregate max 1048576 1048576

buffer size

_olap_aggregate_flags OLAP Aggregate debug 0 0

flags

_olap_aggregate_function_cache_enable OLAP Aggregate TRUE TRUE



d function cache

enabler


Mon Sep 05 page 41

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_olap_aggregate_function_merge_thresh OLAP Aggregate 32768 32768

old function merge

threshold

_olap_aggregate_max_thread_tuples OLAP Aggregate max 5000 5000

thread tuples

creation

_olap_aggregate_min_buffer_size OLAP Aggregate min 1024 1024

buffer size

_olap_aggregate_min_thread_status OLAP Aggregate 64 64

minimum cardinality

of dimensions for

thread


_olap_aggregate_multipath_hier OLAP Aggregate FALSE FALSE

Multi-path

Hierarhies enabled

_olap_aggregate_statlen_thresh OLAP Aggregate 1024 1024

status array usage

threshold

_olap_aggregate_store_probability OLAP Aggregate 100 100

function storeback

probability

_olap_aggregate_work_per_thread OLAP Aggregate max 1024 1024

work parents

_olap_aggregate_worklist_max OLAP Aggregate max 5000 5000

worklists generated

at once


_olap_allocate_errorlog_format OLAP Allocate %8p %8y %8z % %8p %8y %8z %e

Errorlog Format e (%n) (%n)

_olap_allocate_errorlog_header OLAP Allocate Dim Sour Dim Source

Errorlog Header ce Basis Basis

format %-8d %-8s %-8 %-8d %-8s %-8b

b Description Description

-------- ------

-------- ---- -- -------- ---

---- -------- --------

-----------

_olap_continuous_trace_file Specify TRUE to FALSE FALSE

enable continuous

OLAP tracing -

Mon Sep 05 page 42

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

otherwise only

exceptional events

will be logged

_olap_dbgoutfile_echo_to_eventlog OLAP DbgOutfile copy FALSE FALSE

output to event log

(tracefile)

_olap_dimension_corehash_class OLAP Dimension 1 1

In-Core Hash Table

Class

_olap_dimension_corehash_max OLAP Dimension 10000 10000



In-Core Hash Table

Maximum Size

_olap_dimsave_restore_cache_values OLAP Dimsave TRUE TRUE

restores cached

dimension values

_olap_eif_export_lob_size OLAP EIF Export BLOB 2147483647 2147483647

size

_olap_object_hash_class OLAP Object Hash 2 2



Table Class

_olap_page_pool_expand_rate OLAP Page Pool 20 20

Expand Rate

_olap_page_pool_hi OLAP Page Pool High 50 50

Watermark

_olap_page_pool_hit_target OLAP Page Pool Hit 100 100

Target

_olap_page_pool_low OLAP Page Pool Low 262144 262144



Watermark

_olap_page_pool_pressure OLAP Page Pool 90 90

Pressure Threshold

_olap_page_pool_shrink_rate OLAP Page Pool 50 50

Shrink Rate

_olap_parallel_update_threshold OLAP parallel update 1000 1000

threshold in pages

_olap_poutlog_echo_to_eventlog OLAP POutLog copy FALSE FALSE

output to event log

(tracefile)

Mon Sep 05 page 43

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_olap_sesscache_enabled OLAP Session Cache TRUE TRUE

knob


_olap_sort_buffer_size OLAP Sort Buffer 262144 262144

Size


_olap_statbool_corebits OLAP Status Boolean 20000000 20000000

max incore bits

_olap_statbool_threshold OLAP Status Boolean 8100 8100

CBM threshold

_olap_table_function_statistics Specify TRUE to FALSE FALSE

output OLAP table

function timed

statistics trace

_olapi_history_retention enable olapi history FALSE FALSE

retention

_olapi_iface_object_history enable olapi 1000 1000

interface object

history collection

_olapi_iface_object_history_retention enable olapi FALSE FALSE

interface object

history retention

_olapi_iface_operation_history_retent enable olapi FALSE FALSE

ion interface operation

history retention

_olapi_interface_operation_history enable olapi 1000 1000

interface operation

history collection

_olapi_memory_operation_history enable olapi memory 1000 1000

alloc/free history

collection

_olapi_memory_operation_history_pause enable olapi memory 0 0

_at_seqno alloc/free history

collection pausing

_olapi_memory_operation_history_reten enable olapi memory FALSE FALSE

tion operation history

retention

_olapi_session_history enable olapi session 300 300

Mon Sep 05 page 44

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

history collection

_olapi_session_history_retention enable olapi session FALSE FALSE

history retention

_old_connect_by_enabled enable/disable old FALSE FALSE

connect by

_omf enable/disable OMF enabled enabled

_oneside_colstat_for_equijoins sanity check on TRUE TRUE

default selectivity

for like/range

predicate

_optim_adjust_for_part_skews adjust stats for TRUE TRUE

skews across

partitions

_optim_dict_stats_at_db_cr_upg enable/disable TRUE TRUE

dictionary stats

gathering at db

create/upgrade

_optim_enhance_nnull_detection TRUE to enable index TRUE TRUE

[fast] full scan

more often

_optim_new_default_join_sel improves the way TRUE TRUE

default equijoin

selectivity are

computed

_optim_peek_user_binds enable peeking of TRUE TRUE

user binds

_optimizer_adjust_for_nulls adjust selectivity TRUE TRUE

for null values

_optimizer_autostats_job enable/disable auto TRUE TRUE

stats collection job

_optimizer_block_size standard block size 8192 8192

used by optimizer

_optimizer_cache_stats cost with cache FALSE FALSE

statistics

_optimizer_cbqt_factor cost factor for 50 50

cost-based query

transformation

Mon Sep 05 page 45

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_optimizer_ceil_cost CEIL cost in CBO TRUE TRUE

_optimizer_choose_permutation force the optimizer 0 0

to use the specified

permutation

_optimizer_compute_index_stats force index stats TRUE TRUE

collection on index

creation/rebuild

_optimizer_correct_sq_selectivity force correct TRUE TRUE

computation of

subquery selectivity

_optimizer_cost_based_transformation enables cost-based LINEAR LINEAR

query transformation

_optimizer_cost_filter_pred enables costing of FALSE FALSE

filter predicates in

IO cost model

_optimizer_cost_model optimizer cost model CHOOSE CHOOSE

_optimizer_degree force the optimizer 0 0

to use the same

degree of

parallelism

_optimizer_dim_subq_join_sel use join selectivity TRUE TRUE

in choosing star

transformation

dimensions

_optimizer_disable_strans_sanity_chec disable star 0 0

ks transformation

sanity checks

_optimizer_dyn_smp_blks number of blocks for 32 32

optimizer dynamic

sampling

_optimizer_ignore_hints enables the embedded FALSE FALSE

hints to be ignored

_optimizer_invalidation_period time window for 18000 18000

invalidation of

cursors of analyzed

objects


_optimizer_join_order_control controls the 3 3

optimizer join order

Mon Sep 05 page 46

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

search algorithm

_optimizer_join_sel_sanity_check enable/disable TRUE TRUE

sanity check for

multi-column join

selectivity

_optimizer_max_permutations optimizer maximum 2000 2000

join permutations

per query block

_optimizer_mjc_enabled enable merge join TRUE TRUE

cartesian

_optimizer_mode_force force setting of TRUE TRUE

optimizer mode for

user recursive SQL

also


_optimizer_new_join_card_computation compute join TRUE TRUE

cardinality using

non-rounded input

values


_optimizer_percent_parallel optimizer percent 101 101

parallel

_optimizer_push_down_distinct push down distinct 0 0

from query block to

table

_optimizer_push_pred_cost_based use cost-based query TRUE TRUE



transformation for

push pred

optimization

_optimizer_random_plan optimizer seed value 0 0

for random plans

_optimizer_save_stats enable/disable TRUE TRUE

saving old versions

of optimizer stats

_optimizer_search_limit optimizer search 5 5

limit


_optimizer_skip_scan_enabled enable/disable index TRUE TRUE

skip scan

_optimizer_sortmerge_join_enabled enable/disable TRUE TRUE

Mon Sep 05 page 47

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

sort-merge join

method


_optimizer_squ_bottomup enables unnesting of TRUE TRUE

subquery in a

bottom-up manner

_optimizer_system_stats_usage system statistics TRUE TRUE

usage

_optimizer_undo_changes undo changes to FALSE FALSE



query optimizer

_optimizer_undo_cost_change optimizer undo cost 10.1.0.3 10.1.0.3

change

_or_expand_nvl_predicate enable OR expanded TRUE TRUE



plan for NVL/DECODE

predicate

_oradbg_pathname path of oradbg

script


_ordered_nested_loop enable ordered TRUE TRUE

nested loop costing

_ordered_semijoin enable ordered TRUE TRUE

semi-join subquery

_parallel_adaptive_max_users maximum number of 2 2

users running with

default DOP

_parallel_broadcast_enabled enable broadcasting TRUE TRUE

of small inputs to

hash and sort merge

joins

_parallel_default_max_instances default maximum 1 1



number of instances

for parallel query

_parallel_execution_message_align Alignment of PX FALSE FALSE

buffers to OS page

boundary

_parallel_fake_class_pct fake db-scheduler 0 0

percent used for

testing


Mon Sep 05 page 48

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_parallel_fixwrite_bucket Number of buckets 1000 1000

for each round of

fix write

_parallel_load_bal_unit number of threads to 0 0

allocate per

instance

_parallel_load_balancing parallel execution TRUE TRUE

load balanced slave

allocation

_parallel_min_message_pool minimum size of 902160 902160

shared pool memory

to reserve for pq

servers

_parallel_recovery_stopat stop at -position- 32767 32767

to step through SMON

_parallel_replay_bucket Number of buckets 1000 1000

for each round of

parallel replay

_parallel_server_idle_time idle time before 30000 30000

parallel query

server dies (in

1/100 sec)

_parallel_server_sleep_time sleep time between 10 10

dequeue timeouts (in

1/100ths)

_parallel_slave_acquisition_wait time(in seconds) to 1 1

wait before retrying

slave acquisition

_parallel_txn_global enable parallel_txn FALSE FALSE

hint with updates

and deletes

_parallelism_cost_fudge_factor set the parallelism 350 350

cost fudge factor

_partial_pwise_join_enabled enable partial TRUE TRUE

partition-wise join

when TRUE

_partition_view_enabled enable/disable TRUE TRUE

partitioned views

Mon Sep 05 page 49

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_passwordfile_enqueue_timeout password file 900 900

enqueue timeout in

seconds

_pct_refresh_double_count_prevented materialized view TRUE TRUE

PCT refreshes avoid

double counting

_pdml_gim_sampling control separation 5000 5000

of global index

maintenance for PDML

_pdml_gim_staggered slaves start on FALSE FALSE

different index when

doing index maint

_pdml_slaves_diff_part slaves start on TRUE TRUE

different partition

when doing index

maint


_percent_flashback_buf_partial_full Percent of flashback 50 50

buffer filled to be

considered partial

full


_pga_large_extent_size PGA large extent 1048576 1048576

size


_pga_max_size Maximum size of the 209715200 209715200

PGA memory for one

process

_ping_level fusion ping level 3 3

(DFS)

_pkt_enable enable progressive FALSE FALSE



kill test

_pkt_pmon_interval PMON process 50 50

clean-up interval

(cs)


_pkt_start start progressive FALSE FALSE

kill test

instrumention

_plsql_anon_block_code_type PL/SQL anonymous INTERPRETED INTERPRETED

block code-type

Mon Sep 05 page 50

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_plsql_dump_buffer_events conditions upon

which the PL/SQL

circular buffer is

dumped


_pmon_load_constants server load 300,192,64,3, 300,192,64,3,10

balancing constants 10,10,0 ,10,0

(S,P,D,I,L,C,M)

_pre_rewrite_push_pred push predicates into TRUE TRUE

views before rewrite

_precompute_gid_values precompute gid TRUE TRUE

values and copy them

before returning a

row

_pred_move_around enables predicate TRUE TRUE



move-around

_predicate_elimination_enabled allow predicate TRUE TRUE

elimination if set

to TRUE


_prescomm presume commit of FALSE FALSE

IMU transactions

_print_refresh_schedule enable dbms_output false false

of materialized view

refresh schedule

_private_memory_address Start address of

large extent memory

segment


_project_view_columns enable projecting TRUE TRUE

out unreferenced

columns of a view

_projection_pushdown projection pushdown TRUE TRUE

_projection_pushdown_debug level for projection 0 0

pushdown debugging

_push_join_predicate enable pushing join TRUE TRUE

predicate inside a

view

_push_join_union_view enable pushing join TRUE TRUE



predicate inside a

Mon Sep 05 page 51

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

union all view

_push_join_union_view2 enable pushing join TRUE TRUE

predicate inside a

union view

_px_async_getgranule asynchronous get FALSE FALSE

granule in the slave

_px_broadcast_fudge_factor set the tq 100 100

broadcasting fudge

factor percentage

_px_buffer_ttl ttl for px mesg 30 30

buffers in seconds

_px_compilation_debug debug level for 0 0

parallel compilation

_px_compilation_trace tracing level for 0 0

parallel compilation

_px_dynamic_opt turn off/on TRUE TRUE

restartable qerpx

dynamic optimization

_px_dynamic_sample_size num of samples for 50 50

restartable qerpx

dynamic optimization

_px_granule_size default size of a 100000 100000

rowid range granule

(in KB)


_px_index_sampling parallel query 200 200

sampling for index

create (100000 =

100%)


_px_kxib_tracing turn on kxib tracing 0 0

_px_load_publish_interval interval at which 200 200

LMON will check

whether to publish

PX load

_px_loc_msg_cost CPU cost to send a 1000 1000

PX message via

shared memory

_px_max_granules_per_slave maximum number of 100 100

Mon Sep 05 page 52

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

rowid range granules

to generate per

slave

_px_min_granules_per_slave minimum number of 13 13



rowid range granules

to generate per

slave

_px_net_msg_cost CPU cost to send a 10000 10000



PX message over the

internconnect

_px_no_granule_sort prevent parallel FALSE FALSE

partition granules

to be sorted on size

_px_no_stealing prevent parallel FALSE FALSE

granule stealing in

shared nothing

environment

_px_proc_constrain reduce TRUE TRUE

parallel_max_servers

if greater than

(processes - fudge)

_px_send_timeout IPC message send 300 300

timeout value in

seconds


_px_slaves_share_cursors slaves share cursors 0 0

with QC


_px_trace px trace parameter none none

_px_xtgranule_size default size of a 10000 10000

external table

granule (in KB)

_qa_control Oracle internal 0 0

parameter to control

QA

_qa_lrg_type Oracle internal 0 0



parameter to specify

QA lrg type

_query_cost_rewrite perform the cost TRUE TRUE

based rewrite with

materialized views

Mon Sep 05 page 53

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_query_execution_cache_max_size max size of query 65536 65536

execution cache

_query_rewrite_1 perform query TRUE TRUE

rewrite before&after

or only before view

merging


_query_rewrite_2 perform query TRUE TRUE

rewrite before&after

or only after view

merging


_query_rewrite_drj mv rewrite and drop TRUE TRUE

redundant joins

_query_rewrite_expression rewrite with TRUE TRUE

cannonical form for

expressions

_query_rewrite_fpc mv rewrite fresh TRUE TRUE

partition

containment

_query_rewrite_fudge cost based query 90 90

rewrite with MVs

fudge factor

_query_rewrite_jgmigrate mv rewrite with jg TRUE TRUE

migration

_query_rewrite_maxdisjunct query rewrite max 257 257

disjuncts

_query_rewrite_or_error allow query rewrite, FALSE FALSE

if referenced tables

are not dataless

_query_rewrite_setopgrw_enable perform general TRUE TRUE

rewrite using set

operator summaries

_query_rewrite_vop_cleanup prune frocol chain TRUE TRUE

before rewrite after

view-merging

_rcfg_parallel_cleanup if TRUE enables TRUE TRUE

parallel cleanup at

reconfiguration

Mon Sep 05 page 54

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_rcfg_parallel_fixwrite if TRUE enables TRUE TRUE

parallel fixwrite at

reconfiguration

_rcfg_parallel_replay if TRUE enables TRUE TRUE

parallel replay at

reconfiguration

_rcfg_parallel_verify if TRUE enables TRUE TRUE

parallel verify at

reconfiguration

_real_time_apply_arch_delay Archival delay with 0 0

real time apply

_real_time_apply_sim Simulation value 0 0

with real time apply

_realfree_heap_max_size minimum max total 32768 32768

heap size, in Kbytes

_realfree_heap_mode mode flags for 0 0

real-free heap

_realfree_heap_pagesize_hint hint for real-free 65536 65536

page size in bytes

_recoverable_recovery_batch_percent Recoverable recovery 50 50

batch size

(percentage of

buffer cache)

_recovery_asserts if TRUE, enable FALSE FALSE

expensive recovery

sanity checks (DFS)

_recovery_percentage recovery buffer 50 50

cache percentage

_recursive_imu_transactions recursive FALSE FALSE

transactions may be

IMU

_recyclebin recyclebin TRUE TRUE



processing

_release_insert_threshold maximum number of 5 5

unusable blocks to

unlink from freelist

Mon Sep 05 page 55

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_reliable_block_sends if TRUE, block sends FALSE FALSE

across interconnect

are reliable

_remove_aggr_subquery enables removal of TRUE TRUE

subsumed aggregated

subquery

_reuse_index_loop number of blocks 5 5

being examine for

index block reuse

_right_outer_hash_enable Right TRUE TRUE

Outer/Semi/Anti Hash

Enabled


_rollback_segment_count number of undo 0 0

segments

_rollback_segment_initial starting undo 1 1

segment number

_rollback_stopat stop at -position to 0 0

step rollback

_row_cache_cursors number of cached 10 10

cursors for row

cache management

_row_cr enable row cr for FALSE FALSE

all sql

_row_locking row-locking always always

_rowsource_execution_statistics if TRUE, Oracle will FALSE FALSE

collect rowsource

statistics

_rowsource_statistics_sampfreq frequency of 128 128

rowsource statistic

sampling (must be a

power of 2)

_sample_rows_per_block number of rows per 4 4

block used for

sampling IO

optimization

_scn_scheme SCN scheme

_second_spare_parameter second spare

Mon Sep 05 page 56

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

parameter - integer

_selftune_checkpoint_write_pct Percentage of total 3 3

physical i/os for

self-tune ckpt

_selftune_checkpointing_lag Self-tune 300 300

checkpointing lag

the tail of the redo

log


_send_ast_to_foreground if TRUE, send ast TRUE TRUE

message to

foreground

_send_close_with_block if TRUE, send close TRUE TRUE

with block even with

direct sends

_send_requests_to_pi if TRUE, try to send TRUE TRUE

CR requests to PI

buffers (DFS)

_serial_direct_read enable direct read FALSE FALSE

in serial

_serial_recovery force serial FALSE FALSE

recovery or parallel

recovery

_serializable serializable FALSE FALSE

_session_idle_bit_latches one latch per 0 0

session or a latch

per group of

sessions

_session_idle_check_interval Resource Manager 60 60

session idle limit

check interval in

seconds

_session_wait_history enable session wait 10 10

history collection

_seventh_spare_parameter seventh spare

parameter - string

list


_shared_pool_max_size shared pool maximum 0 0

size when auto SGA

Mon Sep 05 page 57

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

enabled

_shared_pool_reserved_min_alloc minimum allocation 4400 4400

size in bytes for

reserved area of

shared pool

_shared_pool_reserved_pct percentage memory of 5 5

the shared pool

allocated for the

reserved area

_shrunk_aggs_disable_threshold percentage of 60 60

exceptions at which

to switch to full

length aggs

_shrunk_aggs_enabled enable use of TRUE TRUE

variable sized

buffers for

non-distinct

aggregates

_side_channel_batch_size number of messages 200 200

to batch in a side

channel message

(DFS)


_side_channel_batch_timeout timeout before 5 5

shipping out all the

batched side

channelmessages

_simulator_bucket_mindelta LRU bucket minimum 8192 8192

delta


_simulator_internal_bound simulator internal 10 10

bound percent

_simulator_lru_rebalance_sizthr LRU list rebalance 2 2

threshold (size)

_simulator_lru_rebalance_thresh LRU list rebalance 10240 10240

threshold (count)

_simulator_lru_scan_count LRU scan count 8 8

_simulator_pin_inval_maxcnt maximum count of 16 16

invalid chunks on

pin list

Mon Sep 05 page 58

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_simulator_reserved_heap_count simulator reserved 4096 4096

heap count

_simulator_reserved_obj_count simulator reserved 1024 1024

object count

_simulator_sampling_factor sampling factor for 2 2

the simulator

_simulator_upper_bound_multiple upper bound multiple 2 2

of pool size

_single_process run without detached FALSE FALSE

processes

_sixth_spare_parameter sixth spare

parameter - string

list

_skip_assume_msg if TRUE, skip assume TRUE TRUE



message for consigns

at the master

_slave_mapping_enabled enable slave mapping TRUE TRUE

when TRUE

_slave_mapping_group_size force the number of 0 0

slave group in a

slave mapper

_small_table_threshold threshold level of 1713 1713

table size for

direct reads

_smm_advice_enabled if TRUE, enable TRUE TRUE

v$pga_advice

_smm_advice_log_size overwrites default 0 0

size of the PGA

advice workarea

history log

_smm_auto_cost_enabled if TRUE, use the TRUE TRUE

AUTO size policy

cost functions

_smm_auto_max_io_size Maximum IO size (in 248 248

KB) used by

sort/hash-join in

auto mode

Mon Sep 05 page 59

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_smm_auto_min_io_size Minimum IO size (in 56 56

KB) used by

sort/hash-join in

auto mode

_smm_bound overwrites memory 0 0

manager


automatically

computed bound

_smm_control provides controls on 0 0

the memory manager

_smm_freeable_retain value in KB of the 5120 5120

instance freeable

PGA memory to retain

_smm_max_size maximum work area 52428 52428

size in auto mode

(serial)

_smm_min_size minimum work area 1024 1024

size in auto mode

_smm_px_max_size maximum work area 314571 314571

size in auto mode

(global)

_smm_retain_size work area retain 0 0

size in SGA for

shared server

sessions (0 for

AUTO)


_smm_trace Turn on/off tracing 0 0

for SQL memory

manager

_smon_internal_errlimit limit of SMON 100 100

internal errors

_smu_debug_mode - set 0 0

debug event for

testing SMU

operations

_smu_error_simulation_site site ID of error 0 0

simulation in KTU

code


Mon Sep 05 page 60

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_smu_error_simulation_type error type for error 0 0

simulation in KTU

code

_smu_timeouts comma-separated *AND



double-quoted* list

of AUM timeouts:

mql, tur,

sess_exprn,

qry_exprn,

slot_intvl

_sort_elimination_cost_ratio cost ratio for sort 0 0

eimination under

first_rows mode

_sort_multiblock_read_count multi-block read 2 2

count for sort

_sort_space_for_write_buffers tenths of 1 1

sort_area_size

devoted to direct

write buffers

_spin_count Amount to spin 2000 2000

waiting for a latch

_spr_max_rules maximum number of 10000 10000

rules in sql

spreadsheet

_spr_push_pred_refspr push predicates TRUE TRUE

through reference

spreadsheet

_spr_use_AW_AS enable AW for hash TRUE TRUE

table in spreadsheet

_spr_use_hash_table use hash table for FALSE FALSE

spreadsheet

_sql_connect_capability_override SQL Connect 0 0

Capability Table

Override

_sql_connect_capability_table SQL Connect

Capability Table

(testing only)

Mon Sep 05 page 61

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_sqlexec_progression_cost sql execution 1000 1000

progression

monitoring cost

threshold

_sqltune_category_parsed Parsed category DEFAULT DEFAULT

qualifier for

applying hintsets

_sta_control SQL Tuning Advisory 0 0

control parameter

_stn_trace SQL tracing 0 0

parameter

_subquery_pruning_cost_factor subquery pruning 20 20

cost factor

_subquery_pruning_enabled enable the use of TRUE TRUE

subquery predicates

to perform pruning

_subquery_pruning_mv_enabled enable the use of FALSE FALSE

subquery predicates

with MVs to perform

pruning


_subquery_pruning_reduction subquery pruning 50 50

reduction factor

_swrf_metric_frequent_mode Enable/disable SWRF TRUE TRUE

Metric Frequent Mode

Collection

_swrf_mmon_dbfus Enable/disable SWRF TRUE TRUE

MMON DB Feature

Usage


_swrf_mmon_flush Enable/disable SWRF TRUE TRUE

MMON FLushing

_swrf_mmon_metrics Enable/disable SWRF TRUE TRUE

MMON Metrics

Collection

_swrf_on_disk_enabled Parameter to TRUE TRUE

enable/disable SWRF

_swrf_test_action test action 0 0

parameter for SWRF

Mon Sep 05 page 62

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_swrf_test_dbfus Enable/disable DB FALSE FALSE

Feature Usage

Testing

_sysaux_test_param test parameter for 1 1

SYSAUX

_system_index_caching optimizer percent 0 0



system index caching

_system_trig_enabled are system triggers TRUE TRUE

enabled

_table_lookup_prefetch_size table lookup 40 40

prefetch vector size

_table_lookup_prefetch_thresh table lookup 2 2

prefetch threshold

_table_scan_cost_plus_one bump estimated full TRUE TRUE

table scan and index

ffs cost by one

_temp_tran_block_threshold number of blocks for 100 100

a dimension before

we temp transform

_temp_tran_cache determines if temp TRUE TRUE

table is created

with cache option

_test_ksusigskip test the function 5 5

ksusigskip

_test_param_1 test parmeter 1 - 25 25

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 test parmeter 5 - 25 25

deprecated integer

Mon Sep 05 page 63

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_test_param_6 test parmeter 6 - 0 0

size (ub8)

_third_spare_parameter third spare

parameter - integer

_threshold_alerts_enable if 1, issue 1 1

threshold-based

alerts

_total_large_extent_memory Total memory for 0 0



allocating large

extents


_tq_dump_period time period for 0 0

duping of TQ

statistics (s)

_trace_archive start DIAG process FALSE FALSE

_trace_buffer_flushes trace buffer flushes FALSE FALSE

if otrace cacheIO

event is set

_trace_buffer_gets trace kcb buffer FALSE FALSE

gets if otrace

cacheIO event is set

_trace_buffer_wait_timeouts trace buffer busy 0 0

wait timeouts

_trace_buffers trace buffer sizes ALL:256 ALL:256

per process

_trace_cr_buffer_creates trace cr buffer FALSE FALSE

creates if otrace

cacheIO event is set

_trace_events trace events enabled

at startup

_trace_file_size maximum size of 65536 65536

trace file (in

bytes)


_trace_files_public Create publicly FALSE FALSE

accessible trace

files

_trace_flush_processes trace data archived ALL ALL



by DIAG for these

Mon Sep 05 page 64

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

processes

_trace_instance_termination trace instance FALSE FALSE

termination actions

_trace_multi_block_reads trace multi_block FALSE FALSE

reads if otrace

cacheIO event is set

_trace_navigation_scope enabling trace global global

navigation linking

_trace_options trace data flush text,multiple text,multiple

options


_trace_pin_time trace how long a 0 0

current pin is held

_trace_processes enable KST tracing ALL ALL

in process

_transaction_auditing transaction auditing TRUE TRUE

records generated in

the redo log

_transaction_recovery_servers max number of 0 0

parallel recovery

slaves that may be

used

_tts_allow_charset_mismatch allow plugging in a FALSE FALSE



tablespace with an

incompatible

character set

_two_pass enable two-pass TRUE TRUE

thread recovery

_two_pass_reverse_polish_enabled uses two-pass TRUE TRUE

reverse polish alg.

to generate

canonical forms

_uga_cga_large_extent_size UGA/CGA large extent 262144 262144

size

_ultrafast_latch_statistics maintain fast-path TRUE TRUE



statistics for

ultrafast latches

Mon Sep 05 page 65

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_undo_autotune enable auto tuning TRUE TRUE

of undo_retention

_undo_debug_usage invoke undo usage 0 0

functions for

testing

_union_rewrite_for_gs expand queries with YES_GSET_MVS YES_GSET_MVS

GSets into UNIONs

for rewrite

_unnest_subquery enables unnesting of TRUE TRUE

correlated

subqueries

_use_column_stats_for_function enable the use of TRUE TRUE

column statistics

for DDP functions

_use_ism Enable Shared Page TRUE TRUE

Tables - ISM

_use_ism_for_pga Use ISM for TRUE TRUE

allocating large

extents

_use_new_explain_plan if TRUE, use the FALSE FALSE

AUTO size policy

cost functions

_use_nosegment_indexes use nosegment FALSE FALSE

indexes in explain

plan

_use_realfree_heap use real-free based TRUE TRUE



allocator for PGA

memory


_use_seq_process_cache whether to use TRUE TRUE

process local seq

cache

_use_vector_post use vector post TRUE TRUE



_validate_flashback_database Scan database to FALSE FALSE

validate result of

flashback database

_vendor_lib_loc Vendor library

search root

directory

Mon Sep 05 page 66

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_verify_flashback_redo Verify that the redo TRUE TRUE

logs needed for

flashback are

available

_verify_undo_quota TRUE - verify FALSE FALSE

consistency of undo

quota statistics

_wait_for_sync wait for sync on TRUE TRUE

commit MUST BE

ALWAYS TRUE

_walk_insert_threshold maximum number of 0 0

unusable blocks to

walk across freelist

_watchpoint_on is the watchpointing FALSE FALSE

feature turned on?

_write_clones write clones flag 3 3

_xsolapi_auto_materialization_bound OLAP API lower bound 20 20

for auto

materialization.

_xsolapi_auto_materialization_type OLAP API behavior PRED_ONLY PRED_ONLY

for auto

materialization

_xsolapi_cursor_max_rows_to_cache_per OLAP API max rows to 15000 15000

_req cache per request

_xsolapi_cursor_max_time_for_partial_ OLAP API cursor max 5000 5000

cache execute time for

partial cache

_xsolapi_cursor_use_row_cache OLAP API enable TRUE TRUE

cursor caching

_xsolapi_debug_output OLAP API debug

output disposition

_xsolapi_densify_cubes OLAP API cube TABULAR TABULAR

densification

_xsolapi_dimension_group_creation OLAP API symmetric OVERFETCH OVERFETCH

overfetch

_xsolapi_fetch_type OLAP API fetch type PARTIAL PARTIAL

Mon Sep 05 page 67

Undocumented Oracle Parameters TEST Database


Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_xsolapi_load_at_process_start When to load OLAP NEVER NEVER

API library at

server process start

_xsolapi_materialization_rowcache_min OLAP API min number 1 1

_rows_for_use of rows required to

use rowcache in

query

materialization



_xsolapi_materialize_sources OLAP API Enable TRUE TRUE

source


materialization

_xsolapi_sql_all_multi_join_non_base_ OLAP API multi-join

hints non-base hints

_xsolapi_sql_all_non_base_hints OLAP API non-base

hints

_xsolapi_sql_auto_dimension_hints OLAP API enable FALSE FALSE



automatic dimension

hints


_xsolapi_sql_auto_measure_hints OLAP API enable TRUE TRUE

automatic measure

hints

_xsolapi_sql_dimension_hints OLAP API dimension



hints

_xsolapi_sql_hints OLAP API generic

hints

_xsolapi_sql_measure_hints OLAP API measure



hints

_xsolapi_sql_optimize OLAP API enable TRUE TRUE

optimization

_xsolapi_sql_prepare_stmt_cache_size OLAP API prepare 16 16

statement cache size

_xsolapi_sql_remove_columns OLAP API enable TRUE TRUE

remove unused

columns


optimizations

_xsolapi_sql_result_set_cache_size OLAP API result set 32 32

cache size

Mon Sep 05 page 68

Undocumented Oracle Parameters TEST Database
Parameter Description Session Value Instance Value

------------------------------------- -------------------- ------------- ---------------

_xsolapi_sql_symmetric_predicate OLAP API enable TRUE TRUE

symmetric predicate

for dimension groups

_xsolapi_sql_top_dimension_hints OLAP API top

dimension hints

_xsolapi_sql_top_measure_hints OLAP API top measure

hints

_xsolapi_sql_use_bind_variables OLAP API enable bind TRUE TRUE



variables

optimization

_xt_coverage external tables code none none

coverage parameter

_xt_trace external tables none none

trace parameter

_xtbuffer_size buffer size in KB 0 0

needed for

populate/query

operation

_xtts_allow_pre10 allow cross platform FALSE FALSE

for pre10 compatible

tablespace

_xtts_set_platform_info set cross platform FALSE FALSE

info during file

header read

_yield_check_interval interval to check 100000 100000

whether actses

should yield

918 rows selected.





Download 3.53 Mb.

Share with your friends:
1   2   3   4   5   6   7   8   9   ...   17




The database is protected by copyright ©ininet.org 2022
send message

    Main page