Dear Padman,

Thankyou for your reply, I now understand recursive/non recursive - however :

When TKPROFING, I set the argument sys=n so that system sql statement statisticts would not be shown.

I can still see that some statements were parsed anumber of times=, 9/10 times - do you know why ?

also - how can I get the system to use array fetching as I have noticed that a fetch is issued for each row retrieved.

Thanks in advance

Suresh