How to view User usage (recent logon, activity ...), Logon Activity

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