Home » RDBMS Server » Server Administration » no of users in DB (oracle 10g + windows)
no of users in DB [message #436860] Tue, 29 December 2009 02:30 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member
Hi,

How to find out, how many users are hitting my database in a day?


Thanks

Report message to a moderator

Re: no of users in DB [message #436862 is a reply to message #436860] Tue, 29 December 2009 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate AUDIT on SESSION.

Regards
Michel

Report message to a moderator

Re: no of users in DB [message #436864 is a reply to message #436860] Tue, 29 December 2009 03:01 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also take the value of:
select value from v$sysstat where name='logons cumulative';
each day at 0:00 (and subtract the value of the previous day).

Regards
Michel

Report message to a moderator

Previous Topic: ora-00371
Next Topic: installation problem for Oracle 10g Release 2 (10.2.0.4) on Vista (merged 3)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 00:40:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.