tkprof analysis
Dear Experts,
Our apps version R12.2.5
DB RAC 12.1.0.2
We have a custom concurrent program which runs 5 minutes for some accounts for which we have less date.The same program when runs for other accounts where we have huge data,this program runs for 1 hour and starts consuming 100%cpu through out the completion.
When it runs for 5minutes,there is no cpu consumption.We have enabled trace for this program.Once the program completed,we have done tkprof with below options.
tkprof tracefile_name.trc tracefileoutput.txt explain=apps/apps sort='(exeela,prsela,fchela)'.
and the top command listed in tkprof is not showing any high elapsed times or cpu times.Is it normal?I dint understand where the time goes.