DB version : 11.2.0.4
Platform : Oracle Linux 6.7
To see how many active sessions are there in the DB at the moment, I can just run the following query. But, I want to know how many active sessions were there at point in the past (at particular time).
ie. Lets say the current time is 11:30 AM, I want to know how many active sessions were there at 9:00 AM. How can I get this info ?
select count(*) from v$session where type='USER' and status = 'ACTIVE';