uot;Babette Turner-Underwood" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Checking Oracle user Process in unix
>Date: Thu, 16 Aug 2001 19:20:52 -0800
>
>No, Not quite right.
>Oracle
...)
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
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
ender Akula [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 15, 2001 7:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Checking Oracle user Process in unix
>
> hi List,
> I am checking some oracle users (user1 and user2) processes (sunsolaris)
> using ps -ef
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)
Actually, if you look carefully, it looks like user2 is connecting
remotely (tlcrsdev/tlcrsdev@crsprod). The Oracle server process is on
whatever server "crsprod" lives on.
I assume you changed the passwords in your mail before mailing them
out to hundreds of people on an internet mailing list.
ent: Wednesday, August 15, 2001 7:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Checking Oracle user Process in unix
>
> hi List,
> I am checking some oracle users (user1 and user2) processes (sunsolaris)
> using ps -ef|grep.
>
> $ps -ef|grep sqlplus
> us
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:
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/70:00 sqlplus
tlcrsdev
