Re: Performance problems with bind variables
From: Amit Srivastava <amit_at_point.cs.uwm.edu>
Date: 21 Oct 1994 03:19:17 GMT
Message-ID: <387bvl$omp_at_uwm.edu>
Date: 21 Oct 1994 03:19:17 GMT
Message-ID: <387bvl$omp_at_uwm.edu>
In article <2aa.502.846%mpcbbs_at_ibase.org.br> Carlos.Netto_at_ibase.org.br (Carlos Netto) writes:
>Hi,
>
>My customer has a report (using ReportWriter) that takes 50 seconds to run.
>While tunning the SQL statement (explain, etc.), I moved the query to
>SQL*Plus and replaced all bind variables with constants. Surprise: the
>same query now takes 10 seconds to run!
>
>After, I move back to ReportWriter and replace the parameters with
>constants. ReportWriter also takes 10 seconds to run!
>
The following questions may help?
What version of Oracle you are using if it is 6.0 or below, check the number of extents the ReportWriter related tables have extended.
How much formatting commands do you have?
--
_/_
__. ____ o /
(_/|_/ / /_<_<__
Received on Fri Oct 21 1994 - 04:19:17 CET