Getting Oracle connected sessions in the past
From: Luis Santos <lsantos_at_pobox.com>
Date: Wed, 27 Jul 2016 08:32:31 -0300
Message-ID: <CAPWdmV9byUPfrcDkmByvk7O6fEV4ubHRYqrJAyC8U0WFXGCNZQ_at_mail.gmail.com>
This simple query shows connected users in the moment on an Oracle instance:
Date: Wed, 27 Jul 2016 08:32:31 -0300
Message-ID: <CAPWdmV9byUPfrcDkmByvk7O6fEV4ubHRYqrJAyC8U0WFXGCNZQ_at_mail.gmail.com>
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:32:31 CEST