Re: Transaction Isolation Level Serializable Problems

This sounds as if you need to review your strategy. You shouldn't have a lot of active interfering transactions on a Data Warehouse.

The locking problems are probably nothing to do with the serializable transactions, as such.

The failure rate of the serializable transactions MAY be reduced by increasing the INITRANS value on all the tables which are involved.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Aamer Janjua wrote in message <382F0C87.17563C49_at_cableinet.co.uk>...
>Hi All
>
> We are using an application written in ProC and it uses
>
> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
>
> As it is a Warehouse house application. We are having some serious
>locking problems as this is a very active database with a lot of DML
>statements. These transactions are failing also.
>
> I have read about Serializable in oracle manuals but we require much
>more information on it .
>
> Anyone with some experience of these problems and any pointers will
>be highly appreciated
>
> Thanks
>
> Aamer Janjua
>
>
Received on Tue Nov 23 1999 - 11:35:06 CST