Re: How can I determine who is currently logged in the Oracle server?
From: Ramon F Herrera <ramon_at_conexus.net>
Date: Mon, 21 Sep 2009 21:55:54 -0700 (PDT)
Message-ID: <6c166558-0e1b-4337-9435-f87da223f1b2_at_m11g2000vbl.googlegroups.com>
On Sep 21, 5:31 am, gazzag <gar..._at_jamms.org> wrote:
> 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
Date: Mon, 21 Sep 2009 21:55:54 -0700 (PDT)
Message-ID: <6c166558-0e1b-4337-9435-f87da223f1b2_at_m11g2000vbl.googlegroups.com>
On Sep 21, 5:31 am, gazzag <gar..._at_jamms.org> wrote:
> 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
Oracle 10g on Linux
I wrote an intermediate server which stays logged into Oracle, receives requests, converts them, queries the database and returns the results to the client.
I would like to have a way of knowing whether my program(s) is logged in, and how many instances of it. The suggestion by Mladen won't work, because my program will not yell at me, its creator. :^D
I have been managing U*x systems for a long time. No help needed there.
-Ramon Received on Mon Sep 21 2009 - 23:55:54 CDT