Home -> Mailing Lists -> Oracle-L -> Re: Oracle osuser in v$session

Re: Oracle osuser in v$session

From: Priit Piipuu <priit.piipuu_at_gmail.com>
Date: Tue, 14 Jan 2020 10:01:07 +0100
Message-ID: <CAJYY02gNQHA5u9XNQTiM=juXid5-oeeVwp8UdDOG-HAu23tv4Q_at_mail.gmail.com> 








On Mon, 13 Jan 2020 at 22:11, Sanjay Mishra <dmarc-noreply_at_freelists.org>
wrote:



>

> I am sharing the details from v$session

> CONNECTIONS USERNAME        STATUS   MODULE                       OSUSER


> ----------- --------------- -------- ---------------------------- -------

>          29 REMAC2        INACTIVE JDBC Thin Client                  ?

>          50 REMAC1        INACTIVE JDBC Thin Client                  ?

>          53 REMAC3          INACTIVE JDBC Thin Client                root

>          95 REMAV      INACTIVE JDBC Thin Client                     root

> Also strange Machine name is coming in the same v$ession view

>




It takes a great courage to run Java apps as a root :) With Oracle JDBC
12.1.0.2 JDBC driver and later, OSUSER and MACHINE are usually correct and
PROCESS isn't.


V$SESSION_CONNECT_INFO has extra details about who connects with which
driver.


--
http://www.freelists.org/webpage/oracle-l


Received on Tue Jan 14 2020 - 10:01:07 CET












Original text of this message