Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Hyderabad
    Posts
    14

    Unhappy Unanswered: Bulk collect Vs cursors

    Hi

    Can any one tell whats the diffrence between Bulk collect and cursors? In terms of working and performance.

    Thanks in advance
    Harikishan

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    In a few words: Oracle uses two engines to process PL/SQL code. All procedural code is handled by the PL/SQL engine while all SQL is handled by the SQL engine. There is an overhead associated with each context switch between the two engines. If PL/SQL code loops through a collection performing the same DML operation for each item in the collection it is possible to reduce context switches by bulk binding the whole collection to the DML statement in one operation.

    The whole text (with examples) can be found here.

  3. #3
    Join Date
    Dec 2003
    Location
    Hyderabad
    Posts
    14

    Smile Thank you

    Quote Originally Posted by Littlefoot
    In a few words: Oracle uses two engines to process PL/SQL code. All procedural code is handled by the PL/SQL engine while all SQL is handled by the SQL engine. There is an overhead associated with each context switch between the two engines. If PL/SQL code loops through a collection performing the same DML operation for each item in the collection it is possible to reduce context switches by bulk binding the whole collection to the DML statement in one operation.

    The whole text (with examples) can be found here.
    Thanks buddy!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •