IFS Cloud 24.2.14
In our ongoing work to improve performance and be less sensitive to disruptions, we note that on the top list for "SQL ordered by Elapsed Time", during a working day this sql is in fifth place (10th place for "SQL ordered by CPU Time)":
sql_i: cbsvk03jynz6s
sql: BEGIN :1 := Login_SYS.Init_Odp_Session_(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 ); END;
We are wondering if the amount of executions that are made is reasonable. For example, this sql is executed three times when you open a simple form like System parameters.
One execution is very fast, but since there are over 10 million executions during a working day the total time elapsed is between 3 and 4 hours.
Anyone with knowledge about this?
Can there be an overhead of executions?
Regards,
Björn
