Re: process restrction per user

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Mon, 06 Aug 2001 01:58:34 -0700
Message-ID: <F001.003611EE.20010806015021@fatcity.com>

1.- With profiles:

create profile bad limit
sessions_per_user 2

alter user taffarel profile bad;

2.-
select spid "OS PID" from v$process,v$session where paddr=addr and sid=&sid.;

And in other to solve your problem bounce the database and change in the init.ora the processes parameter. If you can't, start killing sessions inactive.

Regards.

N Venkata Apparao <apparao_at_sol.net.in> wrote:
> 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×ëqÇ³ó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).

Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.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).

Received on Mon Aug 06 2001 - 03:58:34 CDT