Re: Getting Oracle connected sessions in the past
From: Luis Santos <lsantos_at_pobox.com>
Date: Wed, 27 Jul 2016 08:47:13 -0300
Message-ID: <CAPWdmV_VxYf_Z9kJpgYV6q08W783mn82=wn_F4DyDWMCUpuSOg_at_mail.gmail.com>
Date: Wed, 27 Jul 2016 08:47:13 -0300
Message-ID: <CAPWdmV_VxYf_Z9kJpgYV6q08W783mn82=wn_F4DyDWMCUpuSOg_at_mail.gmail.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.
*--*
*Luis Santos*
2016-07-27 8:39 GMT-03:00 S3v3n11 <neisdsa_at_gmail.com>:
> dba_audit_session?
*Att*
>
> 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-lReceived on Wed Jul 27 2016 - 13:47:13 CEST