Siebel performs row by row fetch ?
Hi All
I have an issue that I'm driving against Siebel Support.
Tracing (10046) our database users I can see this scenario for almost all sql executed
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 19 0.00 0.00 0 0 0 0
Execute 19 0.23 0.23 0 0 0 0
Fetch 432 5.85 5.90 0 1009741 0 430
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 470 6.08 6.13 0 1009741 0 430
My concern is that each fetch returns ~1 row 432/430=1. I believe the extra fetches
will add time to execution. We can see a low value for almost all statements running.
The following Note says that a higher value on arraysize can improve performance,
sqlplus is the example.