General System Parameters

When you install Oracle Text, in addition to the system-defined preferences, the following system parameters are set:

Table 45 General System Parameters

System Parameter Description
MAX_INDEX_MEMORY This is the maximum indexing memory that can be specified in the parameter clause of CREATE INDEX and ALTER INDEX. The maximum value for this parameter is 256 GB.
DEFAULT_INDEX_MEMORY

This is the default indexing memory used with CREATE INDEX and ALTER INDEX. The default value for this parameter is 64 MB.

Note:

Starting with 23.9 release, the default value for this parameter has been increased to 256 MB.
LOG_DIRECTORY This is the directory for CTX_OUTPUT log files.
CTX_DOC_KEY_TYPE

This is the default input key type, either ROWID or PRIMARY_KEY, for the CTX_DOC procedures. Set to ROWID at install time.

See Also: CTX_DOC.SET_KEY_TYPE.

View system defaults by querying the CTX_PARAMETERS view. Change defaults using the CTX_ADM.SET_PARAMETER procedure.