Discussions

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

Bookmark and Share Get thread feed

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

    • Posted by: Val
    • Posted on: September 21 2004 14:34 EDT
    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
    Reply to this

    Threaded Messages (2)

  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
    Reply to this Reply to original

  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/
    Reply to this Reply to original