Home » RDBMS Server » Performance Tuning » wrong execution plan
wrong execution plan [message #300520] Fri, 15 February 2008 14:30 Go to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi
i want to know the execution plan i have attached is a wrong execution plan. i post my query along with the execution plan. but i didnt get any updates from you.
so please tell me the execution plan is wrong
please reply ...

Re: wrong execution plan [message #300522 is a reply to message #300520] Fri, 15 February 2008 14:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I do not understand what you are trying to say.
>>so please tell me the execution plan is wrong
Are you asking what is wrong with the plan?
Re: wrong execution plan [message #300525 is a reply to message #300520] Fri, 15 February 2008 14:45 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Mahesh,
I posted my query before. i got the reply from your side that tkprof report is not of this query. i was not sure since tkprof was generated by one of my colleague. again i post a reply help me in tuning the query with the help explain plan. but the same reply came again after i posted 2-3 reply. atleast tell me what the problem is???

Hi everybody,
the query is runing slow which was running fine. so clients is facing a problem. as this is my new client i have only access to PROD server clould any body look into this please help me in tuning this query i need a expert advice on this. i have made several assumptions that my query is not well ordered . table has lots of chain aount so i need to reorg the table.please explain me what to tune and where query is wrong. please help me in tuning this query.
i have attached the query , execution plan and tkprof.
thanks in advance,
Daniesh



Attachment: NewExcPlanTime.txt
(Size: 54.14KB, Downloaded 11 time(s))

Report message to a moderator



Re: need help in tuning this query [message #300171 is a reply to message #300111 ] Thu, 14 February 2008 08:42
michael_bialik
Messages: 388
Registered: July 2006 Senior Member add to buddy list
ignore all messages by this user


Your TKPROF does not contain any information about the query itself.

Report message to a moderator



Re: need help in tuning this query [message #300187 is a reply to message #300171 ] Thu, 14 February 2008 09:09
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

thank you very much for quivk respnse.i have attached a execution plan will it help us in tuning the query.if please help me in tuning this query.i will talk about tkprof to my client.

Thanks,
Daniesh
Report message to a moderator



Re: need help in tuning this query [message #300196 is a reply to message #300187 ] Thu, 14 February 2008 10:09
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

Hi Michael,
please let me know that execution plan can help in tuning this query. i guess by seeing the execution plan that i have to go for ordered hint but i dont know to tune nested loops and range scan.

Thanks ,
Daniesh
Report message to a moderator



Re: need help in tuning this query [message #300264 is a reply to message #300196 ] Thu, 14 February 2008 15:42
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

Dear Michael,
i have generated execution for my query
it will help in tuning the query. could you please look into and explain this query is taking lots of time. please help me......

i have attached the new execution plan.

Thanks in advance,
Daniesh

Attachment: NewExcPlanTime.txt
(Size: 10.10KB, Downloaded 9 time(s))

Report message to a moderator



Re: need help in tuning this query [message #300298 is a reply to message #300171 ] Thu, 14 February 2008 23:08
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

HI MICHAEL,
i have attached a execution plan could you please look into it
and help me in tuning the query. please look into this.

Thanks ,
Daniesh

Attachment: NewExcPlanTime.txt
(Size: 10.10KB, Downloaded 2 time(s))

sql tuning [message #300482] Fri, 15 February 2008 11:29
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

Hi Gurus,
i have generated a execution plan for the query. my query runnning very slow. please could anybody help me in tuning this query.

Attachment: NewExcPlanTime.txt
(Size: 10.11KB, Downloaded 7 time(s))

Report message to a moderator



Re: sql tuning [message #300485 is a reply to message #300482 ] Fri, 15 February 2008 11:41
anacedent
Messages: 4197
Registered: July 2005
Location: surf meets turf in SoCal Senior Member add to buddy list
ignore all messages by this user


What is different between this SQL in this post & in
http://www.orafaq.com/forum/t/97270/74940/
Report message to a moderator



Re: sql tuning [message #300486 is a reply to message #300485 ] Fri, 15 February 2008 11:44
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

may the Tkprof is not of this query but the exection plan i have generated so i am very much sure that execution belongs to this query.

Thanks,
Daniesh
Report message to a moderator



Re: sql tuning [message #300495 is a reply to message #300486 ] Fri, 15 February 2008 12:20
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

Hi Anacedent,
Michael told me that Tkprof report doesnt belong to this query
even i was not sure it was generated by my colleague but the execution plan is generated by me. so i am sure that execution plan belong to this query.
could you please tell me are you looking into it so that i can update you.
Report message to a moderator



Re: sql tuning [message #300496 is a reply to message #300495 ] Fri, 15 February 2008 12:27
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

could you please look into it. i have certain assumptioms about it.which i like to share with you.i checked the clutering factor and blocks . as oracle suggets that
If the value of this CF(clustering Factor) is near to the number of blocks,
then the table is very well ordered with respect to the index.
from the below result, i can say the query is well orderd.

SQL> select blocks from dba_tables
2 where table_name ='PBM_CLAIM';

BLOCKS
----------
874156

SQL> select clustering_factor from dba_indexes
2 where index_name='CLAIM_GROUP_FK_I';

CLUSTERING_FACTOR
-----------------
9912591
u can see the difference between the two. i came to the conclusion that my query is not well ordered

my 2nd assumtiom is that



Report message to a moderator



Re: sql tuning [message #300498 is a reply to message #300495 ] Fri, 15 February 2008 12:33
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

hi ,
could any body update me that anybody is looking into it
Report message to a moderator



Re: sql tuning [message #300514 is a reply to message #300482 ] Fri, 15 February 2008 13:20
daniesh.shaikh@gmail.com
Messages: 12
Registered: February 2008
Location: india Junior Member

please update me is anybody looking into it.

i have pasted my post if you will see it you will get a better idea what i want to say????
please help me in tuning this query..

Thanks,
Daniesh



Re: wrong execution plan [message #300528 is a reply to message #300520] Fri, 15 February 2008 15:06 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Mahesh,
Any updated on this
Re: wrong execution plan [message #300535 is a reply to message #300520] Fri, 15 February 2008 15:24 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
hi Mahesh,
I want to know the explain plan which i sent is belong to the query.


Thanks ,
Daniesh
Re: wrong execution plan [message #300537 is a reply to message #300520] Fri, 15 February 2008 15:30 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
i think i will not get any reply from you guys
sorry for writing the post

Re: wrong execution plan [message #300539 is a reply to message #300537] Fri, 15 February 2008 15:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

4 demanding messages within a span of 20 minutes. What do you think? Paid Oracle support? Even there you would not get a response within few minutes.
It would take anyone (atleast for a low-life like me) several hours to understand what you have written (not including the technical parts of it).
Actually, I am feeling very sorry for my first response. I see why you did not get any response from others. I should follow the same path.




Re: wrong execution plan [message #300543 is a reply to message #300537] Fri, 15 February 2008 15:44 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Thanks for your first response.if you are talking about others go and check the other response.you will come to know.i think the reply which was send before he didnt check the query and execution he just follow up the response from michael .

i dont need your help. dont talk about paying and all.



byeeee dont need your help. dont do favour on anybody by replying.
Re: wrong execution plan [message #300544 is a reply to message #300543] Fri, 15 February 2008 15:45 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
u would asked me for technical details i would have provided you.
Re: wrong execution plan [message #301013 is a reply to message #300544] Tue, 19 February 2008 00:21 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Hi,

From your previous posts, it seems as though you have a false idea about how this forum works.
First of all, this is NOT Oracle support, this is a get-together of people with jobs in Oracle, just like you.
In their spare time they come here and try to help others solve their problems. That means that there is no 'status' for your problem; there is not a single person who 'picks it up' or something, as it would be in a project.
Please remember this, and have some patience. As Mahesh wrote: if you don't have the patience, or the time to wait, hire someone.
Re: wrong execution plan [message #301034 is a reply to message #300520] Tue, 19 February 2008 00:43 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Frank,
I am sorry whatever i did??
when i first post my question michael said the tkprof does not belong to my query itself. i appreciated that. but after i created the execution plan for which i was quite sure because it was generated by me. again the same reply came to me. i said atleast he should have read my post. whatever it is??
i know i have done the wrong thing. actually the client wanted me tune the query as soon as possible. i am sorry for my behaviour . i am new i have never posted a question before.i will keep in mind from the next time.


Thanks,
Daniesh
Re: wrong execution plan [message #301037 is a reply to message #300520] Tue, 19 February 2008 00:47 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Gurus,
i am appologiesing to each and everyone to whom i misbehaved. i think you guys can understand as this was my first post.


Thanks ,
Daniesh
Re: wrong execution plan [message #301482 is a reply to message #301037] Wed, 20 February 2008 17:13 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
In your original post http://www.orafaq.com/forum/t/97270/78693/ you included in the attachment some output from Tkprof. Although you have attached a file in almost every subsequent post, these new files contain only the AUTOTRACE output, not the tkprof.

What was wrong with the original Tkprof output? The problem is that it included a lot of SQLs, but NOT the one you are having the problem with.

Tkprof is one of the most powerful tuning tools available to us. With AUTOTRACE we can GUESS, with Tkprof, we can KNOW.

Clearly you are able to use tkprof. All we ask is that you post the tkprof output for the query that is giving you problems.

Ross Leishman
Re: wrong execution plan [message #301512 is a reply to message #300520] Wed, 20 February 2008 22:50 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi rleishman,
Is there any chance that we can use the autotrace to tune the query. could you please give some clue or your assumption so that will help us to tune. can we use please autotrace to tune the query as i dont have tkprof report.

Thanks,
Daniesh
Re: wrong execution plan [message #301522 is a reply to message #301512] Wed, 20 February 2008 23:31 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Not without a lot more effort. I don't have time now. I'll look again tomorrow.
Re: wrong execution plan [message #301526 is a reply to message #300520] Wed, 20 February 2008 23:43 Go to previous message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
ok
thanks
Previous Topic: Oracle Tuning
Next Topic: I cant understand this behavior
Goto Forum:
  


Current Time: Wed Dec 07 08:42:56 CST 2016

Total time taken to generate the page: 0.08978 seconds