Timeout while obtaining an oracle connection lock

This is a multipart message in MIME format. --=_alternative 002B9A34CA256C31_=
Content-Type: text/plain; charset="us-ascii"

v8.1.7
solaris 2.6
E10k domain/SAN

Coldfusion application receives the following Error Msg:

Error Occurred While Processing Request....Oracle Error Code =0....Timeout while obtaining an oracle connection lock....[<simple> select statement].

CF uses native drivers to connect to oracle instance. Nothing in logs or trace files. Tried using 'cookies' default client storage setting in lieu of 'database' however still no luck.

We recently moved our instances to SAN however we don't appear to have any other latency issues/problems

TIA
Grant Holyoake

Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments.

--=_alternative 002B9A34CA256C31_=
Content-Type: text/html; charset="us-ascii"

<br><font size=2 face="sans-serif">v8.1.7</font>
<br><font size=2 face="sans-serif">solaris 2.6</font>
<br><font size=2 face="sans-serif">E10k domain/SAN</font>
<br>
<br><font size=2 face="sans-serif">Coldfusion application receives the following Error Msg:</font>
<br>
<br><font size=2 face="sans-serif">Error Occurred While Processing Request....Oracle Error Code =0....Timeout while obtaining an oracle connection lock....[&lt;simple&gt; select statement].</font>
<br>
<br><font size=2 face="sans-serif">CF uses native drivers to connect to oracle instance. &nbsp;Nothing in logs or trace files. &nbsp;Tried using 'cookies' default client storage setting in lieu of 'database' however still no luck.</font>
<br>
<br><font size=2 face="sans-serif">We recently moved our instances to SAN however we don't appear to have any other latency issues/problems</font>
<br>
<br><font size=2 face="sans-serif">TIA</font>
<br><font size=2 face="sans-serif">Grant Holyoake</font>
<br><CODE><FONT SIZE=3><BR>
<BR>

Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments.<BR>
</FONT></CODE>
Received on Wed Sep 11 2002 - 02:56:10 CDT