SQL Performance (MOSC)

MOSC Banner

Siebel performs row by row fetch ?

edited Oct 27, 2015 9:26AM in SQL Performance (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center