You can use. If turned on the audit records
On 27 Jul 2016 12:49, "Luis Santos" <lsantos@xxxxxxxxx> 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@xxxxxxxxx>:
dba_audit_session?
On Wed, Jul 27, 2016 at 6:32 AM, Luis Santos <lsantos@xxxxxxxxx> 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*