_hcs_catalog_test_insert | Boolean | FALSE | yes | SESSION | Y | Y | | test catalog insert |
_hcs_disable_all_prune | Boolean | FALSE | yes | SESSION | Y | Y | | prune hierarchies pinned to ALL level |
_hcs_disable_all_qry_optz | Boolean | FALSE | yes | SESSION | Y | Y | | skip all query optimization on generated SQL |
_hcs_disable_av_jback_opt | Boolean | FALSE | yes | SESSION | Y | Y | | optimize analytic view query joinback |
_hcs_disable_av_sql_hint | Boolean | FALSE | yes | SESSION | Y | Y | | disable analytic view sql hint |
_hcs_disable_basetbl_transform | Boolean | FALSE | yes | SESSION | Y | Y | | disable base table transform |
_hcs_disable_bd_agg_opt | Boolean | FALSE | yes | SESSION | Y | Y | | optimize base data aggregation |
_hcs_disable_calc_dtm_to_out_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply move calc determined hier to output hier optimization |
_hcs_disable_calc_opt | Boolean | FALSE | yes | SESSION | Y | Y | | calc optimize |
_hcs_disable_calc_union_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable calc union optimization |
_hcs_disable_cell_qry_atr_prune_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply attribute prune optimization to cell query |
_hcs_disable_cell_qry_lvl_prune_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply level prune optimization to cell query |
_hcs_disable_cell_qry_mv_cache_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply mv cache optimization to cell query |
_hcs_disable_cell_qry_no_calc_nav_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply no calc navigation optimization to cell query |
_hcs_disable_cell_qry_no_out_data_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply no output data optimization to cell query |
_hcs_disable_col_prune_optz | Boolean | FALSE | yes | SESSION | Y | Y | | skip column pruning optimization on generated SQL |
_hcs_disable_dt_opt_cell_qry | Boolean | FALSE | yes | SESSION | Y | Y | | disable cell query optimizations for datatype queries |
_hcs_disable_dtmall_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable determine all optimization |
_hcs_disable_dup_nav_calc_opt | Boolean | FALSE | yes | SESSION | Y | Y | | duplicate navigation calc optimize |
_hcs_disable_dup_src_tbl_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply duplicate src table optimization |
_hcs_disable_exists_distinct | Boolean | FALSE | yes | SESSION | Y | Y | | no exists distinct |
_hcs_disable_filter_hierarchies | Boolean | FALSE | yes | SESSION | Y | Y | | filter hierarchies in hcs queries |
_hcs_disable_fltr_below_fltr_star_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply filter below filtered star optimization |
_hcs_disable_fltr_fact_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply filtered fact optimization |
_hcs_disable_fltr_hier_star_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply filtered hierarchy star optimization |
_hcs_disable_hier_join_map_nonnull | Boolean | FALSE | yes | SESSION | Y | Y | | no hier join map non null |
_hcs_disable_inline_tmpl_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply inline single ref top blocks optimization to cell query |
_hcs_disable_latest_compat_check | Boolean | FALSE | yes | SESSION | Y | Y | | skip compatibility check for latest compatible version |
_hcs_disable_level_ord | Boolean | FALSE | yes | SESSION | Y | Y | | prune away MAX(MAX(...)) around level order columns |
_hcs_disable_level_prune | Boolean | FALSE | yes | SESSION | Y | Y | | perform all level pruning |
_hcs_disable_level_prune_calc_data_joins | Boolean | FALSE | yes | SESSION | Y | Y | | perform level pruning for joins across calc data |
_hcs_disable_level_prune_hier_join | Boolean | FALSE | yes | SESSION | Y | Y | | perform level pruning from hierarchy joins |
_hcs_disable_level_prune_hier_qry | Boolean | FALSE | yes | SESSION | Y | Y | | perform level pruning from hierarchy queries |
_hcs_disable_level_prune_hierarchize | Boolean | FALSE | yes | SESSION | Y | Y | | level prune hierarchize |
_hcs_disable_level_prune_in_qry | Boolean | FALSE | yes | SESSION | Y | Y | | perform level pruning from level IN conditions |
_hcs_disable_level_prune_mbr_lookup | Boolean | FALSE | yes | SESSION | Y | Y | | perform level pruning in member lookup queries |
_hcs_disable_lvl_vis_lvs_no_tgts_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable level visible leaves no targets optimization |
_hcs_disable_materialize | Boolean | FALSE | yes | SESSION | Y | Y | | add materialize to result cache hint |
_hcs_disable_mdx_cache_hint | Boolean | FALSE | yes | SESSION | Y | Y | | generate hcs query mdx cache hints |
_hcs_disable_merge_fltr_star_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable merge filter star optimization |
_hcs_disable_mv_dense_join_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable move dense join optimization |
_hcs_disable_mv_reparse_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable mv reparse optimization |
_hcs_disable_mv_rewrite_check | Boolean | FALSE | yes | SESSION | Y | Y | | skip MV rewrite check when generating for ANALYTIC VIEW cache |
_hcs_disable_no_bdfltrd_opt | Boolean | FALSE | yes | SESSION | Y | Y | | apply no base data filtered optimization |
_hcs_disable_obj_cache_name | Boolean | FALSE | yes | SESSION | Y | Y | | Do not include the object number in an aggregate or level cache |
_hcs_disable_opt_cell_qry | Boolean | FALSE | yes | SESSION | Y | Y | | optimize cell query |
_hcs_disable_opt_estimate | Boolean | FALSE | yes | SESSION | Y | Y | | generate opt estimate hints |
_hcs_disable_prune_star_joins_opt | Boolean | FALSE | yes | SESSION | Y | Y | | skip prune star joins optimization |
_hcs_disable_prune_unslvd_star_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable prune unsolved star optimization |
_hcs_disable_remote_catalog | Boolean | FALSE | yes | SESSION | Y | Y | | disable remote catalog |
_hcs_disable_remoteaggr_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable remote aggr optimization |
_hcs_disable_result_cache_hint | Boolean | FALSE | yes | SESSION | Y | Y | | generate hcs query result cache hints |
_hcs_disable_rm_agg_tgt_n_mdxqry_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable remove aggregation targets from no mdx qry optimization |
_hcs_disable_rm_unused_withs_optz | Boolean | FALSE | yes | SESSION | Y | Y | | skip unused WITH element removal optimization on generated SQL |
_hcs_disable_smooth_descendants | Boolean | FALSE | yes | SESSION | Y | Y | | perform smooth descendants |
_hcs_disable_smooth_drill_all | Boolean | FALSE | yes | SESSION | Y | Y | | perform smooth drill all |
_hcs_disable_smooth_hierarchize | Boolean | FALSE | yes | SESSION | Y | Y | | perform hierarchize smoothing |
_hcs_disable_smooth_noop_descendants | Boolean | FALSE | yes | SESSION | Y | Y | | perform smooth no-op descendants |
_hcs_disable_smooth_remove_all | Boolean | FALSE | yes | SESSION | Y | Y | | smooth and remove ALL member |
_hcs_disable_use_cache_star_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable use cache star optimization |
_hcs_disable_vector_transform | Boolean | FALSE | yes | SESSION | Y | Y | | disable vector transform hint |
_hcs_disable_view_merge | Boolean | FALSE | yes | SESSION | Y | Y | | disable view merge |
_hcs_disable_vis_totals | Boolean | FALSE | yes | SESSION | Y | Y | | generate visual totals |
_hcs_disable_xjoin_tgt_depths_opt | Boolean | FALSE | yes | SESSION | Y | Y | | disable xjoin target depths optimization |
_hcs_enable_aggr_opt_estimate | Boolean | FALSE | yes | SESSION | Y | Y | | apply OPT_ESTIMATE hint to aggregation queries |
_hcs_enable_all_distinct | Boolean | FALSE | yes | SESSION | Y | Y | | use distinct instead of rownum=1 |
_hcs_enable_av_auto_cache | Boolean | TRUE | yes | SESSION | Y | Y | | enable AV auto-cache |
_hcs_enable_code_trc_call_stack | Boolean | FALSE | yes | SESSION | Y | Y | | enable code trace stack |
_hcs_enable_cube_join | Boolean | FALSE | yes | SESSION | Y | Y | | enable cube join |
_hcs_enable_error_on_no_transform | Boolean | FALSE | yes | SESSION | Y | Y | | enable error on no transform |
_hcs_enable_expose_with_expr | Boolean | FALSE | yes | SESSION | Y | Y | | expose internal with_expression |
_hcs_enable_fusion_code | Boolean | FALSE | yes | SESSION | Y | Y | | enable avtune legacy code path for Fusion |
_hcs_enable_in_mem_cdt_hint | Boolean | FALSE | yes | SESSION | Y | Y | | add hint opt_param('_in_memory_cdt', 'off') |
_hcs_enable_listagg_order | Boolean | FALSE | yes | SESSION | Y | Y | | enable listagg order |
_hcs_enable_mdx_cache_name_col | Boolean | FALSE | yes | SESSION | Y | Y | | add column for mdx cache name |
_hcs_enable_mdx_mv_gen | Boolean | FALSE | yes | SESSION | Y | Y | | enable mdx mv cache SQL generation |
_hcs_enable_mdx_sleep_after_pin | Boolean | FALSE | yes | SESSION | Y | Y | | sleep after pinning MDX caches |
_hcs_enable_mem_code_trc | Boolean | FALSE | yes | SESSION | Y | Y | | enable memory code tracing |
_hcs_enable_multi_parent_opt | Boolean | FALSE | yes | SESSION | Y | Y | | enable multi-parent optimization |
_hcs_enable_no_expand | Boolean | FALSE | yes | SESSION | Y | Y | | enable no expand hint |
_hcs_enable_parallel_hint | Boolean | FALSE | yes | SESSION | Y | Y | | include parallel hint in cell query |
_hcs_enable_pred_push | Boolean | TRUE | yes | SESSION | Y | Y | | enable optimizer AV predicate pushing via reparse |
_hcs_enable_time_code_trc | Boolean | FALSE | yes | SESSION | Y | Y | | enable timing code tracing |
_hcs_enable_unref_top_chk | Boolean | FALSE | yes | SESSION | Y | Y | | enable check for unref top blocks |
_hcs_enable_unsupported_calcs | Boolean | FALSE | yes | SESSION | Y | Y | | enable unsupported calcs |
_hcs_log_max_segments | Integer | 1000 | yes | SYSTEM imm. | Y | Y | | maximum number of HCS log segments, 0 for unlimited |
_hcs_log_segment_size | Integer | 10 | yes | SYSTEM imm. | Y | Y | | HCS log segment size in MB |
_hcs_logging | String | SUMMARY | yes | SESSION | Y | Y | | analytic view logging |
_hcs_mdx_sim_sga_alloc_err | String | NONE | yes | SESSION | Y | Y | | simulate mdx sga allocation error |
_hcs_mdx_sim_so_fail | Boolean | FALSE | yes | SESSION | Y | Y | | simulate state object failure |
_hcs_mdx_sleep_loc | String | NONE | yes | SESSION | Y | Y | | mdx location to sleep for testing |
_hcs_purge_dims_hiers | Boolean | FALSE | yes | SESSION | Y | Y | | purge dims and hiers on DDL operations |
_hcs_query_hint | String | | yes | SESSION | Y | Y | | query hint |
_hcs_raise_unexpected_catalog_error | Boolean | FALSE | yes | SESSION | Y | Y | | raise unexpected catalog error |
_hcs_remote_catalog_version | String | LATEST | yes | SESSION | Y | Y | | remote catalog version |
_hcs_sim_catalog_bad_user | Boolean | FALSE | yes | SESSION | Y | Y | | simulate catalog bad user |
_hcs_sim_catalog_error | Boolean | FALSE | yes | SESSION | Y | Y | | simulate catalog error |
_hcs_sim_no_addrow | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing add row metadata |
_hcs_sim_no_chgtrck | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing change tracking table metadata |
_hcs_sim_no_cont_obj | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing container_obj# metadata |
_hcs_sim_no_dense | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing dense metadata |
_hcs_sim_no_dim_outer_join | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing dimension outer join metadata |
_hcs_sim_no_joinrel | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing join relationship metadata |
_hcs_sim_no_qual_expr | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing qual_expr row in hcs_av_meas$ |
_hcs_sim_no_trstdcnst | Boolean | FALSE | yes | SESSION | Y | Y | | simulates missing trusted constraints metadata |
_hcs_sim_pga_expr_parse_err | Boolean | FALSE | yes | SESSION | Y | Y | | simulate PGA expression parse error |
_hcs_sim_sqlopt_err | Boolean | FALSE | yes | SESSION | Y | Y | | simulate sql optimization error |
_hcs_stats_max_card | Integer | 2000000 | yes | SESSION | Y | Y | | maximum value for stats cardinality |
_olap_adv_comp_stats_cc_precomp | Integer | 20 | yes | SESSION | Y | Y | | do additional predicate stats analysis for AW rowsource |
_olap_adv_comp_stats_max_rows | Integer | 100000 | yes | SESSION | Y | Y | | do additional predicate stats analysis for AW rowsource |
_olap_aggregate_buffer_size | Integer | 1048576 | yes | SESSION | Y | Y | | OLAP Aggregate max buffer size |
_olap_aggregate_flags | Integer | 0 | yes | SESSION | Y | Y | | OLAP Aggregate debug flags |
_olap_aggregate_function_cache_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP Aggregate function cache enabled |
_olap_aggregate_max_thread_tuples | Integer | 5000 | yes | SESSION | Y | Y | | OLAP Aggregate max thread tuples creation |
_olap_aggregate_min_buffer_size | Integer | 1024 | yes | SESSION | Y | Y | | OLAP Aggregate min buffer size |
_olap_aggregate_min_thread_status | Integer | 64 | yes | SESSION | Y | Y | | OLAP Aggregate minimum cardinality of dimensions for thread |
_olap_aggregate_multipath_hier | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP Aggregate Multi-path Hierarhies enabled |
_olap_aggregate_statlen_thresh | Integer | 1024 | yes | SESSION | Y | Y | | OLAP Aggregate status array usage threshold |
_olap_aggregate_work_per_thread | Integer | 1024 | yes | SESSION | Y | Y | | OLAP Aggregate max work parents |
_olap_aggregate_worklist_max | Integer | 5000 | yes | SESSION | Y | Y | | OLAP Aggregate max worklists generated at once |
_olap_allocate_errorlog_format | String | %8p %8y %8z %e (%n) | yes | SESSION | Y | Y | | OLAP Allocate Errorlog Format |
_olap_allocate_errorlog_header | String | Dim Source Basis %-8d %-8s %-8b Description -------- ------… | yes | SESSION | Y | Y | | OLAP Allocate Errorlog Header format |
_olap_analyze_max | Integer | 10000 | yes | SESSION | Y | Y | | OLAP DML ANALYZE command max cells to analyze |
_olap_continuous_trace_file | String | false | yes | SESSION | Y | Y | | OLAP logging definition |
_olap_dbgoutfile_echo_to_eventlog | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP DbgOutfile copy output to event log (tracefile) |
_olap_dimension_corehash_force | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP Dimension In-Core Hash Table Force |
_olap_dimension_corehash_large | Integer | 50000 | yes | SESSION | Y | Y | | OLAP Dimension In-Core Hash Table Large Threshold |
_olap_dimension_corehash_pressure | Integer | 90 | yes | SESSION | Y | Y | | OLAP Dimension In-Core Hash Table Pressure Threshold |
_olap_dimension_corehash_size | Integer | 30 | yes | SESSION | Y | Y | | OLAP Dimension In-Core Hash Table Maximum Memory Use |
_olap_eif_export_lob_size | Integer | 2147483647 | yes | SESSION | Y | Y | | OLAP EIF Export BLOB size |
_olap_lmgen_dim_size | Integer | 100 | yes | SESSION | Y | Y | | Limitmap generator dimension column size |
_olap_lmgen_meas_size | Integer | 1000 | yes | SESSION | Y | Y | | Limitmap generator measure column size |
_olap_object_hash_class | Integer | 3 | yes | SESSION | Y | Y | | OLAP Object Hash Table Class |
_olap_page_pool_expand_rate | Integer | 20 | yes | SESSION | Y | Y | | OLAP Page Pool Expand Rate |
_olap_page_pool_hi | Integer | 50 | yes | SESSION | Y | Y | | OLAP Page Pool High Watermark |
_olap_page_pool_hit_target | Integer | 100 | yes | SESSION | Y | Y | | OLAP Page Pool Hit Target |
_olap_page_pool_low | Integer | 262144 | yes | SESSION | Y | Y | | OLAP Page Pool Low Watermark |
_olap_page_pool_pressure | Integer | 90 | yes | SESSION | Y | Y | | OLAP Page Pool Pressure Threshold |
_olap_page_pool_shrink_rate | Integer | 50 | yes | SESSION | Y | Y | | OLAP Page Pool Shrink Rate |
_olap_parallel_update_server_num | Integer | 0 | yes | SESSION | Y | Y | | OLAP parallel update server count |
_olap_parallel_update_small_threshold | Integer | 1000 | yes | SESSION | Y | Y | | OLAP parallel update threshold for number of small pagespaces |
_olap_parallel_update_threshold | Integer | 1000 | yes | SESSION | Y | Y | | OLAP parallel update threshold in pages |
_olap_row_load_time_precision | String | DEFAULT | yes | SESSION | Y | Y | | OLAP Row Load Time Precision |
_olap_sesscache_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP Session Cache knob |
_olap_sort_buffer_pct | Integer | 10 | yes | SESSION | Y | Y | | OLAP Sort Buffer Size Percentage |
_olap_sort_buffer_size | Integer | 262144 | yes | SESSION | Y | Y | | OLAP Sort Buffer Size |
_olap_statbool_corebits | Integer | 20000000 | yes | SESSION | Y | Y | | OLAP Status Boolean max incore bits |
_olap_statbool_threshold | Integer | 8100 | yes | SESSION | Y | Y | | OLAP Status Boolean CBM threshold |
_olap_table_function_statistics | Boolean | FALSE | yes | SESSION | Y | Y | | Specify TRUE to output OLAP table function timed statistics trace |
_olap_wrap_errors | Boolean | FALSE | yes | SESSION | Y | Y | | Wrap error messages to OLAP outfile |
_olapi_history_retention | Boolean | FALSE | yes | SYSTEM imm. | N | Y | | enable olapi history retention |
_olapi_iface_object_history | Integer | 1000 | yes | STATIC | N | N | | enable olapi interface object history collection |
_olapi_iface_object_history_retention | Boolean | FALSE | yes | SYSTEM imm. | N | Y | | enable olapi interface object history retention |
_olapi_iface_operation_history_retention | Boolean | FALSE | yes | SYSTEM imm. | N | Y | | enable olapi interface operation history retention |
_olapi_interface_operation_history | Integer | 1000 | yes | STATIC | N | N | | enable olapi interface operation history collection |
_olapi_memory_operation_history | Integer | 1000 | yes | STATIC | N | N | | enable olapi memory alloc/free history collection |
_olapi_memory_operation_history_pause_at_seqno | Integer | 0 | yes | SYSTEM imm. | N | Y | | enable olapi memory alloc/free history collection pausing |
_olapi_memory_operation_history_retention | Boolean | FALSE | yes | SYSTEM imm. | N | Y | | enable olapi memory operation history retention |
_olapi_session_history | Integer | 300 | yes | STATIC | N | N | | enable olapi session history collection |
_olapi_session_history_retention | Boolean | FALSE | yes | SYSTEM imm. | N | Y | | enable olapi session history retention |
_xsolapi_auto_materialization_bound | Integer | 20 | yes | SESSION | Y | Y | | OLAP API lower bound for auto materialization. |
_xsolapi_auto_materialization_type | String | PRED_AND_RC | yes | SESSION | Y | Y | | OLAP API behavior for auto materialization |
_xsolapi_build_trace | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API output build info to trace file |
_xsolapi_debug_output | String | SUPPRESS | yes | SESSION | Y | Y | | OLAP API debug output disposition |
_xsolapi_densify_cubes | String | TABULAR | yes | SESSION | Y | Y | | OLAP API cube densification |
_xsolapi_dimension_group_creation | String | OVERFETCH | yes | SESSION | Y | Y | | OLAP API symmetric overfetch |
_xsolapi_dml_trace | String | | yes | SESSION | Y | Y | | OLAP API output dml commands and expressions to trace file |
_xsolapi_fetch_type | String | PARTIAL | yes | SESSION | Y | Y | | OLAP API fetch type |
_xsolapi_fix_vptrs | Boolean | TRUE | yes | SYSTEM imm. | N | Y | | OLAP API Enable vptr fixing logic in shared server mode |
_xsolapi_generate_with_clause | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API generates WITH clause? |
_xsolapi_hierarchy_value_type | String | unique | yes | SESSION | Y | Y | | OLAP API hierarchy value type |
_xsolapi_load_at_process_start | String | NEVER | yes | SESSION | Y | Y | | When to load OLAP API library at server process start |
_xsolapi_materialization_rowcache_min_rows_for_use | Integer | 1 | yes | SESSION | Y | Y | | OLAP API min number of rows required to use rowcache in query materialization |
_xsolapi_materialize_sources | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API Enable source materialization |
_xsolapi_metadata_reader_mode | String | DEFAULT | yes | SESSION | Y | Y | | OLAP API metadata reader mode |
_xsolapi_odbo_mode | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API uses ODBO mode? |
_xsolapi_opt_aw_position | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enables AW position and count optimization? |
_xsolapi_precompute_subquery | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API precomputes subqueries? |
_xsolapi_remove_columns_for_materialization | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API removes columns for materialization? |
_xsolapi_set_nls | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API sets NLS? |
_xsolapi_share_executors | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API share executors? |
_xsolapi_source_trace | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API output Source definitions to trace file |
_xsolapi_sql_all_multi_join_non_base_hints | String | | yes | SESSION | Y | Y | | OLAP API multi-join non-base hints |
_xsolapi_sql_all_non_base_hints | String | | yes | SESSION | Y | Y | | OLAP API non-base hints |
_xsolapi_sql_auto_dimension_hints | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API enable automatic dimension hints |
_xsolapi_sql_auto_measure_hints | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enable automatic measure hints |
_xsolapi_sql_dimension_hints | String | | yes | SESSION | Y | Y | | OLAP API dimension hints |
_xsolapi_sql_enable_aw_join | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enables AW join? |
_xsolapi_sql_enable_aw_qdr_merge | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enables AW QDR merge? |
_xsolapi_sql_hints | String | | yes | SESSION | Y | Y | | OLAP API generic hints |
_xsolapi_sql_measure_hints | String | | yes | SESSION | Y | Y | | OLAP API measure hints |
_xsolapi_sql_minus_threshold | Integer | 1000 | yes | SESSION | Y | Y | | OLAP API SQL MINUS threshold |
_xsolapi_sql_prepare_stmt_cache_size | Integer | 16 | yes | SESSION | Y | Y | | OLAP API prepare statement cache size |
_xsolapi_sql_remove_columns | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enable remove unused columns optimizations |
_xsolapi_sql_result_set_cache_size | Integer | 32 | yes | SESSION | Y | Y | | OLAP API result set cache size |
_xsolapi_sql_symmetric_predicate | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enable symmetric predicate for dimension groups |
_xsolapi_sql_top_dimension_hints | String | | yes | SESSION | Y | Y | | OLAP API top dimension hints |
_xsolapi_sql_top_measure_hints | String | | yes | SESSION | Y | Y | | OLAP API top measure hints |
_xsolapi_sql_use_bind_variables | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API enable bind variables optimization |
_xsolapi_stringify_order_levels | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API stringifies order levels? |
_xsolapi_support_mtm | Boolean | FALSE | yes | SESSION | Y | Y | | OLAP API MTM mapping classes supported? |
_xsolapi_suppression_aw_mask_threshold | Integer | 1000 | yes | SESSION | Y | Y | | OLAP API suppression AW mask threshold |
_xsolapi_suppression_chunk_size | Integer | 4000 | yes | SESSION | Y | Y | | OLAP API suppression chunk size |
_xsolapi_use_models | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API uses models? |
_xsolapi_use_olap_dml | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API uses OLAP DML? |
_xsolapi_use_olap_dml_for_rank | Boolean | TRUE | yes | SESSION | Y | Y | | OLAP API uses OLAP DML for rank?
|
No comments:
Post a Comment