Hi Babette,
You are right that in case of MTS , oracle does not spawn dedicated process for each connection.
My comment was based on the context of the question ( note that I said "in this case") which clearly shows that the site is running dedicated server.
Jyoti.
>From: "Babette Turner-Underwood"
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Checking Oracle user Process in unix
>Date: Thu, 16 Aug 2001 19:20:52 -0800
>
>No, Not quite right.
>Oracle WILL spawn a process if you are using
>dedicate server processes. It will ONLY NOT
>spawn the process if you are using MTS
>
>(well technically it could, if it needed an
>additional server process and
>you were not yet at the max_servers value
>.... but I digress...)
>
>Message -----
> From: Jyoti N
> To: Multiple recipients of list ORACLE-L
> Sent: Thursday, August 16, 2001 3:32 PM
> Subject: RE: Checking Oracle user Process in unix
>
>
> Whenever you say $sqlplus ,
>
> Oracle spawns a dedicated server process to connect to database using Bequeath protocol (in this case) which bypasses the listener ,I guess.
>
> When you use the connect string(sqlplus@), Oracle connects thru the listener process/port(whatever), so probably, it does not require to spawn another process.
>
> HTH,
>
> Jyoti
>
> >From: Narender Akula
>
> >Reply-To: ORACLE-L@fatcity.com
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: Checking Oracle user Process in unix
> >Date: Wed, 15 Aug 2001 19:40:33 -0800
> >
> >Hi Babette,
> >
> >1) the Instance and user2,user1 are on same mechine. so no dblink...no
> >listener involved.
> >2) user1,user2 is not using any sql* net connections.but still for user1
> >shadow process shows but not for user2.
> > the only difference
> >is user1 is connecting explicitly (sqlplus username/password)
> >and user 2 is connecting via shell scripts. (/BDE/v1/tlcrs_load_tables/x.sh
> >--> sqlplus username/password).
> >
> >naren
> >-----Original Message-----
> >Sent: Thursday, 16 August 2001 14:16
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Two possible reasons
> >
> >1) crsprod (the database for the db link) is on a remote machine.
> >In that case, the dedicated server will not show on this machine.
> >
> >2) For SQL*net connections, the dedicated server sessions are created and
> >owned by the oracle user.
> >
> >- Babette
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L"
> >Sent: Wednesday, August 15, 2001 8:55 PM
> >
> >
> > > hi List,
> > > I am checking some oracle users (user1 and user2) processes (sunsolaris)
> > > using ps -ef|grep.
> > >
> > > $ps -ef|grep sqlplus
> > > user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys
> > > me 27415 25766 0 11:47:36 pts/17 0:00 grep sqlplus
> > > user2 27408 26250 0 11:46:27 pts/7 0:00 sqlplus
> > > tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo
> > >
> > > checking oracle process...for user1
> > > $ps -ef|grep 26671
> > > user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys
> > > oracle 26672 26671 0 10:36:38 ? 0:00 oracleTERAPROD
> > > (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > >
> > > checking oracle process .. for user2 (running script for shell program-
> > > updating table)
> > > $ps -ef|grep 27408
> > > dcook 27408 26250 0 11:46:27 pts/7 0:00 sqlplus
> > > tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo
> > >
> > > My question is for user2 why I am not able to see the oracle process.
> > >
> > > can somebody tell me what is happening here? am i missing something.
> > >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Babette Turner-Underwood
> > INET: babattt@home.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@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).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Narender Akula
> > INET: narender.akula@terralinkinternational.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@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).
>
>
>------------------------------------------------------------------------------
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: jnair75@hotmail.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@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).
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jyoti N
INET: jnair75@hotmail.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@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 Fri Aug 17 2001 - 13:19:01 CDT
