SET_PARAMETER

The SET_PARAMETER procedure sets system-level parameters for index creation and for near real-time indexes.

Syntax

CTX_ADM.SET_PARAMETER(param_name IN VARCHAR2,
                      param_value IN VARCHAR2);

param_name

Specify the name of the parameter to set, which can be one of the following parameters:

• max_index_memory (maximum memory allowed for indexing)

• default_index_memory (default memory allocated for indexing)

• ctx_doc_key_type (default input key type for CTX_DOC procedures)

• auto_optimize (ENABLE or DISABLE for auto optimization)

• default_datastore (default datastore preference)

• default_filter_file (default filter preference for data stored in files)

• default_filter_text (default text filter preference)

• default_filter_binary (default binary filter preference)

• default_section_html (default html section group preference)

• default_section_xml (default xml section group preference)

• default_section_text (default text section group preference)

• default_lexer (default lexer preference)

• default_wordlist (default wordlist preference)

• default_stoplist (default stoplist preference)

• default_storage (default storage preference)

• default_ctxcat_lexer (default lexer preference for CTXCAT index)

• default_ctxcat_stoplist (default stoplist preference for CTXCAT index)

• default_ctxcat_storage (default CTXCAT index storage

• default_ctxcat_wordlist (default wordlist preference for CTXCAT index)

• default_ctxrule_lexer (default lexer for CTXRULE index)

• default_ctxrule_stoplist (default stoplist for CTXRULE index)

• default_ctxrule_storage (default storage for CTXRULE index)

• default_ctxrule_wordlist (default wordlist for CTXRULE index)

  See Also: To learn more about the default values for these parameters, see “System Parameters” in Oracle Text Indexing Elements

Note: log_directory (directory for CTX_OUTPUT files) and auto_optimize_logfile (the base file name for the auto optimization log file) can no longer be modified. Any call to the API is ignored for these parameters.

param_value

Specify the value to assign to the parameter. For max_index_memory and default_index_memory, the value you specify must have the following syntax:

number[K|M|G]

where K stands for kilobytes, M stands for megabytes, and G stands for gigabytes.

For each of the other parameters, specify the name of a preference to use as the default for indexing.

For auto_optimize, the value you specify must be either ENABLE or DISABLE. When you set this parameter to ENABLE, auto optimization jobs can be started. When you set this parameter to DISABLE, no auto optimization jobs can be started and all the currently-running optimization jobs are terminated.

Example

To modify the MAX_INDEX_MEMORY value:

exec ctx_adm.set_parameter('MAX_INDEX_MEMORY', 100G);

The memory parameter in the indexing statements can be as high as 256 GB (if the MAX_INDEX_MEMORY parameter is not explicitly specified to a lower value).

create index myindex1 on mytab(textcol) indextype is ctxsys.context parameters ('memory 256G');
exec ctx_ddl.sync_index(' myindex2', memory=> '256G');

Example

begin
  ctx_adm.set_parameter('default_lexer', 'my_lexer');
end;