FETCH FIRST 65001 ROWS ONLY OBIEE 11g

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.