top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

how to determine who is logged into Oracle?

+2 votes
375 views
how to determine who is logged into Oracle?
posted May 5, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

DESCRIPTION

You can find all users currently logged into Oracle by running a query from a command prompt. In Oracle/PLSQL, there is a system view called V$SESSION which shows the session information for each current session in the database. You can run a query against this system view to return all users that currently have a connection running in the Oracle/PLSQL database.

SYNTAX

The syntax to retrieve the users logged into Oracle is:

SELECT USERNAME FROM V$SESSION;

This SELECT statement will return each username that is logged in.

answer May 5, 2015 by Shivaranjini
...