No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

Driving site hint
Next thread: Will NESTED LOOP Operation use the space in TEMP tablespace ?
Prev thread: Which session is Using Which database link ?

Message Score Author Date
Hi All I am trying to pull data from remote tab...... Swastik Mohanty Aug 31, 2016, 22:06
Hi, I think that when your query only use a ...... Joël Péran Sep 01, 2016, 08:23
Crossref: http://www.orafaq.com/forum/t/2018...... Michel Cadot Sep 01, 2016, 10:33
thank You Michel,was trying to get answers from di...... Swastik Mohanty Sep 01, 2016, 10:59

Follow up by mail Click here

Subject: Driving site hint
Author: Swastik Mohanty, United Kingdom
Date: Aug 31, 2016, 22:06, 2466 days ago
Os info: OEL 6.4
Oracle info: 10g
Message: Hi All

I am trying to pull data from remote table via DBLINK and using bulk collect method for the same.

The table extractions are based on one to one basis without any joins.

Wanted to understand can driving site hint be useful?

If i run a explain plan ,it does not uses the driving siite Hint,so i am wondering why the optimiser is not using it

If i use it for a table extraction which has 12 MILLION RECS ,Will the optimiser use it.

Is there any restriction on single table extraction?Does driving site hint only work on remote table extractions javing joins only?

Please advise.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Driving site hint
Author: Joël Péran, France
Date: Sep 01, 2016, 08:23, 2466 days ago
Message: Hi,

I think that when your query only use a distant site, (ie SELECT ... FROM myTable@DistantSite), the optimizer just has one table to use so what would be the use of the hint ? Not logical.
When you have a local table and a distant one, you can mention that the distant one is the driving table by using the hint ; that seems more logical but I guess that if the optimizer choose not to use it, you should do as it does ...

Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Driving site hint
Author: Michel Cadot, France
Date: Sep 01, 2016, 10:33, 2466 days ago
Message:
Crossref:

http://www.orafaq.com/forum/t/201884/

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Driving site hint
Author: Swastik Mohanty, United Kingdom
Date: Sep 01, 2016, 10:59, 2466 days ago
Message: thank You Michel,was trying to get answers from different Forums :)

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here