_cell_fast_file_create | Boolean | TRUE | yes | SESSION | Y | Y | | Allow optimized file creation path for Cells |
_cell_fast_file_restore | Boolean | TRUE | yes | SESSION | Y | Y | | Allow optimized rman restore for Cells |
_cell_file_format_chunk_size | Integer | 0 | yes | SESSION | Y | Y | | Cell file format chunk size in MB |
_cell_index_scan_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | enable CELL processing of index FFS |
_cell_iot_scan_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | enable CELL processing of IOT FFS |
_cell_materialize_all_expressions | Boolean | FALSE | yes | SESSION | Y | Y | | Force materialization of all offloadable expressions on the cells |
_cell_materialize_virtual_columns | Boolean | TRUE | yes | SESSION | Y | Y | | enable offload of expressions underlying virtual columns to cells |
_cell_metadata_compression | String | AUTO | yes | SESSION | Y | Y | | Cell metadata compression strategy |
_cell_object_expiration_hours | Integer | 24 | yes | STATIC | N | N | | flashcache object expiration timeout |
_cell_offload_capabilities_enabled | Integer | 1 | yes | SESSION | Y | Y | | specifies capability table to load |
_cell_offload_complex_processing | Boolean | TRUE | yes | SESSION | Y | Y | | enable complex SQL processing offload to cells |
_cell_offload_expressions | Boolean | TRUE | yes | SESSION | Y | Y | | enable offload of expressions to cells |
_cell_offload_grand_total | Boolean | TRUE | yes | SESSION | Y | Y | | allow offload of grand total aggregations |
_cell_offload_hybrid_processing | Boolean | TRUE | yes | SESSION | Y | Y | | enable hybrid SQL processing offload to cells |
_cell_offload_hybridcolumnar | Boolean | TRUE | yes | SESSION | Y | Y | | Query offloading of hybrid columnar compressed tables to exadata |
_cell_offload_predicate_reordering_enabled | Boolean | FALSE | yes | SESSION | Y | Y | | enable out-of-order SQL processing offload to cells |
_cell_offload_sys_context | Boolean | TRUE | yes | SESSION | Y | Y | | enable offload of SYS_CONTEXT evaluation to cells |
_cell_offload_timezone | Boolean | TRUE | yes | SESSION | Y | Y | | enable timezone related SQL processing offload to cells |
_cell_offload_vector | Boolean | TRUE | yes | SESSION | Y | Y | | Query offloading of vector operators to exadata |
_cell_offload_vector_groupby | Boolean | TRUE | yes | SESSION | Y | Y | | enable SQL processing offload of vector group by |
_cell_offload_vector_groupby_external | Boolean | TRUE | yes | SESSION | Y | Y | | enable cell offload of vector group by with external tables |
_cell_offload_vector_groupby_fact_key | Boolean | TRUE | yes | SESSION | Y | Y | | enable cell offload of vector group by with fact grouping keys |
_cell_offload_vector_groupby_force | Boolean | FALSE | yes | SESSION | Y | Y | | force offload of vector group by |
_cell_offload_vector_groupby_withnojoin | Boolean | TRUE | yes | SESSION | Y | Y | | allow offload of vector group by without joins |
_cell_offload_virtual_columns | Boolean | TRUE | yes | SESSION | Y | Y | | enable offload of predicates on virtual columns to cells |
_cell_range_scan_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | enable CELL processing of index range scans |
_cell_storidx_minmax_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | enable Storage Index Min/Max optimization on the cells |
_cell_storidx_mode | String | EVA | yes | SESSION | Y | Y | | Cell Storage Index mode |
_cell_trace_size | Integer | 0 | yes | SESSION | Y | Y | | max trace size in bytes shipped back to server per filtering task |
_cellcache_clause_default | String | | yes | SESSION | Y | Y | | Default cellcache clause for new tables |
_cellcache_default_flags | Integer | 2 | yes | SESSION | Y | Y | | Default flags based on cellcache_clause_default |
_cellcache_default_new | Boolean | FALSE | yes | SESSION | Y | Y | | Force cellcache on new tables |
_kcfis_automem_level | Integer | 1 | yes | SESSION | Y | Y | | Set auto memory management control for kcfis memory allocation |
_kcfis_block_dump_level | Integer | 0 | yes | SESSION | Y | Y | | Smart IO block dump level |
_kcfis_byteswap_opt_disabled | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use byte swapping optimization on the storage cell |
_kcfis_caching_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | enable kcfis intra-scan session caching |
_kcfis_cell_passthru_dataonly | Boolean | TRUE | yes | SESSION | Y | Y | | Allow dataonly passthru for smart scan |
_kcfis_cell_passthru_enabled | Boolean | FALSE | yes | SESSION | Y | Y | | Do not perform smart IO filtering on the cell |
_kcfis_cell_passthru_fromcpu_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Enable automatic passthru mode when cell CPU util is too high |
_kcfis_cellcache_disabled | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use cellcache rewrite optimization on the storage cell |
_kcfis_celloflsrv_passthru_enabled | Boolean | FALSE | yes | SESSION | Y | Y | | Enable offload server usage for passthru operations |
_kcfis_celloflsrv_usage_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Enable offload server usage for offload operations |
_kcfis_combine_md_maps_payload | Integer | 1 | yes | SESSION | Y | Y | | enable combining MD and MAPs in single payload |
_kcfis_control1 | Integer | 0 | yes | SESSION | Y | Y | | Kcfis control1 |
_kcfis_control2 | Integer | 0 | yes | SESSION | Y | Y | | Kcfis control2 |
_kcfis_control3 | Integer | 0 | yes | SESSION | Y | Y | | Kcfis control3 |
_kcfis_control4 | Integer | 0 | yes | SESSION | Y | Y | | Kcfis control4 |
_kcfis_control5 | Integer | 0 | yes | SESSION | Y | Y | | Kcfis control5 |
_kcfis_control6 | Integer | 0 | yes | SESSION | Y | Y | | Kcfis control6 |
_kcfis_disable_platform_decryption | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use platform-specific decryption on the storage cell |
_kcfis_dump_corrupt_block | Boolean | TRUE | yes | SESSION | Y | Y | | Dump any corrupt blocks found during smart IO |
_kcfis_fast_response_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Enable smart scan optimization for fast response (first rows) |
_kcfis_fast_response_initiosize | Integer | 2 | yes | SESSION | Y | Y | | Fast response - The size of the first IO in logical blocks |
_kcfis_fast_response_iosizemult | Integer | 4 | yes | SESSION | Y | Y | | Fast response - (next IO size = current IO size * this parameter) |
_kcfis_fast_response_threshold | Integer | 1048576 | yes | SESSION | Y | Y | | Fast response - the number of IOs after which smartIO is used |
_kcfis_fastfileinit_disabled | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use ffi during file creation |
_kcfis_fault_control | Integer | 0 | yes | STATIC | N | N | | Fault Injection Control |
_kcfis_fctempopt_mode | Integer | 1 | yes | SESSION | Y | Y | | KCFIS FC Temp Drop FC Optimization Control |
_kcfis_io_prefetch_size | Integer | 8 | yes | SESSION | Y | Y | | Smart IO prefetch size for a cell |
_kcfis_ioreqs_throttle_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Enable Smart IO requests throttling |
_kcfis_ivfscan_fd_max_cache_sz | Integer | 100 | yes | SESSION | Y | Y | | Number of IVF scan FDs cached |
_kcfis_ivfscan_fd_max_num_reuse | Integer | 50 | yes | SESSION | Y | Y | | Number of times IVF scan FDs are reused |
_kcfis_ivfscan_opt_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | enable IVF scan optimizations |
_kcfis_kept_in_cellfc_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Enable usage of cellsrv flash cache for kept objects |
_kcfis_large_payload_enabled | Boolean | FALSE | yes | SESSION | Y | Y | | enable large payload to be passed to cellsrv |
_kcfis_largemd_bfquota_kb | Integer | 16384 | yes | SESSION | Y | Y | | Smart IO operation bloom filter metadata size in KBs |
_kcfis_largemd_compressed_kb | Integer | 20480 | yes | SESSION | Y | Y | | Smart IO operation maximum compressed metadata size in KBs |
_kcfis_largemd_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Smart IO operation large metadata supported enabled |
_kcfis_max_cached_sessions | Integer | 10 | yes | SESSION | Y | Y | | Sets the maximum number of kcfis sessions cached |
_kcfis_max_ioctl_buffers | Integer | 100 | yes | SESSION | Y | Y | | Sets the maximum number of IOCTL buffers in kcfis |
_kcfis_max_out_translations | Integer | 5000 | yes | SESSION | Y | Y | | Sets the maximum number of outstanding translations in kcfis |
_kcfis_nonkept_in_cellfc_enabled | Boolean | FALSE | yes | SESSION | Y | Y | | Enable use of cellsrv flash cache for non-kept objects |
_kcfis_oss_io_size | Integer | 0 | yes | SESSION | Y | Y | | KCFIS OSS I/O size |
_kcfis_partner_read_enabled | Boolean | TRUE | yes | SESSION | Y | Y | | Smart IO operation partner read enabled |
_kcfis_pmem_enabled | Boolean | TRUE | yes | STATIC | N | N | | RDMA Persistent Memory support enabled |
_kcfis_qm_prioritize_sys_plan | Boolean | TRUE | yes | SESSION | Y | Y | | Prioritize Quarantine Manager system plan |
_kcfis_qm_user_plan_name | String | | yes | SESSION | Y | Y | | Quarantine Manager user plan name |
_kcfis_rdbms_blockio_enabled | Boolean | FALSE | yes | SESSION | Y | Y | | Use block IO instead of smart IO in the smart IO module on RDBMS |
_kcfis_read_buffer_limit | Integer | 0 | yes | SESSION | Y | Y | | KCFIS Read Buffer (per session) memory limit in bytes |
_kcfis_spawn_debugger | Boolean | FALSE | yes | SESSION | Y | Y | | Decides whether to spawn the debugger at kcfis initialize |
_kcfis_stats_level | Integer | 0 | yes | SESSION | Y | Y | | sets kcfis stats level |
_kcfis_storageidx_diag_mode | Integer | 0 | yes | SESSION | Y | Y | | Debug mode for storage index on the cell |
_kcfis_storageidx_disabled | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use storage index optimization on the storage cell |
_kcfis_storageidx_set_membership_disabled | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use set membership optimization on the storage cell |
_kcfis_storageidx_xtss_disabled | Boolean | FALSE | yes | SESSION | Y | Y | | Don't use storage index optimization on the storage cell for XTSS |
_kcfis_test_control1 | Integer | 0 | yes | SESSION | Y | Y | | kcfis tst control1 |
_kcfis_trace_bucket_size | Integer | 131072 | yes | SESSION | Y | Y | | KCFIS tracing bucket size in bytes |
_kcfis_xtgran_prefetch_count | Integer | 1 | yes | SESSION | Y | Y | | External Table Smart Scan granule prefetch count |
No comments:
Post a Comment