I received lots of good responses. Suggested solutions are:
on the Oracle side:
- Ask the dba ( I will do that)
- Turn listener logging on, you can count the number of connections to the
database there.
- Use svrmgrl and look at v$session
svrmgrl> connect internal
svrmgrl> select count (*) from v$session
- Darren Browett and Andy Cohen sent me SQL script that I haven't tried yet.
on the UNIX side:
-Determine active users with ps -ef command
-Use tcp wrappers
-Use netstat -a with grep and awk to pull the needed information
-If you have enhanced security, use the audit log
So at the moment I will stick with netstat -a and manipulate the output
with awk and grep. I will ask the dba some help and try the Oracle options.
Thanks to Brian Hostetter, Andy Cohen, Denis Bredeen, Daniel Monjar, Phil
Baldwin, Robert Otterson, Izzet Ergas, Scott Marsh, Alan Davis, Darren
Browett, Tang, Nikola Milutinovic, Bill Boddy and Alan Hawdon.
Original question:
We have Oracle running on one of our servers (4.0D), my boss is asking me
how many peoples are connecting to the system every day. The users don't
log on to the operating systems they connect via some applications. The
best thing I've found is netstat -a which show the current connections to
the system. But is there a way to know how many people are connecting to
the box everyday ?
Received on Fri Apr 06 2001 - 16:41:56 NZST