login logout information in oracle11g
In Oracle 11g, I cannot get user's login/logon information properly . when a user logon and then logout from his session then I got the below information using the below specified sql query :
select username,userhost,timestamp,action_name,logoff_time from dba_audit_trail where
timestamp between to_date('03-FEB-2013 09:00:00','DD-MON-YYYY hh24:mi:ss') and
to_date('03-FEB-2013 23:00:00','DD-MON-YYYY hh24:mi:ss') and
action_name in ('LOGOG','LOGOFF') and username='TEST' order by timestamp desc
----
USERNAME, USERHOST, TIMESTAMP, ACTION_NAME, LOGOFF_TIME
"TEST",, 2/3/2013 12:18:09 PM, "LOGOFF",``` 2/3/2013 12:18:09 PM
"TEST",, 2/3/2013 12:17:57 PM, "LOGOFF", 2/3/2013 12:17:57 PM
---
Here in the output, during LOGON ,the output shows same time in the TIMESTAMP as well as LOGOFF_TIME fields . Also the LOGOUT moment, it also shows the same time in TIMESTAMP and LOGOFF_TIME fields . For this reason I cannot find out the proper information of a user's login/logout time .
Would any body help me , how I can find the login/logout information in Oracle11g environemtnt .