Hi. I have a question about fetch performance.

Hi. I have a question about fetch performance.

We have Siebel IP2016 (last patchset) and Oracle DB.

Sometimes we see long or very long Fetch Time (with fast SQL Execute Time).

We found following in log files(see timestamp):

Good (fast) log sample:

ObjMgrSqlCursorLog Fetch 5 0000000e5d2b1512:0 2019-07-15 09:16:15 Begin: Fetch for Sql Cursor at 9baca0f8

ObjMgrSqlCursorLog Fetch 5 0000000e5d2b1512:0 2019-07-15 09:16:15 End: Fetch for Sql Cursor 9baca0f8

Bad (long) log sample for similar function:

ObjMgrSqlCursorLog Fetch 5 0000000e5d2b1512:0 2019-07-15 09:34:15 Begin: Fetch for Sql Cursor at a648b670

ObjMgrSqlCursorLog Trace 5 0000000e5d2b1512:0 2019-07-15 09:35:52 Begin: Cache Pending Sql Cursors (count=2) on DB connection eb094348