Its 65,000 rows
For more you have configure if u r less than obiee v1.6
184.108.40.206 Manually Configuring Settings for Data in Views
also you can do it via weblogic EM
login to Enterprise manager 11g - > buisness intelligence -> coreapplication - >Capacity Management - > Performance
- > in the left section you can see : Maximum Number of Rows Processed when Rendering a Table View Maximum Number of Rows to Download Maximum Number of Rows Per Page to Include
Before doing it , just "Lock and Edit Configuration" and after changing "Activate changes" and restart all services .