Re: How do I determine if someone is logged in to a d.b.

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 07 Mar 2000 03:17:40 GMT
Message-ID: <38cc6ebc.19119372@netnews.worldnet.att.net>

I've never heard of dsk_logins. I usually query v$session, which is the same view that Instance Manager queries for you. For example:

USERNAME                             SID   SERIAL#
------------------------------ --------- ---------
                                       1         1
                                       2         1
                                       3         1
                                       4         1
                                       5         1
                                       6         1
                                       7      7409
                                       8      7409
SYSTEM                                11      7101

The entries with no usernames represent the Oracle background processes, not logged in users. In this example, I'm the only user.

Jonathan

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Mon, 06 Mar 2000 20:24:50 GMT, jeffro <jeffrowland_at_my-deja.com> wrote:

>Hi, I am new to Oracle and having the job of Oracle DBA thrust on me.
>One question I need help on is determining if anyone is logged into
>or working with a D.B. Its a maze trying to reading through all the
>documentaton.
>
>I have worked with OEM using the Instance Manager and then clickings
>on sessions. I have also had someone tell me to use the query
>
>select * from dsk_logins.
>
>The above query shows a login name that does not show up using
>Instance Manager-> Sessions
>
>Also I was unable to find dsk_logins mentioned anywhere in the
>documentation.
>
>I am using ORACLE 8.0.5.
>Any help appreciated.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Mar 06 2000 - 21:17:40 CST