Re: dml_locks and processes

From: <dalalbm_at_my-deja.com>
Date: Tue, 19 Oct 1999 18:27:10 GMT
Message-ID: <7uid5d$mul$1@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 Tue Oct 19 1999 - 13:27:10 CDT