RE: DB Links
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'adar76@xxxxxxxxxxxx'" <adar76@xxxxxxxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Sep 2004 08:27:11 -0400
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@xxxxxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
