Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

historical count of user sessions connected

User_UOVAAMar 21 2013 — edited Mar 21 2013
For Oracle 11.x, is there a way to look at how many sessions were connected at some time in the past (e.g., a week ago, or every Sunday at 3:00pm for past 6 weeks, etc.).
I want to know how many sessions were connected, verses how many session were active.
It seems this information should be located somewhere, but where?
I looked at v$active_session_history, but I really don't know what I'm looking at there, and also, it doesn't show inactive connections.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2013
Added on Mar 21 2013
4 comments
4,558 views