Re: Query processing takes very variable time
- From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- To: Pradeep.Chetal@xxxxxxxxxxxxxx
- Date: Mon, 29 Dec 2008 17:12:51 -0800
On Mon, Dec 29, 2008 at 4:53 PM, Pradeep Chetal
<Pradeep.Chetal@xxxxxxxxxxxxxx> wrote:
> Sorry, Jared for the cryptic request. It is a complex process to set up the
> tables, etc, but once they are set, we run a stored proc that works on these
> tables - and the SQL code seems very simple - selects, inserts, and updates
> [even those are simple, nothing fancy ]. However, the processing factor
> takes long sometimes (not all the times).
>
> I was hoping to look for *extraneous* factors (outside the code) that can
> affect the processing and if anyone on this list has any experience like
> that.
Based on the extremely limited information provided (and the endless
possibilities), what kind of assistance would you expect other than
complete guesses.
The quality of the responses on this list are generally proportional
to the quality of detail provided about the issue. Help us help you.
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
