Re: users

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/07/12
Message-ID: <058d4024.f96590dd@usw-ex0105-037.remarq.com>#1/1

The information about what users are currently connected to you system is kept in the v$session view. If you are the DBA or have select any table priveledges and you database has been correctly installed you should have no problem accessing this view. Oracle has a number of log files (.trc) but I'm not sure off hand which one would contain a history of connections granted to the database, I would guess the the file related to the listener.

-Ethan

http://www.freetechnicaltraining.com/article_10.htm http://www.gnumetrics.com

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT