Re: dml_locks and processes

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Wed, 20 Oct 1999 13:45:30 GMT
Message-ID: <_HjP3.111$p%6.2873947@France.EU.net>

Hi Jacques !

dml_locks is the number of lock simultaneous set by users.

So if 10 users have to set 5 locks per session, you have to set dml_locks=50 at the minimum !
Processes is the number of simultaneous connections. This is the number of shadow processes !

Regards.

<dalalbm_at_my-deja.com> a écrit dans le message : 7uid5d$mul$1_at_nnrp1.deja.com...
> I think your question is ambiguous. Clearly you have to look into
> init<SID>.ora file for lines
>
> dml_locks=xxx
> processes=nnn
>
> Processes should be normally 5+no. of concurrent users accessing your
> database. Dml_locks depends on the type of transactions and no. of
> processes. (thumb rule : 4*no. of concurrent transactions)
>
> -Dalalbm
>
> In article <7uhocn$758$1_at_nnrp1.deja.com>,
> jacksnews_at_my-deja.com wrote:
> > Hy everybody,
> >
> > how can I check out the appropriate size of dml_locks and processes
> > for an Oracle-server in the file init.ora?
> >
> > Thanks your help.
> >
> > best regards
> >
> > Jacques
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 20 1999 - 08:45:30 CDT