Re: Monitoring Oracle users

From: R Scott Hunter <rshunter_at_delphi.com>
Date: Wed, 30 Mar 94 11:57:44 -0500
Message-ID: <pY0vJ9I.rshunter_at_delphi.com>


National Research Group <cinesys_at_nic.cerf.net> writes:  

>Does anyone have any suggestions for a command line oriented program
>which Monitors Oracle Users?
 

Hi.  

You can do something in SQL / SQLPLUS that looks at the tables SYS.V$PROCESS
SYS.V$SESSION
to get information about who's signed on and what's going on, if you like.  

R. Scott Hunter shunter_at_cfotax.attmail.com AT&T Tax Systems
Morristown, NJ, USA Received on Wed Mar 30 1994 - 18:57:44 CEST

Original text of this message