| wrong execution plan [message #300520] |
Fri, 15 February 2008 14:30  |
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 #300525 is a reply to message #300520] |
Fri, 15 February 2008 14:45  |
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 #300543 is a reply to message #300537] |
Fri, 15 February 2008 15:44 |
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 #301013 is a reply to message #300544] |
Tue, 19 February 2008 00:21 |
Frank
Messages: 7901
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 |
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 #301482 is a reply to message #301037] |
Wed, 20 February 2008 17:13 |
rleishman
Messages: 3728
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 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
