2.75 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.