This is my standard query for session history. You can dig into AWR and other
audit information for more details.
select * from dba_audit_session
where OS_USERNAME = '&osusr'
and username = '&usr';
===================================
Robert P. LockardOracle ACEWinner of the 2015 Oracle Developers Choice Award
for Database DesignPresident Oraclewizard.com, Inc.
The question is not “who is going to let me,” it's “who is going to stop me."
Ayn Rand
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332
twitter @navonpilot
youtube https://www.youtube.com/user/n4281k
blog: http://www.oraclewizard.com ;
-----Original Message-----
From: Luis Santos [mailto:lsantos@xxxxxxxxx]
Sent: Wednesday, July 27, 2016 07:32 AM
To: 'ORACLE-L'
Subject: Getting Oracle connected sessions in the past
This simple query shows connected users in the moment on an Oracle instance:
select username, count(*)
from v$session
group by username
order by 2
Is there a way to get this info on a specific time in the past? I know
flashback queries does not work for V$ views (and this is absolutely
reasonable)...
--
Att
Luis Santos