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.
If you are looking at v$active_session_history, you must be licensed to use the AWR. So by default you can generate AWR reports going back 8 days. If your DBA is any good he has probably extended the retention period to at least a month.
until auditing is enabled or you write some logon and logoff triggers, i afraid it is not possible to find out previous session information.
please read this link to know what is for v$active_session_history
Session auditing is on by default (since database was created using dbca).
It seems what I am looking for is not readily available without coming up with some kind of homegrown method using logon triggers along with v$audit_session, or something like that.
I was looking for our current system anyway, not for the future, although it might be useful for the future if i create something now.