FETCH FIRST 65001 ROWS ONLY OBIEE 11g
By Default, OBI renders only 65000 rows for a report. This value can be modified
to increase the performance.However, this would be a last option to optomize performance.
To change the setting for all User:
1. Log into EM
2. Go to "Business Intelligence"
3. Click on "coreapplication" -> "Capacity Management" Tab -> "Performance" tab
4. Under section "Maximum Number of Rows Processed when Rendering a Table View"
Lock and edit configuration
Enter appropriate value as per your business request
5. Restart services.
