This content has been marked as final. Show 4 replies
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.