This content has been marked as final. Show 4 replies
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.1 person found this helpful
please read this link to know what is for v$active_session_history
You could create a table and run the following SQL using insert into utilising the scheduler when you need it for (alter the SQL as needed) :
Don't think you can get the information you are after from any historical view.
select machine, sysdate, status, sessions from ( select machine, null, status, count(*) sessions from v$session group by status, machine);
Edited by: Freddie Essex on 21-Mar-2013 12:56
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.