Data Model Properties

The Runtime Configuration page lists the values of the data model properties. The values of the data model properties depend on the compute shape used for your instance.

Property	Description	Default
Maximum data size limit for data generation	Limits the size of XML data that can be generated by executing a data model.	500MB
Maximum sample data size limit	Limits the size of a sample data file that can be uploaded from the data model editor.	1MB
Enable Data Model scalable mode	Prevents out of memory conditions. When set to true, the data engine takes advantage of the disk space while processing data.	True
Enable Auto DB fetch size mode	Avoids out of memory conditions, but can significantly increase the processing time. This setting is recommended only for frequently processing complex queries of hundreds of columns. When set to true, the database fetch size is set at runtime according to the total number of columns and the total number of query columns in the dataset. Ignores the DB fetch size setting. This property overrides the data model-level database fetch size properties.	True
DB fetch size	Limits the database fetch size for a data model. This property value takes effect only when Enable Auto DB fetch size mode is set to False.	20 (rows)
SQL Query Timeout	Specifies the timeout value for SQL queries for scheduled reports.	600 seconds
Enable Data Model diagnostic	Writes the dataset details, memory, and SQL processing time information to the log file when set to true. Oracle recommends setting this property to true only for debugging purposes. If you enable this property, the processing time is increased.	False
Enable SQL Session Trace	Writes a SQL session trace log to the database when set to true for every SQL query that's processed. A database administrator can examine the log.	False
Enable SQL Pruning	Reduces the processing time and the memory usage, if you enable this property. Applies only to the Oracle Database queries that use Standard SQL. If your query returns many columns but only a subset are used by your report template, SQL pruning returns only those columns required by the template. SQL pruning is not applicable for PDF, Excel, and E-text template types.	False
Enable Data Chunking	Enables XML data chunking for individual data models, reports, and report jobs, if you set this property to true. If you set this property to true, specify an appropriate value for the Data Chunk Size property to process large and long-running reports.	False
Data Chunk Size	Specifies the data size for each data chunk. Applies only when the Enable Data Chunking property is set to true.	300MB
DV Data Row Limit	Limits the number of rows that can be retrieved from a dataset.	2000000
Trim Leading and Trailing Spaces From Parameter Value	Trims the leading and trailing spaces from the parameter values of data models.	True
Exclude Line Feed And Carriage Return for LOB	Excludes carriage returns and line feeds in the data, if you set this property to true.	False