DATALAKE_ACCELERATOR_CONFIG

DATALAKE_ACCELERATOR_CONFIG allows you to configure Data Lake Accelerator (DLA).

Note: This parameter is valid only for Oracle Autonomous AI Database Serverless. On other types of Oracle databases, the value of this parameter is ignored.

Property	Description
Parameter type	String
Syntax	DATALAKE_ACCELERATOR_CONFIG = "engage:{auto|always}"
Default value	None
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No

You can use this parameter to configure DLA to bypass offload threshold checks and always use a DLA cluster for ORACLE_BIGDATA external table queries.

Values:

• engage:auto - Perform offload threshold checks and use a DLA cluster for queries, when necessary. This setting is equivalent to having no setting for this parameter (the default).

• engage:always - Bypass offload threshold checks and always use a DLA cluster for queries.

Note: This parameter is available starting with Oracle AI Database 26ai, Release Update 23.26.3.