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(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 <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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" <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
