User activity to the database

[lyang]

Where can I find the user activity against Oracle database?

[Dilippatel]

Hi

After connecting to SQLPLUS WITH SYS OR SYSTEM or any DBA Priviledge user, You can check in V$SESSION.

SELECT sid, serial#, username, substr(program,1,40) program, status, SQL_HASH_VALUE, osuser,
to_char(logon_time,'DD-MON-YYYY HH24:MI') Logon_time
FROM v$session

Dilipkumar Patel.