Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Active users

Re: Active users

From: David Bath <dtb_at_otto>
Date: 30 Nov 92 01:35:23 GMT
Message-ID: <dtb.723087323@otto>

mgrimley_at_ems.cdc.com (Mary Grimley) writes:

>I am looking for a way for a Pro*C program to retrieve a list of all
>the users who are currently using the database. I have been reading
>through the data dictionary views but I do not see any views that
>identify the active users.

You might try looking at SYS.AUD$ table - I haven't done it myself, but the data inside it looks promising with appropriate joins and restrictions. You may have to turn auditing on for connections thoigh for this to work.

I also heard there were undocumented tables that monitor in sql*dba uses - anybody hear about these ?

-- 
David T. Bath
email: 	dtb_at_otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
#include <disclaimer.h>
Received on Sun Nov 29 1992 - 19:35:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US