Home » RDBMS Server » Server Administration » sessions established by each user per hour (oracle 11.2.0.4 on Linux)
sessions established by each user per hour [message #645389] Fri, 04 December 2015 15:56 Go to previous message
PBG789
Messages: 7
Registered: December 2015
Junior Member
Hello all

I am trying to find the total number of sessions established by certain users by each hour.(up to last 24 hours)

Lets say I have application users A,B and C. How can I find the total number of sessions each user established per hour?

I checked v$session, but it only provides current sessions, I am more looking into history of the sessions established per hour.

Any help will be greatly appreciated.


Thanks.

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Why isn't registry$history updated with latest 12.1.0.2
Next Topic: Unable to connect via wallet credentials - ORA-12534: TNS:operation not supported
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:14:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.