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!

DRIVING_SITE( ) Hint

user32322435Aug 26 2009 — edited Aug 26 2009

Hi All,

I have a procedure that fetch data from a remote database. The dblink is used multiple time which affected the performance. I tried the DRIVING_SITE(remote or local) hint, and it significantly improved the performance.

Just wondering if I can use the same hint if I have only one table residing in the remote server? Can I use the hint asking to perform the calcualtions in the local server ratther than the remote server.

Please advise me on this

Thanks in advance.

Appreciate your help!

Thanks
Bob

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2009

Added on Aug 26 2009

4 comments

2,190 views