profiling

show parameter;

user_dump_dest string /u01/app/oracle/admin/orcl/udump

timed_statistics boolean TRUE

max_dump_file_size string UNLIMITED

exec dbms_monitor.session_trace_enable(null,null,true,true);

select 'hello' from dual;

exec dbms_monitor.session_trace_disable(null,null);