How to view User usage (recent logon, activity ...), Logon Activity
1. Make sure the database has opened Audit
SQL> show parameter audit
NAME TYPE VALUE
----------------------------------------------------------------------------------------
Audit_file_dest string/u01/app/ora11/admin/ora11g/adump
Audit_sys_operations boolean FALSE
Audit_syslog_level string
Audit_trail string DB
Audit _ trail is db by default, and audit information is recorded to AUD $
For OS, audit information is stored in the operating system audit_file_dest =/u01/app/ora11/admin/ora11g/adump directory. If the directory is full, the application cannot connect to the database.
After you modify the configuration, restart the database to take effect.
2. * _ audit_session view to view the recent logon status.
Select * from DBA_AUDIT_SESSION
1 ora11 SYSTEM lixora pts/2 10: 25: 38 LOGON 9385910-12-14 10.25.38.898412 AM + 08:000 7129