Re: Oracle osuser in v$session

From: Mikhail Velikikh <mvelikikh_at_gmail.com>
Date: Tue, 14 Jan 2020 09:00:50 +0000
Message-ID: <CALe4Hp=apLHznspX1WSiYTGwKPW=0g2mGdaTxO6uQKb=5UNeyg_at_mail.gmail.com>

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

It reminds me of docker applications - they are often run under root and have fancy hostnames. Those machines in v$session look like this:

MACHINE

---

535fcd6962c0
c275434b17af
39729d22db93
ff5d2e992930
a32ac9188432

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

> Marc
>
> 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
>
> Sanjay
> On Monday, January 13, 2020, 03:49:19 PM EST, Powell, Mark <
> mark.powell2_at_dxc.com> wrote:
>
>
> 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-l

Received on Tue Jan 14 2020 - 10:00:50 CET