Re: Remote cursors (cursors across DB links)

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Wed, 30 May 2001 05:37:36 GMT
Message-ID: <20010530.5373692@y1032960.hae.hydro.com>

Does your cursor only use the remote table, or is it a join with a local

table as well ? In that case, you might eventually check the DRIVING SIT E
and NO MERGE hints.
And of course, as someone else said, you might have a look at snapshots

(materialized views).

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2001-05-29, 17:22:42, schreef mlm <not_at_listed.com> over het thema Rem ote
cursors (cursors across DB links):

> I need some advice regarding a PL/SQL procedure that creates a cursor

> against a table that is in another database. We have a DB link to the

> remote database, and I create this cursor using the @ sign to signify

> that the table is a remote table. Our site has a T1 connection to thi
s
> remote database, but the procedure runs very slowly. The procedure ru
ns
> for hours and I kill it before it completes.
> Thanks,
> Mike
Received on Wed May 30 2001 - 00:37:36 CDT