SQL tracing

Session SQL trace:

alter session set sql_trace=true;

Other session SQL trace:

exec dbms_system.set_sql_trace_in_session(session_id, serial_id, true);

Auto trace

CONNECT / AS SYSDBA
@$ORACLE_HOME/SQLPLUS/ADMIN/PLUSTRCE.SQL

drop role plustrace;
Role dropped.
create role plustrace;
Role created.
.
grant plustrace to dba with admin option;
Grant succeeded.

GRANT PLUSTRACE TO HR;

Other session SQL trace:

SET AUTOTRACE ON