One of our applications is running slowly and we believe that it is the application causing it , not the database.
I have just traced and TKPROF'd a session in one of our Oracle Databases to establish how the code is being interpreted, whether or not it is using its indexes, how long it is taking to process.

The results seem fine to me, hardly any cpu/elapsed time, explain plan shows that the system is making use of indexes etc.

I do however have some queries regarding my output :

Does anybody know :-

Why some statements are parsed numerous amounts of times.

Why statements need to be executed a number of times to pull out the desired data.

Can you also please tell me what the difference between a recursive and non-recursive statement is.

Thanks in advance