User recursive calls in ST04

[Former Member]

Hi

Could anyone please explain me what is the field `User/ recursive calls` in ST04 view means? Does it anyway related to the performance of DB?

I had a error situation yesterday and after that the user /recursive calls value increased drastically to 14..earlier it was 4.4.

please clear my doubt.

regards,

Vinodh.

[Former Member]

Hi Vinodh,

Just like C language we have recurcsive calls in ABAP and SQL language.

You need to analyse why these calls have increased and look for the program/piece of code causing the calls.

Regards.

Ruchit.

[Former Member]

Hi,

Recursive calls occur when oracle itself must issue an SQL statement in addition to the SQL statement issued by the particular user process. For information of how to reduce the recursive calls, go thorugh page 51 of the below link:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/0667b7c9-0e01-0010-e4a3-873e8765...

Cheers,

Bharath