Maximum Session Count used by an Oracle user ?
- We have Oracle 11g R2 database on Solaris
- there are around 20 oracle users
- there is a limit of around 600 sessions on the instance
Is there a way we can dig up history or some oracle system tables to find out as what was the max number of
sessions used by any user ? Now just for the current instance - from date "X".
Is there a table where oracle maintains some HWM (high water mark) for sessions count to show us as how many
sessions were used by user so far ? If by user is not possible atleast for the entire database from date X to Y.