DBQLXMLPlanMemLimit - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Limits the amount of memory used for generating an XML version of a query plan when query logging is enabled using the WITH XMLPLAN option of BEGIN QUERY LOGGING.

Field Group

Performance

Valid Range

256 through 65536 KB

Default

8192 KB

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

The WITH XMLPLAN option of the BEGIN QUERY LOGGING statement causes the query plan for every non-cached DDL, DML, and DCL SQL statement to be logged as an XML document in the Database Query Log (DBQL). This document is stored in the DBC.DBQLXMLTbl system table.

DBQLXMLPlanMemLimit limits the amount of memory used to generate XML for each SQL request. Reducing the amount of memory used to generate XML plans can free up memory for other tasks, however, setting DBQLXMLPlanMemLimit to a value smaller than the default risks that generated XML plan documents will be incomplete.

EXPLAIN, INSERT EXPLAIN, and DUMP EXPLAIN statements are not logged.

Related Information

For more information on query logging, see Teradata Vantage™ - Database Administration, B035-1093 and Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.