================================================= 19/06/2011
use tkprof

  1. Login with oracle user
  2. Sqlplus system/xxxx@SHEMA
  3. alter system set sql_trace=true;
  4. show parameter user_dump_dest;
  5. Cd
  6. tkprof xxxxx.trc /tmp/myAnalyse.out explain=user/pass@SHEMA sort=execpu
  7. ne pas oublier : alter system set sql_trace=false;