Re: Transaction size limitation for serializable isolation level?

From: VC <boston103_at_hotmail.com>
Date: Sun, 18 Apr 2004 17:32:21 GMT
Message-ID: <BYygc.21058$yD1.48596@attbi_s54>

Hello,

Pls. see below:

"Lusiana Lusiana" <lusiana_at_dummybit.nortelnetworks.com> wrote in message news:c5nr1t$qqg$1_at_zcars0v6.ca.nortel.com...
> Hi All,
>
> Our system configuration is Oracle 8.1.6 on Solaris 5.8 with servlet/jsp
> using
> Tomcat as client. Transaction isolation level is set to serializable.
>
> We have some long transactions, and we have been getting 'ORA-08177:
Cannot
> serialize access for this
> transaction' for these.
> The error were also experienced when there's only one user on the database
> (ie.one transaction).
> Redoing the transaction didn't help.

There is an bug related to the SERIALIZABLE IL that Oracle had neglected to fix for quite a while until the 9.2 version. Pls. see the link below for more information:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=31e0625e .0310210612.5aa62f57%40posting.google.com&rnum=3&prev=/groups%3Fq%3Dvc%2520s erializable%2520joe%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26sa%3DN%26t ab%3Dwg

The "solution", if at all possible, would be to upgrade to 9.2

Rgds.

VC Received on Sun Apr 18 2004 - 12:32:21 CDT