Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> DB Links/Cursors
Dear Oracle Users,
I have a cursor inside a stored procedure which
selects records from a remote database using
database links.
My question, is the result set stored in the
local database or when I ever do a fetch does
it go to the remote database to fetch the record?
I was hoping it builds the temporary table on the
local database, if that is the case can someone
explain why I am having this huge network traffic
between the local and remote databases.
Thank you for your responses.
Kittu.
Received on Thu Apr 01 1999 - 16:03:50 CST
![]() |
![]() |