trace self or other session

privilege related

trace session

show explain plan

1.
dba_roles -- list available role
dba_role_privs -- show who are granted what role
dba_sys_privs -- show who or which role are granted which system privilege

2.
alter user .. quota unlimited on tablespace_name

3.
In SQLPLUS, ? represent $ORACLE_HOME after @,@@,start

4.
1) begin
end
2) for var in start_val .. end_val loop
end loop;

5.
select plan_table_output from table(dbms_xplan.display('plan_table',null,'serial'))

6. trace special event
grant alter session to pcai;
alter session set tracefile_identifier = 'my_trace';
alter session set events '10104 trace name context forever, level 2'
alter session set events '10104 trace name context off';

7 To grant user access to v$session
grant select on v_$session to user_name

8. trace the running session
1) setup dbms_support package:
@?/rdbms/admin/dbmssupp
grant execute on dbms_support to user_name
create public synonym dbms_support for dbms_support
2) tracing/stop tracing running session
get sid, serial# from v$session
dbms_support.start_trace_in_session(sid=>sid_num, serial=>serial_num, wait=>true, binds=>true)
dbms_support.stop_trace_in_session(sid=>sid_num, serial=>serial_num)