Re: Getting Oracle connected sessions in the past

You can check listener.log

2016-07-27 13:47 GMT+02:00 Luis Santos <lsantos_at_pobox.com>:

> I was guessing if there´s not an awr table that contains such info. I´m
> aware of DBA_HIST_RESOURCE_LIMIT, but this is consolidated info.
>
>
> *--*
> *Att*
>
>
> *Luis Santos*
>
>
> 2016-07-27 8:39 GMT-03:00 S3v3n11 <neisdsa_at_gmail.com>:
>
>> dba_audit_session?
>>
>> On Wed, Jul 27, 2016 at 6:32 AM, Luis Santos <lsantos_at_pobox.com> wrote:
>>
>>> This simple query shows connected users in the moment on an Oracle
>>> instance:
>>>
>>>
>>>>
>>>>
>>>> *select username, count(*) from v$session group by usernameorder 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*
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l