-
Orace timeouts
Oracle instance is upgraded to 9.2.0.8 from 9.2.0.7.. getting time out exception when the traffice is even medium.
-
Please post the exact error message you are getting.
Assistance is Futile...
-
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
-
trace the query, see what is going on - make sure your stats are up to date
-
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?.
-
how about tracing the session and see where the time is being taken?
-
Originally Posted by jayavardhanan
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?
Assistance is Futile...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|