Re: Checking Oracle user Process in unix

No,  Not quite right.
Oracle WILL spawn a process if you are using

dedicate server processes. <FONT face=Arial size=2>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 -----
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:   Jyoti N   

  To: <A title=ORACLE-L_at_fatcity.com
  href="mailto:ORACLE-L_at_fatcity.com">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 <username>,
  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(<A
  href="mailto:sqlplus_at_sqlplus@<conenct_string>),   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_at_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_at_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_at_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_at_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_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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Narender Akula
> INET: narender.akula_at_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_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).      

  Get your FREE download of MSN Explorer at <A   href="http://go.msn.com/bql/hmtag_itl_EN.asp">http://explorer.msn.com--   Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N   INET: jnair75_at_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_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).