Orace timeouts

[jayavardhanan]

Oracle instance is upgraded to 9.2.0.8 from 9.2.0.7.. getting time out exception when the traffice is even medium.

[waitecj]

Please post the exact error message you are getting.

[jayavardhanan]

When the user logs into our application, we call some stored procedures to get some data from the database, during that time the user request is not getting fullfilled and time outs.

Instance A in MMK was upgraded to 9.2.0.8, the one in B instance is still ver. 9.2.0.7.

Instance A without traffic shows minimum time per Oracle statement ~250 ms, spiking up to 2500 ms time to time (average at around 300 - 400 ms). If we bring traffic in, the time starts increasing constantly and when it reaches 10 - 14 seconds we start seeing timeouts. (That's not a surprise: new transactions have to wait for the executing ones).

B instance shows timing of 55 - 290 ms with or without traffic closer to the lower end - averaging at ~ 100 ms.

But no errors thrown by the database.

Thanks

[davey23uk]

trace the query, see what is going on - make sure your stats are up to date

[jayavardhanan]

Do you mean to say that query which is running properly in Instance B (Oracle 9.2.0.7) will create problem in 9.2.0.8.

We tested the querys, only one statement took more cpu cycles, it's been fine tuned to take lesse cpu, but we are facing the same issue.

Will it be any driver incompaitable issues?.

[davey23uk]

how about tracing the session and see where the time is being taken?

[waitecj]

Instance A in MMK was upgraded to 9.2.0.8, the one in B instance is still ver. 9.2.0.7.

Not 100% sure what you are saying here... Do you have different versions of Oracle for each instance in a RAC cluster?