View SQL statement history performed by Oracle users

SELECT * FROM V$sqlarea t ORDER by t.last_active_time DESC

Note: Some related statements, such as executing this statement, must have DBA authority although this statement is common but useful when needed to detect a person executing a SQL statement in a timely manner

-------Oracle View the SQL that has been executed these are the---------that exist in the shared pool >
SELECT * FROM V$sqlarea t ORDER by t.last_active_time DESC

-----------View Oracle Session----------------------------

SELECT * FROM V$session t ORDER by t.last_active_time DESC

-------------View permissions roles for Oracle------------------------------>
SELECT * from Dba_role_privs; Roles granted to users and other roles
SELECT * from Dba_sys_privs; Granting system permissions to users and other roles
SELECT * from Dba_tab_privs; All authorizations for objects in the database
SELECT * from User_role_privs; View the role of the current user

View SQL statement history performed by Oracle users