Generate tkprof output the 10046 trace files using following syntax

 # (change the file name, username & password):

    tkprof sys=no explain=/

   

    tkprof ${1} ${1}.log sys=no explain=sysadm/wdutsrff \

    waits=yes \

    sort=exeqry,fchqry,prsqry

    sort=exeela,exeqry,fchela,fchqry,prsela,prsqry

    sort=exeela,fchela,prsela

Hope this helps. Regards Rupam