No question at this time
DBA Top 10
1 A. Kavsek 10900
2 M. Cadot 6200
3 P. Wisse 5000
4 B. Vroman 4500
5 T. Boles 2200
6 . Lauri 2000
7 J. Schnackenberg 1300
8 J. Péran 1100
9 R. Pattyn 700
10 T. P 500
10 G. Graham 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48425
Total active users1512
Act. users last 24h8
Act. users last hour2
Registered user hits last week172
Registered user hits last month818
Go up

query is picking a bad execution plan
Next thread: Options for gathering statistics for datawarehouse tables
Prev thread: need to import last 2 days updated records

Message Score Author Date
Hi Masters, My query is picking a bad execution...... javed akhtar Nov 21, 2018, 14:25
Hi, What is for you a "bad execution plan"? H...... Lauri Nov 21, 2018, 15:00
Hello Javed, Oracle 11.2? Hmmm, time to move, i...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Nov 21, 2018, 16:04
thanks... javed akhtar Nov 22, 2018, 06:40

Follow up by mail Click here


Subject: query is picking a bad execution plan
Author: javed akhtar, India
Date: Nov 21, 2018, 14:25, 302 days ago
Os info: linux
Oracle info: 11.2
Message: Hi Masters,

My query is picking a bad execution plan , how to fix it to use the good execution plan available.


thanks,
javed
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-query is picking a bad execution plan
Author: Lauri, Netherlands
Date: Nov 21, 2018, 15:00, 302 days ago
Message: Hi,

What is for you a "bad execution plan"?
How do you quantify it?
We can only help you if you give more details.

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

Subject: Re: query is picking a bad execution plan
Author: Bruno Vroman, Belgium
Date: Nov 21, 2018, 16:04, 302 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello Javed,

Oracle 11.2? Hmmm, time to move, isn't it?

I put "query picking bad execution plan oracle" in the search box of Google and guess what... The first hit matches nearly exactly your own sentence: it is:
  My query is picking a bad execution plan , how to fix it to use the good execution plan available ( using Oracle baselines ) ?

Is this a coincidence? ...

Best regards,

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

Subject: Re: query is picking a bad execution plan
Author: javed akhtar, India
Date: Nov 22, 2018, 06:40, 302 days ago
Message: thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here