How do I optimize BI Publisher settings to reduce issues with runtime memory and data export?
You can optimize BI Publisher settings in the administrative console of BI Publisher. Oracle recommends updating the configuration settings if you're facing runtime memory errors or issues with exporting reporting data. Setting your configuration above our recommendations can lead to degradation of services and potential issues with BI Publisher reporting capabilities.
To make updates, sign in to the XMLPServer as a user with administrator permissions and navigate to:
You can update the following configurations settings:
- Maximum Report Data Size for Online Reports
- Default Configuration is 300MB
- Configuration can be updated up to 1GB
- Free Memory Threshold
- Default Configuration is 500MB
- Configuration can be updated up to 2GB
- Maximum Rows for CSV Output
- Default Configuration is 1,000,000 rows
- Configuration can be updated up to 2,000,000 rows
- Maximum Data Size Limit For Data Generation
- Default Configuration is 500MB
- Configuration can be updated up to 2GB
- SQL Query Timeout
- Default Configuration is 600 (seconds)
- Configuration can be updated up to 1800 (seconds)