Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unpredictable Query run time
Vincento Harris wrote:
>Hi
>I have a query that runs in about two minutes and sometimes 12
>minutes.
>I checked the database workload,server workload,ran statistics and
>the time could not be improved.The explain plan as far as I could
>tell did not show any obvious excesses.
>
>
>
>This query is run through crystal and the application in this case is
>peoplesoft.
>
>
>I do not know where else to look .So any pointers will be greatly
>appreciated?
>
>
>
>Oracle Version 8.1.7.4 just upgraded from 8.1.7.0.0
>OS HP Unix 11.0
>
>Vince
>
>
Follow Rene's advice. But likely the problem is in Crystal or, if you
are using one, the web server.
I've seen this before but not once have I seen Oracle as the root cause.
Are you using subreports?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Oct 20 2003 - 13:10:23 CDT