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
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: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate AUDIT on SESSION.

Regards
Michel
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: 64106
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
Previous Topic: ora-00371
Next Topic: installation problem for Oracle 10g Release 2 (10.2.0.4) on Vista (merged 3)
Goto Forum:
  


Current Time: Mon Dec 05 02:50:35 CST 2016

Total time taken to generate the page: 0.12439 seconds