Handling Large Resultset in Oracle (Scrollable Result Set)

Discussion in 'Java' started by Tincy, Jan 13, 2009.

  1. Tincy

    Tincy

    Joined:
    Jan 9, 2009
    Messages:
    5
    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.
     
    Tincy, Jan 13, 2009
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matrix
    Replies:
    0
    Views:
    594
    Matrix
    Apr 1, 2004
  2. =?ISO-8859-1?Q?Thomas_Gagn=E9?=
    Replies:
    1
    Views:
    498
    Lee Fesperman
    Nov 21, 2003
  3. Tincy

    Scrollable Result Set

    Tincy, Jan 9, 2009, in forum: Java
    Replies:
    0
    Views:
    369
    Tincy
    Jan 9, 2009
  4. Tincy
    Replies:
    0
    Views:
    397
    Tincy
    Jan 12, 2009
  5. Michael Tan
    Replies:
    32
    Views:
    1,054
    Ara.T.Howard
    Jul 21, 2005
Loading...

Share This Page