Re: Active users

From: Aniruddha Kortikar <kortikar_at_mipos2.intel.com>
Date: 24 Nov 92 23:28:00 GMT
Message-ID: <By8uIp.KJs_at_inews.Intel.COM>

You could access v$process table to get distinct list of username.

	v$process contains username char(13)
			   terminal char(8)
			   program  char(64)
			and lot of other information.
------------------------------------------------------------------------------	

In article <30630_at_nntp_server.ems.cdc.com> mgrimley_at_ems.cdc.com 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.
>
>Mary Grimley email: mgrimley_at_ems.cdc.com
>Empros Systems International phone: (612) 553-4763
>2300 Berkshire Lane North Facility Code: PLY008
>Plymouth, MN 55441 USA
>_____________________________________________________________________________

---

E-mail 	: kortikar_at_mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.
-------------------------------------------------------------------------------

Received on Wed Nov 25 1992 - 00:28:00 CET