I did a tkprof for a trace file. The output is showing explain plan information for only few select statements but not for all the select statements. Can someone please let me know if I am missing some option while runing tkprof. Thanks in advance to everyone.