Re: SQL to get currently logged in users

From: David T. Bath <david.bath_at_nre.vic.gov.au>
Date: Tue, 23 Jun 1998 10:53:21 +0000
Message-ID: <358F8921.CCC72C8B@nre.vic.gov.au>

Elliott Mehrbach wrote:
>
> I am looking for the correct SQL to run to just get a list of currently
> logged in users on a specific database. Any help would be appreciated.

Oracle 7 Specific (Probably similar in Oracle 8) Check out SYS.V_$SESSION

 Name                            Null?    Type
 ------------------------------- -------- ----
 SADDR                                    RAW(4)
 SID                                      NUMBER
 SERIAL#                                  NUMBER
 AUDSID                                   NUMBER
 PADDR                                    RAW(4)
 USER#                                    NUMBER
 USERNAME                                 VARCHAR2(30)
 COMMAND                                  NUMBER
 TADDR                                    VARCHAR2(8)
 LOCKWAIT                                 VARCHAR2(8)
 STATUS                                   VARCHAR2(8)
 SERVER                                   VARCHAR2(9)
 SCHEMA#                                  NUMBER
 SCHEMANAME                               VARCHAR2(30)
 OSUSER                                   VARCHAR2(15)
 PROCESS                                  VARCHAR2(9)
 MACHINE                                  VARCHAR2(64)
 TERMINAL                                 VARCHAR2(10)
 PROGRAM                                  VARCHAR2(48)
 TYPE                                     VARCHAR2(10)
 SQL_ADDRESS                              RAW(4)
 SQL_HASH_VALUE                           NUMBER
 PREV_SQL_ADDR                            RAW(4)
 PREV_HASH_VALUE                          NUMBER
 MODULE                                   VARCHAR2(48)
 MODULE_HASH                              NUMBER
 ACTION                                   VARCHAR2(32)
 ACTION_HASH                              NUMBER
 CLIENT_INFO                              VARCHAR2(64)
 FIXED_TABLE_SEQUENCE                     NUMBER
 ROW_WAIT_OBJ#                            NUMBER
 ROW_WAIT_FILE#                           NUMBER
 ROW_WAIT_BLOCK#                          NUMBER
 ROW_WAIT_ROW#                            NUMBER
 LOGON_TIME                               DATE
 LAST_CALL_ET                             NUMBER

David T. Bath at home
david.bath_at_nre.vic.gov.au
Phone: +613 9500 0894 Mobile: 015 824 171 (not always on) Office: Global Consulting Ph:+613 9347 7511 Fax:+613 9347 0182

Received on Tue Jun 23 1998 - 05:53:21 CDT