Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
RE: Checking Oracle user Process in unix
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).
Received on Thu Aug 16 2001 - 13:20:16 CDT
Original text of this message