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: Aniruddha Kortikar <kortikar_at_mipos2.intel.com>
Date: 24 Nov 92 23:28:00 GMT
Message-ID: <By8uIp.KJs@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 Tue Nov 24 1992 - 17:28:00 CST

Original text of this message

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