Cursor Fetch Over Database Link?
173651Apr 20 2007 — edited Apr 23 2007We have a view that does a simple select over a database link. Running a select against this view returns in a couple of seconds. If we put the same SQL in a cursor, it takes over 3 minutes to return!
I have an idea as to why it's taking so much longer when in a cursor, but I'd like to hear from the experts.
Can someone explain why this is happening, and if there's any way to speed up the select when in a cursor?
Thanks in advance!