To further extend the discussion on rownum

I need 500 to 600 of 100000 records selected displayed on my page . The user can naviaget through the pages in increments of 100 rows .

here 100000 is the total number of records
of which I am displaying 500 - 600
ordered on some column ,


What is the optimal solution here?
We use scrollable result set in Java . But I hear that in the above case all 100000 records have to be transfered across the wire .
Is it better to d two queries one for the details of the rows and other for count ?

Someone suggested that inline views are very slow and degrades performance. Is this true ?