2.424 XML_PARAMS

XML_PARAMS lets you adjust the behavior for XMLType data.

Property Description

Parameter type

String

Syntax

XML_PARAMS = "parameter=value [, parameter=value ] ..."

Default value

None

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

If specified, Oracle recommends that multiple instances have the same value.

You can specify one of the following for parameter=value:

  • xml_default_storage_tbx=true

    Sets the default XMLType storage to Transportable Binary XML (TBX) when no storage type is explicitly specified. Starting with Oracle Database 23ai, this is the default and recommended storage type for all XMLType data, even if this parameter is not set. Note that Transportable Binary XML must be stored as Securefiles LOBs.

  • xml_default_storage_tbx=false

    Sets the default XMLType storage to Not-Transportable Binary XML (CSX) when no storage type is explicitly specified. This setting can be used as a workaround for applications that still rely on the CSX storage type. Not-Transportable Binary XML can be stored as Basicfiles LOBs or Securefiles LOBs.

Example:

ALTER SYSTEM SET XML_PARAMS = "xml_default_storage_tbx=true”;

Note:

This parameter is available starting with Oracle Database 23ai.