From babattt@home.com Wed, 15 Aug 2001 18:13:40 -0700 From: "Babette Turner-Underwood" Date: Wed, 15 Aug 2001 18:13:40 -0700 Subject: Re: Checking Oracle user Process in unix Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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).