View the history of SQL statements executed by oracle users

Usually used less, save it and view it later.
 
Select * from v $ sqlarea t where t. PARSING_SCHEMA_NAME in ('username') order by t. LAST_ACTIVE_TIME desc
The username must be capitalized.
Select * from v $ sqlarea t order by t. LAST_ACTIVE_TIME desc
Note: To execute this statement and other related statements, you must have the DBA permission. Although this statement is common, it can be used in a timely manner to detect the execution of SQL statements by a person.
------- Check the executed SQL in oracle. These SQL statements exist in the Shared Pool --------->
Select * from v $ sqlarea t order by t. LAST_ACTIVE_TIME desc
----------- View oracle sessions ----------------------------
Select * from v $ session t order by t. LAST_ACTIVE_TIME desc
------------- View oracle permission roles ------------------------------>
Select * from dba_role_privs; grant roles to users and other roles
Select * from dba_sys_privs; grant system permissions to users and other roles
Select * from dba_tab_privs; all permissions on objects in the database
Select * from user_role_privs; view the role of the current user