Skip to Main Content
Forums

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!

Ref cursor performance issue

Abdul Nazar AliFeb 4 2020 — edited Feb 7 2020

Hi Team,

There is a performance issue found in ref cursor returning data from GTT table. The table has 32000 rows and it takes 3 mins to return result set from the procedure.

Is there a way to improve performance in ref cursor to return result set faster OR any other alternative solution to resolve the performance issue?

Kindly advise.

Using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Regds,

ANA
Comments
Post Details
Added on Feb 4 2020
18 comments
3,116 views