Re: Oracle osuser in v$session
Date: Mon, 13 Jan 2020 21:10:04 +0000 (UTC)
Message-ID: <415751981.12794959.1578949804279_at_mail.yahoo.com>
Marc
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 viewSanjay On Monday, January 13, 2020, 03:49:19 PM EST, Powell, Mark <mark.powell2_at_dxc.com> wrote:
#yiv6226707520 #yiv6226707520 -- _filtered {} _filtered {}#yiv6226707520 #yiv6226707520 p.yiv6226707520MsoNormal, #yiv6226707520 li.yiv6226707520MsoNormal, #yiv6226707520 div.yiv6226707520MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv6226707520 a:link, #yiv6226707520 span.yiv6226707520MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv6226707520 a:visited, #yiv6226707520 span.yiv6226707520MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv6226707520 p.yiv6226707520msonormal0, #yiv6226707520 li.yiv6226707520msonormal0, #yiv6226707520 div.yiv6226707520msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv6226707520 span.yiv6226707520EmailStyle18 {font-family:sans-serif;color:windowtext;}#yiv6226707520 .yiv6226707520MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv6226707520 div.yiv6226707520WordSection1 {}#yiv6226707520 More than likely the connections are for a web application where all the connections to Oracle use the same username. The application runs under root. To Oracle all the sessions appear as the same source/user.
Select username, osuser, machine from v$session order by use machine, osuser, username
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>On Behalf Of Sanjay Mishra
Sent: Monday, January 13, 2020 3:19 PM
To: Oracle-L Freelists <oracle-l_at_freelists.org>
Subject: Oracle osuser in v$session
I had an environment where multiple tier applications using JDBC are connecting to the database. I am seeing OSUSER in v$session is coming out from lots of sessions as root or even ? and they are not background process sessions. Can someone help to provide some explanation?
TIA Sanjay
DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 13 2020 - 22:10:04 CET