Oracle hidden olap parameters Don Burleson

Note: Oracle hidden parameters are undocumented and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before placing them in your production environment.

Parameter Name                            Description

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

_olap_aggregate_buffer_size               OLAP Aggregate max buffer size

_olap_aggregate_child_fragment_size       OLAP Aggregate child fragment size

_olap_aggregate_child_max_size            OLAP Aggregate child list max size

_olap_aggregate_flags                     OLAP Aggregate debug flags

_olap_aggregate_function_cache_enabled    OLAP Aggregate function cache enabler

_olap_aggregate_function_merge_threshold  OLAP Aggregate function merge threshold

_olap_aggregate_max_thread_tuples         OLAP Aggregate max thread tuples creation

_olap_aggregate_min_buffer_size           OLAP Aggregate min buffer size

_olap_aggregate_min_thread_status         OLAP Aggregate minimum cardinality of dimensions for thread

_olap_aggregate_multipath_hier            OLAP Aggregate Multi-path Hierarhies enabled

_olap_aggregate_statlen_thresh            OLAP Aggregate status array usage threshold

_olap_aggregate_store_probability         OLAP Aggregate function storeback probability

_olap_aggregate_work_per_thread           OLAP Aggregate max work parents

_olap_aggregate_worklist_max              OLAP Aggregate max worklists generated at once

_olap_allocate_errorlog_format            OLAP Allocate Errorlog Format

_olap_allocate_errorlog_header            OLAP Allocate Errorlog Header format

_olap_continuous_trace_file               Specify TRUE to enable continuous OLAP tracing - otherwise only

_olap_dimsave_restore_cache_values        OLAP Dimsave restores cached dimension values

_olap_eif_export_lob_size                 OLAP EIF Export BLOB size

_olap_parallel_update_threshold           OLAP parallel update threshold in pages

_olap_poutlog_echo_to_eventlog            OLAP POutLog copy output to event log (tracefile)

_olap_sort_buffer_size                    OLAP Sort Buffer Size