Hi,

We are having performance probelm for one session. Profile output of the session shows following entry at top. We are using AFS calls in this session.

count rtime call perc % ticks function
12 8.52 0.45 80.51 1995 :ottstpapihand

I have following questions

1) Time shown against "ottstpapihand", is it time it takes for loading
an object ??
2) Is it possible to get detail breakup of AFS execution time ?
3) Any ways to reduce time taken by "ottstpapihand" ?

We are using BaanERP 5.0B SP8 , Porting Set: 6.2a.03.01, Oracle 8.05

Thanks in advance

Profile information provided: is that info from session in profile mode or output of ORAPROF=0.0 ? I think with the latter you can see what queries do take performance and thus "deduce" what function call is involved.