www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
db.dba.vacuum
user_change_password
user_create
user_drop
user_get_option
user_grant_role
user_revoke_role
user_role_create
user_role_drop
user_set_option
user_set_qualifier
__dbf_set
cfg_item_count
cfg_item_name
cfg_item_value
cfg_section_count
cfg_section_name
cfg_write
checkpoint_interval
disconnect_user
fk_check_input_value...
key_estimate
log_enable
log_text
prof_enable
prof_sample
server_root
status
sys_lockdown
sys_stat
system
trace_status
user_set_password
virtuoso_ini_path
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

__dbf_set

Sets vector execution parameters.
__dbf_set (in flag_name varchar, outflag_value any);
Description

Sets at run time by a dba group user the vector execution parameters.

Parameters
flag_name – Name of the flag. For Configuring Vectored Execution, should be used the following values: Note: Only effective with Virtuoso 7.0 and later.
  • dc_batch_sz: flag for ini parameter VectorSize;
  • dc_max_batch_sz: flag for ini parameter MaxVectorSize;
  • enable_dyn_batch_sz: flag for ini parameter AdjustVectorSize;
  • enable_qp: flag for ini parameter ThreadsPerQuery;
  • aq_max_threads: flag for ini parameter AsyncQueueMaxThreads;
flag_value – Value of the flag.
Examples

Set the maximum number of outstanding parallel work units to 16:

SQL> __dbf_set ('enable_qp', 16);