RE: DB Links

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 23 Sep 2004 08:27:11 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F8A4@exchsen0a1ma>

Yechial,

Can you give the syntax of the hint "driving site"? Sounds like something I'd like to try!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Yechiel Adar [mailto:adar76_at_inter.net.il] Sent: Thursday, September 23, 2004 9:08 AM To: Oracle-L (E-mail)
Subject: Re: DB Links

Hello Kevin

I just spent a week + with a tar on exactly this problem. We upgraded a database from oracle 8.16 to 9.2.0.5. We had one query where the user joined data from 2 other databases. The run time jumped from 0.1 seconds to 3.5 minutes. I checked and found that Oracle did FTS on one remote database and then joined it to the three records fetched from the other remote database.

I finally used hint driving_site to execute the query on the remote database and the time dropped back to 0.1 seconds.

Yechiel Adar
Mehish

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 23 2004 - 07:22:48 CDT