Handling Large Resultset in Oracle (Scrollable Result Set)

Joined
Jan 9, 2009
Messages
5
Reaction score
0
Hi All, In my Application I am using OJB1.4 if I am doing some particular UI searches with pagination ,My memory usage is keep on increasing. how to reduce mem heap usage with Scrollable RS
It has been observed in UI searches on the particular pages,that the memory size can be made to increase by navigating the UI pages using Next, Last, Previous page navigation buttons.

Please suggest a solution or how to resolve the mem size increase problem with UI Search button.
When the UI Search button is used, the system creates a ScrollableResultSet. How can we stop the mem size from increasing
indefinitely with ScrollableResultSet.
Do we know how to solve this memory issue when executing large
resultset in Oracle.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,054
Latest member
TrimKetoBoost

Latest Threads

Top