SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance issue in printing cursor output

968517Dec 22 2015 — edited Dec 23 2015

Hi All,

I just come across a strange issue today that is while printing a refcursor output having 11 columns (1-varchar, 1-date, 9-numeric) and 230 rows. The cursor is populated with a dynamic sql using bind variables. If I execute the select query, it is giving the results in few seconds (hardly within 5). However while printing the refcursor it is not printing the data even after 15 MINS. The DB has more than 10GB of temp space. and no scheduled jobs are running in this instance.
I tried even by increasing the output buffer size and still the response is same. Kindly share me your experiences and thoughts. Thanks

var rForcastView refcursor;

Exec myProc(params, :rForecastView); --executed in 2-3 seconds

Print rForecastView; --not printing even after 15 mins*

Note: version Oracle 11g

Regards,

Vimal

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2016

Added on Dec 22 2015

#cursor

14 comments

3,000 views