Re: Getting Oracle connected sessions in the past

You can use. If turned on the audit records On 27 Jul 2016 12:49, "Luis Santos" <lsantos_at_pobox.com> wrote:

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