Re: Huge result sets problem



Enosh Chang wrote:

Hi all:

My environment is Windows 2003 Enterprise x64 and Oracle DB 9.2.0.3. My
problem is that I use JDBC to get one resultset from one table which exceeds
1 million records and 100 bytes per record. I find there are so many page
faults and disk swapping heavy. But the physical free memory is large. I set
environment JAVA_OPTS=-Xmx 3072m -Xms 2048m, but it seems useless. How can I
do to tune its performance? Thanks!!

Best Regards

Don't do that. ( ;) * .5 )
Tell us the reason a Java client legitimately
needs to extract that data from the DBMS.
Performance starts by doing the work where the
data is.
Joe Weinstein at BEA Systems

.

Relevant Pages

  • Re: Access Oracle Objects via PLSQL from JDBC
    ... In oracle demos I couldn't find a such examples.... ... This example uses a JDBC thin client to call a PLSQL stored ... test.java - this calls the plsql and displays the resultset ... // JDBC Implementation specific connect string ...
    (comp.lang.java.programmer)
  • Huge result sets problem
    ... My environment is Windows 2003 Enterprise x64 and Oracle DB 9.2.0.3. ... problem is that I use JDBC to get one resultset from one table which exceeds ...
    (comp.lang.java.databases)
  • statement.executeUpdate(String sql) - not inserting results in correct order
    ... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... GRDPRODPWRMAX, GRDPRODPWRMIN," + ...
    (comp.lang.java.databases)
  • using ORACLE stored procedure in ASP.NET 2.0
    ... Anyone experienced building gridview in Oracle environment using stored ... Since the resultSet in SP is a REF CURSOR, I am not sure what Type I ... statementHandle, CommandBehavior behavior, ArrayList& ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Reg. MS SLQSRVER 2000 driver (sp 1) driver for jdbc
    ... How exactly are you populating the resultset? ... from a standalone JDBC program? ... it skips the first record. ...
    (microsoft.public.sqlserver.jdbcdriver)