Pls help me analyze tkprof output
Please help me analyze this TKPROF output
thanks
Jigar
Attached Files
"High Salaries = Happiness = Project Success."
The problem is it's a 26 table outer join. I suspect you should be happy with only 2 minutes of query time...
I'd nominate this query for Fox's new special "When Bad SQL Attacks..."
Jeff Hunter
Yep. Probably this is record number of sort-merge loops,
that i have seen.
Shetakov and Marist
thanks for the responses. I realize that there are 26 table outerjoins.unfortunately this query is generated by Crystal Reports. Monday, we have a call with the vendor who wrote this query. Can you please give me suggestions on what to tell the vendor - as far as what type of changes they need to make?
I am also including my report.txt as well.
Attached Files
"High Salaries = Happiness = Project Success."
It's simple, the query needs to change. I haven't the slightest idea HOW the query should change because I don't know anything about the application.
Jeff Hunter
Marist,
can you pls look at the report.txt and see everything is ok and if you can make recomendations?
thanks
Jigar
"High Salaries = Happiness = Project Success."
jigarlakhani
Occupation: Senior Oracle DBA
Interests: Solaris, HP, Performance Tuning
what kind of senior you are lol
Jeff had said to u :
U have to change select statment.
Statspack report cannot solve this problem at all.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width