Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Capture user login logout in oracle database

Vinoth kumar JayaseelanFeb 4 2025 — edited Feb 6 2025

Hi All,

I got a requirement to capture user login logout timestamp of database in any method like login via application, Sql development tool or any source. the purpose is to track all user login/logout information of database.

  1. We tried with logon and log off trigger but issue is log off Triger not fire when kill session or database shutdown.
  2. We tried to enable dba_audit_session but this table not capture session history because after database upgrade from 12c to 19c our DBA disabled audit session not sure about the reason. Now dba not able to enable again to fix this issue dba recommended to re-patch 19c upgrade but re-patch will impact current system behavior.

So apart from these two option do we have any other options to captre user login/ logout timestap in database level. please help on this.

Thanks,

Vinoth kumar.J

Comments
Post Details
Added on Feb 4 2025
2 comments
93 views