Check database user login history

Just making a quick post 🙂

I know this one will come handy in there future. I hope you find it useful too.

When you want to check login history from your database user, prior to oracle 10g (which is 9i and below) you only have two option:

1. Setup trigger that record whenever user login or logoff
2. Set your auditing session (aud$) and query it directly from the result

However they both require a lil bit knowledge. On the newer version of the database all you need is the query below

select * from dba_hist_active_sess_history

It will give you the same result you expect. You need to correlate the data with the user_id to see whose doing what. You can see user_id from the dba_users table 🙂

Hope you find it useful!

The lost one~