Does "Bulk Collect" feature of Oracle Help?

Discussions

Performance and scalability: Does "Bulk Collect" feature of Oracle Help?

  1. Does "Bulk Collect" feature of Oracle Help? (2 messages)

    HI,

    Has anyone used the "Bulk Collect" feature?

    We have an Oracle 8i database, and a lot of data to be queried and shown in reports. The current performance is very slow. Would doing a bulk collect help? Any tips??

    Thank you
  2. Does "Bulk Collect" feature of Oracle Help?[ Go to top ]

    But how are you accessing the data - SQL*Net, JDBC, ODBC?
    In any case you shoudl always look at doing an array fetch reather than single row fetches, that will make a huge difference to preformance
  3. Does "Bulk Collect" feature of Oracle Help?[ Go to top ]

    You can reduce the round trips to database by customizing the prefetch size.

    This is available in Oracle JDBC driver version 9.0.x

    http://download-west.oracle.com/docs/cd/A91202_01/901_doc/java.901/a90211/oraperf.htm#1002425

    regards
    Debu Panda
    http://radio.weblogs.com/0135826/