Home » RDBMS Server » Server Administration » Tracing active users
Tracing active users [message #64162] Thu, 23 December 2004 21:41 Go to next message
Pankaj Gupta
Messages: 4
Registered: April 2004
Junior Member
I would like to know how can we trace the active usernames who are connecting to database.

Report message to a moderator

Re: Tracing active users [message #64172 is a reply to message #64162] Sun, 26 December 2004 19:32 Go to previous message
sri
Messages: 154
Registered: February 2000
Senior Member
if it is the DB User then u can use

select distinct USERNAME from v$session;

Report message to a moderator

Previous Topic: Cant install Oracle 9i on windows server 2003 wint diferent language support
Next Topic: Removing all objects in Oracle 8 on UNIX platform
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 23:03:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.