From: tk@ivu-berlin.de (Thomas Keul)
Subject: Re: Commit without freeing locks
Date: 1996/10/10
Message-ID: <53iokl$egb@ivu.ivu-berlin.de>#1/1
references: <325A7E69.4E81@leadingbits.via.at> <53fq8l$3m1@is04.via.at>
organization: IVU GmbH Berlin, Germany
newsgroups: comp.databases.oracle



Dieter Oberkofler (dtr@leadingbits.via.at) wrote:
: Thank you for your help!
 
: After a look to my oracle manual i found another possible way of
: solving my problem.
 
: Oracle supplies a DBMSLOCK pakage that contains a few functions
: and procedures able to create a lock structure in the oracle
: server.
 [...]
: Any comments and ideas to this approach?

we use this package and had a big problem dealing with a lot of locks
(with 2 sessions a 400 Locks oracle 7.2 crashes without warning)

Oracle support gave us a secret init.ora parameter: _enqueue_locks

our init.ora contains now:
dml_locks           = 3000
enqueue_resources   = 4000
_enqueue_locks      = 4000

.. and Oracle now crashes when we constantly try to get more than
4000 Locks (all sessions together).



--
--------------------------------------------------------------------
Thomas Keul, IVU GmbH                               tk@ivu-berlin.de
Bundesallee 88                                  tel +49 30 85906 451
12161 Berlin, Germany                           fax +49 30 85906 444