Getting Oracle connected sessions in the past
- From: Luis Santos <lsantos@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2016 08:32:31 -0300
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*
Other related posts: