Xref: alice comp.databases.oracle.misc:47770 comp.databases.oracle.server:75492 comp.databases.oracle.tools:36209 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newspeer1.nac.net!newsfeed.wirehub.nl!news.wirehub.nl!not-for-mail From: "akolk - gelrevision.nl" Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc Subject: Re: Transaction Isolation Level Serializable Problems Date: Thu, 25 Nov 1999 10:22:58 +0100 Organization: Wirehub! Internet Lines: 43 Message-ID: <383CFFF2.DC2105B9@gelrevision.nl> References: <382F0C87.17563C49@cableinet.co.uk> <943384595.7909.0.nnrp-08.9e984b29@news.demon.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: thor.wirehub.nl 943518413 66426 195.86.58.244 (25 Nov 1999 08:26:53 GMT) X-Complaints-To: abuse@wirehub.net NNTP-Posting-Date: 25 Nov 1999 08:26:53 GMT X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.9 i686) X-Accept-Language: en, pt-BR, pt 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@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 > > > >