如何查看存储过程执行计划

1.alter session set tracefile_identifier=10046;
2.alter session set events '10046 trace name  context forever,level 12';
3.exec GMM_UPDATE_PURCHASE_PLAN;
4.alter session set events '10046 trace name  context off';
5.tkprof orcl_ora_5000_10046.trc_10046.txt explain=lcam_develop/lcam_develop aggregate=yes sys=no waits=yes sort=fchela