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