Re: How can I determine who is currently logged in the Oracle server?

From: gazzag <gareth_at_jamms.org>
Date: Mon, 21 Sep 2009 02:31:10 -0700 (PDT)
Message-ID: <674812e8-3146-4b9f-bdf7-2abe903974e8_at_v2g2000vbb.googlegroups.com>

On 21 Sep, 07:26, Ramon F Herrera <ra..._at_conexus.net> wrote:
> How can I determine who is currently logged in the Oracle server?
>
> -RFH
What version of Oracle? What operating system? Do you mean logged into the database itself, or the actual database server? If the former:

SQL> SELECT username, osuser, machine, program

         FROM v$session
         WHERE username IS NOT NULL;

If the latter, consult the relevant O/S documentation.

HTH -g Received on Mon Sep 21 2009 - 04:31:10 CDT