2.436 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 AI Database 26ai, 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 AI Database 26ai.