> 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.
I'm no Oracle guru, but in any relational database you may have problems
with lock contention. It sounds to me like some of your queries are taking
long enough that they're blocking other queries from running. You may want
to reexamine your indexing strategy.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
