Results 1 to 3 of 3

Thread: Oracle cursors

  1. #1
    Join Date
    Jul 2003
    Arlington, Texas

    Unanswered: Oracle cursors


    I have defined a cursor for an sql statement. When the
    number of attributes i select in the sql statement
    goes above 20 then the cursor fetch operation takes a long
    time. The number of rows i fetch is the same, it is only the number of attributes i select change.

    I would appreciate if someone can send a reply to the problem.

  2. #2
    Join Date
    Jul 2003
    I'll send you a reply if you send me your code.

    Also, how many total rows are in the table you are querying?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Nov 2002
    Desk, slightly south of keyboard
    I'm afraid there is no simple answer to your question, how Oracle performs it's work is dependant on many, many variables.

    This document will introduce you to the basics of it....

    Having written that (and believing I understand what Oracle gets up to) I am amazed by the performance mistakes Oracle can make.


Posting Permissions

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