I have been trying to analyze a performance problem for days now.
What I am really stumped with is that the same query, filtering on the same columns(different data of course), same database takes significantly longer for one user and not the other and I cannot figure out what is wrong. Any ideas greatly appreciated. Thanks.


Here's the tkprof output for slow performace:

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 14 0.01 0.00 0 0 0 0
Execute 14 0.02 0.01 0 0 0 0
Fetch 14 41.13 51.64 85995 85999 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 42 41.16 51.65 85995 85999 0 1

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 8



tkprof output for fast performance:

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 10 0.01 0.00 0 0 0 0
Execute 10 0.00 0.00 0 0 0 0
Fetch 10 0.00 0.00 0 36 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 30 0.01 0.00 0 36 0 2

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 8