Re: Transaction Isolation Level Serializable Problems

Don't forget the indexes !

Jonathan Lewis wrote:

> 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 Thu Nov 25 1999 - 10:22:58 CET