oracle DB, Check the history of the session information

If you want to know the past session information in an Oracle database

database 11.2 or later

To check the table

V$SQL_MONITOR

Descriptions : http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3052.htm#REFRN30479

V$ACTIVE_SESSION_HISTORY

Descriptions : http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1007.htm#REFRN30299

Looking at the table, 

Can know a session history information and resources.