Re: How can I determine who is currently logged in the Oracle server?
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 22 Sep 2009 08:18:47 +0200
Message-ID: <4ab86c47$0$83234$e4fe514c_at_news.xs4all.nl>
Ramon F Herrera schreef:
> On Sep 21, 5:31 am, gazzag <gar..._at_jamms.org> wrote:
>
>
> 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
>
Date: Tue, 22 Sep 2009 08:18:47 +0200
Message-ID: <4ab86c47$0$83234$e4fe514c_at_news.xs4all.nl>
Ramon F Herrera schreef:
> 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
>
In that case, Gazzag's answer will do. You can even make your intermediate server set its own program info to easily find it back in V$SESSION Shakespeare Received on Tue Sep 22 2009 - 01:18:47 CDT