How to reduce the the burden/main memory on database if i am using refcursor to hold large data to increase performance.

Interview Candidate
May 25th, 2007
6
4974

First
Prev
Next
Last

Showing Answers 1 - 6 of 6 Answers

durgadas.menon
Profile Answers by durgadas.menon

Aug 13th, 2008

Unlike tables ref cursors do not store data. They act like mold to hold data during the execution of the piece of code so proper coding and use of bind variables can help decrease the burden of processing.

If the data is large then processing will surely consume more resources. You could try to partition the table from which the cursor is deriving its data and see if it helps.