process restrction per user

Hi

I am facing problems error of "number of process exceeds"

I have 20 users in a database please help me following

1. How can restrict number processors per user
2. How can i found each user using number of process please help me - apparao
   • Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, August 06, 2001 12:16 PM

> hi,
> have u made it? i also encounted the same problem of oracle 817 on
solaris,
> if i specify server=shared in tnsnames.ora, then it gives out 12520
error code.
>
> ----- Original Message -----
> From: "Harvinder Singh" <Harvinder.Singh_at_metratech.com>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, July 25, 2001 11:36 PM
> Subject: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
>
>
> >
> > Hi,
> >
> > I have configured the server to use MTS and still dedicated connections
r
> > used.
> > What might be the reason....database is 8.1.6.3.4
> >
> >
> >
> > LSNRCTL> services
> > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
> > Services Summary...
> > ora2000 has 6 service handler(s)
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D004 <machine: ORA2000, pid: 1956>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D003 <machine: ORA2000, pid: 1952>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D002 <machine: ORA2000, pid: 1948>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D001 <machine: ORA2000, pid: 1944>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D000 <machine: ORA2000, pid: 1940>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
> > PLSExtProc has 1 service handler(s)
> > DEDICATED SERVER established:0 refused:0
> > LOCAL SERVER
> > ora2000 has 6 service handler(s)
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D004 <machine: ORA2000, pid: 1956>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D003 <machine: ORA2000, pid: 1952>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D002 <machine: ORA2000, pid: 1948>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D001 <machine: ORA2000, pid: 1944>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))
> > DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
> > D000 <machine: ORA2000, pid: 1940>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))
> > ora2000 has 1 service handler(s)
> > DEDICATED SERVER established:0 refused:0
> > LOCAL SERVER
> > ora2000 has 6 service handler(s)
> > DEDICATED SERVER established:76 refused:0
> > LOCAL SERVER
> > The command completed successfully
> >
> >
> > init.ora looks like:
> >
> > mts_dispatchers = "TCP,5"
> > mts_max_dispatchers=50
> > mts_servers=20
> > mts_max_servers=50
> > LOCAL_LISTENER = "(ADDRESS_LIST = (Address = (Protocol = TCP)
(Host=ora2000)
> > (Port=1521)))"
> >
> >
> > Thanks
> > Harvinder
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Harvinder Singh
> > INET: Harvinder.Singh_at_MetraTech.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >W��zء�r&9,B
�Y� ����뢷jSz7jSzɨ��rq�(���SI�?��Y���Q_��ӝjpz
> jX��h�-'zם�qdz�SX?���DCTL��.��kS�SX,X��u�1�T�j
��k��r+r?��\�--)��Ѯ�v).��xb)-�jXyʵ�Sx5%9,B�؝���SX,X�*���?���?��ɩ�� v�Br?jw��.��T��y'�n�?�

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: N Venkata Apparao
  INET: apparao_at_sol.net.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).