Re: Oracle osuser in v$session

 Thanks Vishnu. I will share the detail to App team TxSanjay

    On Wednesday, January 15, 2020, 03:41:23 PM EST, Vishnu Potukanuma <vishnupotukanuma_at_gmail.com> wrote:  

 As Mark pointed out, the default configuration for web servers such as apache spawn the threads/processes for incoming requests as root user unless you explicitly specify the username and group name in the configuration file such as the following. it is a very bad practice to run as root... 
# User/Group: The name (or #number) of the user/group to run httpd as.
# It is usually good practice to create a dedicated user and group for
# running httpd, as with most system services.
#
User WebPPS1
Group app

Thanks,
Vishnu

On Tue, Jan 14, 2020 at 4:39 PM Timur Akhmadeev <timur.akhmadeev_at_gmail.com> wrote:

Prior to Java 9 there was no platform-independent way to get PID from inside of a Java program, so JDBC driver used 1234 as a default value (can be customized with -Dv\$session.process=something if you want to)Java 10 compliant JDBC driver doesn't use the new API so JDBC clients will continue to use 1234 as v$session.process for some time. On Tue, Jan 14, 2020 at 12:02 PM Priit Piipuu <priit.piipuu_at_gmail.com> wrote:

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

I am sharing the details from v$sessionCONNECTIONS 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                     rootAlso 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. 

-- 
Regards
Timur Akhmadeev

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