Dear All,
I have simple SP which returns the result sets to UI using SYS_REFCURSOR, The questions are as follows
1) Is it possible to increase the data retrieval SPEED in SYS_REFCURSOR?
2) What memory uses SYS_REFCURSOR OR any possibility of increasing temp space or memory?
The issue is SP execution takes 30 seconds. But when the query alone executed it takes less than 2 secs.
Using Oracle 11g with Linux OS
Thanks,
ANA