I have too but this is all through coldfusion and sp's should I have to commit or close any connections when executing via CF5.0?

Thanks,

David

-----Original message-----
From: Greg Morphis [EMAIL PROTECTED]
Date: Wed, 25 Aug 2004 11:25:56 -0400
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Strange Oracle Error

> I've seen that error when I've done soemthing in the DB and did not
> commit the changes.
>
>
> On Wed, 25 Aug 2004 09:20:37 -0500, Deanna Schneider
> <[EMAIL PROTECTED]> wrote:
> > Check your logs. I think we've found that we often get these following
> > another error that's tying up Oracle.
> >
> > > To all you oracle guru's out there, can any of you shed some light for me?
> > >
> > > A client sent me this error, they could not get a screen shot of the error
> > so I am not 100% positive that this is worded correctly as I have never seen
> > this error before?
> > >
> > >
> > > Oracle Error Code=0
> > > Timeout while obtaining Oracle statement lock.
> > >
> > > ...identifier of (CFQuery) occupying doc position (401:5) to (401:97).
> > >
> > >
> > > This error is on a page that performs many queries and can be slow at
> > times.  The code has been running good until recently.  There have been no
> > changes, other that the database growing in size.
> > >
> > > Thanks,
> > >
> > > David
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to